Senior BI Engineer: Power BI & Data Analytics Leader

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

Benefits offered by this job

Hybrid work schedule

11 holidays

PTO 5 weeks

401(k) match + employer contribution

Job summary

FHLB Des Moines is seeking a Senior Business Intelligence Developer to design, develop, test, and support enterprise reporting and BI solutions. You will build Power BI reports, semantic models, and paginated reports while mentoring BI Developers and aligning with enterprise standards.

You will collaborate with BI Analysts, stakeholders, data engineers, and technical teams to deliver data-driven reporting that supports strategic objectives and operational needs.

Qualifications

• 3+ years of SQL development and BI development.
• 3+ years of Power BI report/dashboard development.
• 3+ years with Microsoft SQL Server, Visual Studio, SSRS, SSIS, and Azure DevOps.
• Experience delivering enterprise reporting solutions.
• Experience with structured SDLC practices.
• Familiarity with Microsoft Fabric (preferred).
• Strong SQL, data modeling, and query optimization knowledge.
• Experience building Power BI semantic models and dimensional modeling.
• Experience creating Power BI reports, dashboards, and paginated reports.
• Knowledge of DAX, M, and data transformation techniques.

Responsibilities

• Review report specifications and clarify requirements with stakeholders.
• Design, develop, test, and deploy Power BI reports, dashboards, scorecards, and datasets.
• Build and maintain Power BI semantic models using enterprise dimensional standards.
• Develop complex DAX measures, calculated columns, KPIs, and optimized reporting solutions.
• Use Power Query (M) to extract, transform, and prepare data from enterprise sources.
• Develop and maintain SQL queries, stored procedures, views, and other DB objects.
• Develop and support paginated reports using SSRS.
• Perform unit testing and validation to ensure data accuracy and completeness.
• Investigate and resolve complex data-related issues.
• Support QA and UAT activities and collaborate with BI Analysts and stakeholders.
• Participate in report design discussions and advocate enterprise standards.
• Conduct peer code reviews and contribute to best practices.
• Assist in maintaining reporting standards and documentation.
• Support and mentor BI Developers with knowledge sharing.
• Create technical documentation per ED&R standards.
• Identify opportunities to improve performance, usability, scalability, and maintainability.
• Provide user support for report functionality and data questions.

Skills

SQL development

Power BI

SQL Server

SSRS

SSIS

DAX

Power Query (M)

ETL/ELT concepts

Azure DevOps

Data warehousing

Tools

Azure DevOps

GitLab

Job description

FHLB Des Moines is seeking a Senior Business Intelligence Developer to design, develop, test, and support enterprise reporting and BI solutions. You will build Power BI reports, semantic models, and paginated reports while mentoring BI Developers and aligning with enterprise standards.

You will collaborate with BI Analysts, stakeholders, data engineers, and technical teams to deliver data-driven reporting that supports strategic objectives and operational needs.