Lead Business Intelligence Report Developer

At FHLB Des Moines, we work each day to develop an inclusive culture that supports and leverages the complexity of a diverse workforce. This enables us to effectively serve the needs of our members and help them succeed.

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 supports the Bank's strategic direction and tactical data and reporting needs. This role provides operational, technical, and thought leadership to the Business Intelligence Developers (Report Developers). It is a highly technical role responsible for the development of SSRS, PowerBI, and other reporting tools in accordance with business requirements, as well as database development work for production support and project-related tasks.

Responsibilities

• Review documented report specifications, clarify requirement ambiguity, develop report output, and unit test the 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 that 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 PowerBI.
• 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 make the maximum use of time and resources.
• Excellent interpersonal, creative, and communication skills that allow effective, proactive working relationships in a team-oriented environment.
• Ability to multitask, prioritize, and complete tasks within set 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 salary range represents the Bank's good faith and reasonable estimate of possible compensation at the time of hire. Offer to be determined by selected applicant's education, experience, knowledge, skills & 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% you contribute, plus an additional 4% non-discretionary contribution at the end of the year.