Senior BI Developer: Power BI & Data Analytics Lead

Federal Home Loan Bank of Des Moines; Iowa (LA); Hybrid; USD 91,000 - 108,000; Full time

Benefits offered by this job

Hybrid work schedule

Total Rewards package

401(k) matching

Job summary

Federal Home Loan Bank of Des Moines is seeking a Senior Business Intelligence Developer to design, develop, test, deploy, and support enterprise BI solutions. The role collaborates with BI Analysts, stakeholders, data engineers, and technical teams to deliver reporting assets that drive data-driven decisions across the Bank.

You will build Power BI reports and semantic models, write complex SQL, and mentor BI Developers while upholding development standards.

Qualifications

• 3+ years of experience in SQL Development and BI development.

Responsibilities

• Review documented report specifications and collaborate with stakeholders to clarify business requirements.
• Design, develop, test, and deploy Power BI reports, dashboards, scorecards, and datasets aligned with business requirements.
• Build and maintain Power BI semantic models utilizing enterprise dimensional modeling standards and best practices.
• Develop complex DAX measures, calculated columns, KPIs, and performance-optimized reporting solutions.
• Use Power Query (M) to extract, transform, and prepare data from enterprise source systems.
• Develop and support paginated reports using SQL Server Reporting Services (SSRS).
• Perform unit testing and validation procedures to ensure data accuracy, quality, and completeness.
• Investigate, troubleshoot, and resolve complex reporting and data-related issues.
• Support Quality Assurance (QA) and User Acceptance Testing (UAT) activities.
• Collaborate with Business Intelligence Analysts, business stakeholders, developers, data engineers, and external partners to deliver reporting solutions.
• Participate in report design discussions and recommend technical approaches that align with enterprise standards.
• Conduct peer code reviews and contribute to development best practices.
• Assist in establishing and maintaining reporting development standards and documentation.
• Support and mentor Business Intelligence Developers through knowledge sharing and technical guidance.
• Create and maintain technical documentation in accordance with Enterprise Data & Reporting standards.
• Identify opportunities to improve reporting performance, usability, scalability, and maintainability.
• Support business users with report functionality and data-related questions as needed.
• Stay current on emerging technologies, including Microsoft Fabric, Power BI enhancements, and business intelligence best practices.
• Perform other project and duties as assigned.

Skills

SQL development

Power BI development

Analytical skills

Communication skills

Collaboration

Tools

Microsoft SQL Server

Visual Studio

Azure DevOps

SSRS

SSIS

GitLab

Power BI

Job description

Federal Home Loan Bank of Des Moines is seeking a Senior Business Intelligence Developer to design, develop, test, deploy, and support enterprise BI solutions. The role collaborates with BI Analysts, stakeholders, data engineers, and technical teams to deliver reporting assets that drive data-driven decisions across the Bank.

You will build Power BI reports and semantic models, write complex SQL, and mentor BI Developers while upholding development standards.