Logo for BAI

Advanced Power Business Intelligence Developer

Role overview

Summary

This role focuses on developing and supporting data warehouse and business intelligence solutions for ProSight Financial Association. You will work with the IT team to enhance user experiences through interactive visualizations and ensure that analytics models meet the needs of external users.

Qualifications

  • Bachelor’s degree in computer science or related field.
  • 8+ years professional experience.
  • 7+ years in data warehouse / business intelligence space.
  • 1+ years of on-the-job Azure Fabric experience.
  • Power BI embedded experience targeting external private audiences.

Responsibilities

  • Utilize Azure Fabric and other interactive visualization tools to create user experiences for external audiences.
  • Provide application development, support, and model building for Analytics work by the research department.
  • Analyze data sources and explore performance improvements within Fabric.
  • Work closely with business partners to document requirements and translate them into technical specifications.

Key facts

Hard skills

Key skills for this role

Other skills

  • Critical Thinking
  • Problem Solving
  • Communication
  • Collaboration
  • Detail Oriented
  • Analytical Skills

About the company

BAI logo

BAI

  • Professional Associations
  • 51–200
BAI provides financial services leaders with the industry's most actionable insights. For over 90 years, BAI's mission has been to empower leaders to make smart business decisions, drive positive change, and move the industry forward. Because a strong financial services industry helps consumers, businesses, and communities thrive. For more information, please visit bai.org.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Advanced Power Business Intelligence Developer, ResearchReports To: Lead, Product Development 

ProSight Financial Association is a non-profit industry organization that helps banks and credit unions drive sustainable growth with a strong foundation of risk, compliance and fraud management. ProSight was formed in 2024 from the merger of BAI and RMA, trusted industry organizations with over a century of experience serving financial services leaders. We help leaders act with confidence by offering industry-leading insights, training, events, analytics, tools and resources. Our work creates positive ripple effects throughout financial services organizations and ultimately helps consumers, businesses and communities thrive.  

The ProSight IT team partners with its functional business associates to define the company’s technology strategy, deliver innovative applications and continuously improve its internal and customer-facing technology assets.  We are seeking an Advanced Data Warehouse / Power BI Developer who has a broad understanding of data warehouse and interactive visualization development for external / customer facing consumption.  A successful candidate must have an affinity towards user experience (UX), superior DW, SQL, DAX, and data modeling development skills and be a self-motivated, critical thinker.

Responsibilities

  • Utilize Azure Fabric and other interactive visualization tools to create compelling and intuitive user experiences for an external audience in custom and secure portals. The experience will include reports, interactive dashboards and other functionalities.

  • Provide application development, support, and model building to be used for Analytics work by the research department. Provide models for external users.

  • Utilize and set up Microsoft Azure Fabric environment and then educate others across the organization on Fabric tools use and advantages.

  • Analyze data sources, aggregation tables, explore different levers withing Fabric for performance improvements.

  • Perform analysis, design, develop, and maintain systems and subsystems, as it pertains to back-end databases.

  • As needed: create data models, advanced SQL queries and Stored Procedures; update and/or create reports/dashboards.

  • Work closely with business partners and stakeholders to determine and document business and functional requirements, translating those into detailed technical specifications and running code.

  • Responsible for the documentation of and adherence to current development standards; to seek opportunities to utilize current or additional applications to create process improvements.

  • Coordinate and support testing activities (including development of test cases and scheduling of test events with key IT staff and users) for changes and releases (both internal and vendor based) to web applications supported by the ProSight IT applications group.

  • Be able to identify and solve problems on your own, with minimal supervision.

  • Proactively identify opportunities to utilize current or innovative technical solutions to improve business processes and/or products that provide additional revenue, cost savings or efficiency gains.

  • Create Solution/Application Architecture recommendations.

  • Develop and implement deployment plans for promotion of application code through all environments.

Requirements

  • Bachelor’s degree in computer science or related field required.

  • 8+ years professional experience required.

  • 7+ years in data warehouse / business intelligence space required.

  • 7+ years SQL development required.

  • 1+ years of on-the-job Azure Fabric experience required.

  • Power BI embedded experience required. This experience must target external private audiences, not internal and/or public reports.

  • Custom Web Dashboard development experience required.

  • SSIS experience preferred.

  • Python and .NET skills would be highly preferred.

  • Experience with Agile software development methodologies required,

  • This individual must be highly motivated, self-directed, and possess solid execution and follow-up skills.

  • The ability to probe beyond the surface of the requested data to get valuable (actionable) information is essential.

  • Detail-oriented but understands broader impacts of projects and tasks.

  • The ability to expand on the original request/question to deliver the data/answer and the information on how it relates on a larger scale.

  • Must be able to check and validate the results of their own and other’s work. 

  • Adjust quickly to changing priorities as directed.

  • Excellent written and verbal communication skills.

  • Needs to possess a strong analytical, quantitative and objective outlook.

  • Excellent people skills are also necessary since this position may interact with all levels of resources across the entire organization.

The salary range for this position is $110,000 - $140,000.  Compensation offered will be determined by factors such as skills, experience, education, job-related knowledge and market considerations.  This role is eligible for an annual incentive plan based on business results and individual performance.  ProSight offers an outstanding benefits package with comprehensive insurance coverage, a 401(k) plan with company match, flexible paid time off, hybrid and remote working models, tuition reimbursement and the ability to work in a collaborative, team-oriented environment.

To learn more about our company please visit www.prosightfa.org.

Related jobs

See all Business Intelligence Developer jobs

Other jobs at BAI