Job Description

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.

The Lead Business Intelligence Developer is a key member of the Enterprise Data & Reporting (EDR) team ensures the Bank’s Business Intelligence solutions and infrastructure supports the Bank’s strategic direction and tactical data and reporting needs. This role is expected to provide operational, technical, and thought leadership to the Business Intelligence Developers (Report Developers). This is a highly technical role that is also responsible for development of SSRS, PowerBI, and other reporting tools in accordance with business requirements. This individual will also be expected to understand and perform database development work as part of addressing production support issues and project related work.

Accountabilities:

Responsibilities/Duties/Function/Tasks:

• Review documented report specifications, clarify requirement ambiguity, develop report output, and unit test the reports to confirm data accuracy.
• Works 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 consults 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.
• Works 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.
• Ensures 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:

• 8+ years’ experience in SQL Development, and SQL Server Reporting Services (SSRS).
• 5+ years’ knowledge in Microsoft SQL Server, Visual Studio, Microsoft SSIS, Microsoft SSRS, 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 multitasking and priority setting, and able to complete tasks on set budgetary parameters and targets.
• Knowledge/experience with SQL queries and Business Intelligence concepts.
• Strong analytic skills.
• Strong 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.

Compensation Range:

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.

As part of our competitive Total Rewards package, the Bank offers 11 paid holidays, 5 weeks of PTO and a work culture that values work/life balance. Most roles are eligible for our hybrid work schedule. We match 100% of the first 6% you contribute to your 401(k) and provide an additional 4% non-discretionary contribution to your 401(k) at the end of year. More information on our Total Rewards program can be found here

At FHLB Des Moines, we work to create an inclusive culture. This enables us to effectively serve the needs of our members and help them succeed. FHLB Des Moines is proud to be an Equal Opportunity Employer. We prohibit discrimination on the basis of race, color, religion, sex (including pregnancy, sexual orientation or gender identity), national origin, age, disability, veteran status, genetic information (including family medical history), status as a parent or any other characteristic protected by federal, state or local law.