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 Business Intelligence Developer is a member of the Enterprise Data & Reporting (EDR) team responsible for developing, testing, deploying, and supporting enterprise reporting and business intelligence solutions. This role works closely with Business Intelligence Analysts, senior Business Intelligence Developers, business stakeholders, and technical teams to deliver reporting solutions that enable data-driven decision making throughout the Bank.
The Business Intelligence Developer is primarily responsible for developing Power BI reports, semantic models, paginated reports, SQL queries, and other reporting assets while learning enterprise standards, best practices, and reporting methodologies. This role contributes to reporting initiatives and production support activities under the guidance of senior team members.
Accountabilities:
Responsibilities/Duties/Function/Tasks:
- 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 utilizing 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 accuracy and completeness of reporting solutions.
- 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 reporting 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 activities.
- Continuously develop technical skills related to Power BI, SQL Server, Microsoft Fabric, and Business Intelligence technologies.
- Perform other duties as assigned.
Qualifications:
- 1+ years of experience in SQL development, reporting, business intelligence, or data analytics.
- 1+ years of experience developing reports and dashboards using Microsoft Power BI.
- Experience with Microsoft SQL Server, SSRS, Visual Studio, Azure DevOps, or similar development tools.
- Experience supporting reporting or analytics solutions preferred.
- Exposure to software development lifecycle (SDLC) methodologies preferred.
- 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.
Compensation Range:
Annual Salary: $72,750.00 - $86,391.00
This salary range represents the Bank's good faith and reasonable estimate of possible compensation at the time of hire. Offer to be determined by selected applicant’s education, experience, knowledge, skills & abilities, as well as internal equity and alignment with market data. This role is also eligible to participate in the Bank’s annual incentive plan.
As part of our competitive Total Rewards package, the Bank offers 11 paid holidays, 5 weeks of PTO and a work culture that values work/life balance. Most roles are eligible for our hybrid work schedule. We match 100% of the first 6% you contribute to your 401(k) and provide an additional 4% non-discretionary contribution to your 401(k) at the end of year. More information on our Total Rewards program can be found here.
At FHLB Des Moines, we work to create an inclusive culture. This enables us to effectively serve the needs of our members and help them succeed. FHLB Des Moines is proud to be an Equal Opportunity Employer. We prohibit discrimination on the basis of race, color, religion, sex (including pregnancy, sexual orientation or gender identity), national origin, age, disability, veteran status, genetic information (including family medical history), status as a parent or any other characteristic protected by federal, state or local law.