Lead Business Intelligence Report Developer

About the role

The Lead Business Intelligence Developer is a key member of the Enterprise Data & Reporting (EDR) team, ensuring the Bank’s Business Intelligence solutions and infrastructure support the Bank’s strategic direction and tactical data and reporting needs. This role provides operational, technical, and thought leadership to Business Intelligence Developers (Report Developers) and is responsible for developing SSRS, Power BI, and other reporting tools in accordance with business requirements. The individual will also perform database development work to address production support issues and project-related tasks.

Responsibilities

• Review documented report specifications, clarify requirement ambiguity, develop report output, and unit test reports to confirm data accuracy.
• Work with internal customers, IT staff, and other stakeholders to define or refine requirements for business intelligence and reporting initiatives.
• Monitor and track the progress of reports assigned to each member of the report development team.
• Coordinate code reviews to ensure reports are written efficiently and in line with development standards.
• Proactively consult the Enterprise Data & Reporting Manager on project prioritization, vendor management, and resource allocation.
• Encourage and support team collaboration and coordinate knowledge sharing amongst the report development team.
• Work with Business Intelligence Analysts, internal customers, and external consulting teams to understand reporting requirements.
• Support QA and UAT testing as assigned.
• Support and train business users on reports and overall HUB data content.
• Ensure reporting solution development is documented in accordance with Data and Reporting Team standards.
• Design, develop, test, and deploy Power BI reports, dashboards, and datasets aligned with business requirements.
• Build and maintain Power BI semantic models using best-practice dimensional modeling (facts, dimensions, star schemas) in line with architectural standards.
• Develop complex DAX measures, calculated columns, and performance-optimized visuals.
• Use Power Query (M) to extract, transform, and cleanse data from the Hub and other source systems.

Qualifications

• 5-8 years' experience in SQL Development and SQL Server Reporting Services (SSRS).
• 5+ years' knowledge in Microsoft SQL Server, Visual Studio, Microsoft SSIS, and Azure DevOps.
• Strong experience developing visualization dashboards and paginated reports using Power BI.
• Experience utilizing Microsoft Fabric.
• Experience in integration and deployment across multiple environments.
• Must be analytical, results-driven, and able to employ the right approach and methods to maximize time and resources.
• Excellent interpersonal, creative, and communication skills that allow effective, proactive working relationships in a team-oriented environment.
• Ability to multitask, set priorities, and complete tasks within budgetary parameters and targets.
• Knowledge/experience with SQL queries and Business Intelligence concepts.
• Strong analytic skills and attention to detail.
• Able to build and maintain relationships and facilitate collaboration and communication.
• Able to work independently and collaborate with people at all levels.
• Ability to positively engage, self-motivate, and possess a strong desire to learn.

Pay

Annual Salary: $114,474.00 - $135,938.00. This range represents the Bank’s good faith and reasonable estimate of possible compensation at the time of hire. The offer will be determined by the selected applicant’s education, experience, knowledge, skills, and abilities, as well as internal equity and alignment with market data. This role is also eligible to participate in the Bank’s annual incentive plan.

Benefits

• 11 paid holidays.
• 5 weeks of PTO and a work culture that values work/life balance.
• Hybrid work schedule for most roles.
• 401(k) matching: 100% of the first 6% contributed, plus an additional 4% non-discretionary contribution at year-end.