Business Intelligence Developer
Federal Home Loan Bank of Des Moines Des Moines, Iowa, United States · $73K–$86K/yr
Financial Services · 201-500 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
The Business Intelligence Developer is responsible for developing, testing, and deploying enterprise reporting solutions including Power BI dashboards and SQL queries. They collaborate with stakeholders and technical teams to ensure data-driven decision-making through accurate reporting and semantic modeling.
What they look for
Requirements
Candidates must have at least one year of experience in SQL development, reporting, or data analytics, including proficiency with Microsoft Power BI. Strong analytical skills and a solid understanding of relational databases and data modeling fundamentals are required.
Benefits
Full description
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.00This 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.
Similar roles
-
DECISION SUPPORT - BUSINESS INTELLIGENCE DEVELOPER
Beebe Healthcare Lewes, Delaware, United States · $75K–$116K/yr
-
Sr. Associate, Business Intelligence
Grant Thornton Chicago, Illinois, United States · $76K–$114K/yr
-
Business Intelligence Engineer, ASP Ops - WWSO Sales & Biz Ops
Amazon Toronto, Ontario, Canada · CA$76K–CA$128K/yr
-
Intermediate Power BI Developer
Diné Development Corporation Quantico, Virginia, United States · $95K–$112K/yr
-
ALTERNANT CHEF DE PROJET IT - DATA & BUSINESS INTELLIGENCE (H/F)
Achat Solutions La Garenne-Colombes, Ile-of-France, France
-
Lead Business Intelligence Developer- Remote
UPMC United States