> Markdown version of [/jobs/ext/184077-lead-business-intelligence-report-developer](https://www.wearedevelopers.com/jobs/ext/184077-lead-business-intelligence-report-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Business Intelligence Report Developer - **Company:** Federal Home Loan Bank of Des Moines - **Location:** Des Moines, IA, United States - **Experience:** Expert - **Salary:** $114,474.0 - $135,938.0 - **Contract:** Permanent contract - **Skills:** Unit Testing, Microsoft Azure, Code Review, Database Development, Dimensional Modeling, Microsoft Visual Studio, Microsoft Software, Microsoft SQL Server, Power BI, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Enterprise Data Management, Powerquery, Microsoft Fabric, Tools for Reporting - **Published:** May 22, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=d72dced8146af17d ## About the Role Do you have experience in Visual Studio?, * 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. ## Description 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., * 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Are Code Reviews Worth It? Insights from 16 Years of Review Data](https://www.wearedevelopers.com/videos/1135-are-code-reviews-worth-it-insights-from-16-years-of-review-data) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Build a CI/CD pipeline to automate code reviews and ensure code quality](https://www.wearedevelopers.com/videos/349-build-a-ci-cd-pipeline-to-automate-code-reviews-and-ensure-code-quality) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Biggest German Tech Companies](https://www.wearedevelopers.com/magazine/424-the-biggest-german-tech-companies) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)