Lead Business Intelligence Report Developer

Federal Home Loan Bank of Des Moines•Des Moines, IA

2d•$114,474 - $135,938•Hybrid

About The Position

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.

Requirements

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 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.

Responsibilities

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.