Business Intelligence Developer

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

1d•Hybrid

About The Position

The Business Intelligence Developer is a member of the Enterprise Data & Reporting (EDR) team and is responsible for developing, testing, deploying, and supporting enterprise reporting and business intelligence solutions. The role works closely with Business Intelligence Analysts, senior Business Intelligence Developers, business stakeholders, and technical teams to deliver reporting that supports data-driven decision making throughout the Bank. The developer primarily creates Power BI reports, semantic models, paginated reports, SQL queries, and other reporting assets while learning enterprise standards, best practices, and reporting methodologies. The role contributes to reporting initiatives and production support under the guidance of senior team members. It also supports users, participates in testing and design discussions, maintains documentation, and develops technical skills in Power BI, SQL Server, Microsoft Fabric, and business intelligence technologies.

Requirements

At least 1 year of experience in SQL development, reporting, business intelligence, or data analytics.
At least 1 year of experience developing reports and dashboards using Microsoft Power BI.
Experience with Microsoft SQL Server, SSRS, Visual Studio, Azure DevOps, or similar development tools.
Working knowledge of SQL development and database concepts.
Understanding of relational databases and data modeling fundamentals.
Familiarity with Power BI reports, dashboards, and semantic models.
Knowledge of DAX and Power Query (M) fundamentals.
Understanding of business intelligence and reporting concepts.
Understanding of source control and deployment processes.
Strong analytical and problem-solving skills.
Strong attention to detail and data accuracy.
Effective verbal and written communication skills.
Ability to manage multiple assignments and priorities.
Ability to work collaboratively with technical and business teams.
Strong organizational and time management skills.
Self-motivated, with a strong desire to learn and develop technical expertise.
Commitment to delivering high-quality reporting solutions.

Nice To Haves

Experience supporting reporting or analytics solutions.
Exposure to software development lifecycle (SDLC) methodologies.

Responsibilities

Review documented report specifications and seek clarification when requirements are unclear.
Develop, test, and deploy Power BI reports, dashboards, and datasets based on business requirements.
Build and enhance Power BI semantic models using established dimensional modeling standards.
Develop DAX measures, calculated columns, KPIs, and visualizations to support business reporting needs.
Use Power Query (M) to extract, transform, cleanse, and prepare data from enterprise systems.
Develop and support SQL queries, views, stored procedures, and other reporting-related database objects.
Build and enhance paginated reports using SQL Server Reporting Services (SSRS).
Perform unit testing and data validation to ensure reporting solutions are accurate and complete.
Investigate and resolve standard production reporting issues and data discrepancies.
Support QA and User Acceptance Testing (UAT) activities.
Collaborate with Business Intelligence Analysts, business stakeholders, and technical teams to understand requirements and deliver reporting solutions.
Participate in report design discussions and contribute technical recommendations.
Follow established development standards, coding practices, and documentation requirements.
Participate in code reviews and development team knowledge-sharing activities.
Create and maintain technical documentation in accordance with Enterprise Data & Reporting standards.
Support business users with report-related questions and troubleshooting.
Continuously develop technical skills related to Power BI, SQL Server, Microsoft Fabric, and business intelligence technologies.
Perform other duties as assigned.