Senior Data & BI Manager - Hybrid Power BI & SQL Analytics

Federal-Home-Loan-Bank-of-Des-Moines-1; Des Moines (IA); Hybrid; USD 114,000 - 136,000; Full time

Benefits offered by this job

Hybrid work schedule

11 paid holidays

5 weeks PTO

401(k) match

Job summary

FHLB Des Moines is seeking a Data Manager in the Members Division to lead data management, quality, and BI efforts. You will design, develop, and support enterprise reporting and analytics solutions, including Power BI dashboards, data quality initiatives, and data integration across product lines.

You will collaborate with IT and business partners, build robust reporting tools, and ensure data accuracy to drive sales enablement and strategic decisions.

Qualifications

• Bachelor’s degree in Computer Science, Data Analytics, or a similar field of study or equivalent work experience
• Seven (7) or more years in a data analytics, data management, and or data reporting role and preferably a minimum of three (3) years of this experience within the financial services industry or other regulated industry
• Strong organizational skills, able to manage multiple priorities and deadlines and handle ambiguity
• Extensive Experience with business analytics/BI tools such as Power BI, Tableau and Qlik for creating data visualizations
• Extensive experience working with SQL/complex queries and proficiency in statistical programming/scripting language
• Self-starter, equally willing to work independently and as a member of a team
• Strong collaboration and team management skills
• Ability to build relationships and work well with team members and internal business partners
• Proficient in Microsoft Word, PowerPoint, and Excel

Responsibilities

• Design, develop, test, and deploy Power BI reports, dashboards, scorecards, and datasets aligned with business requirements
• Fosters relationships with product line groups and other stakeholders in the Members Division to identify data and reporting needs to support business objectives
• Represent Members Division on bank-wide projects that impact data and system needs for the Division
• Work with IT partners to manage the Division’s Qlik apps or other data reporting apps
• Coordinate with product line sales teams to create a robust and effective sales enablement data reporting
• 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 maintain SQL queries, stored procedures, views, and other database objects to support reporting requirements
• Perform UAT testing and validation procedures to ensure data accuracy, quality, and completeness
• Investigate, troubleshoot, and resolve complex reporting and data-related issues
• Identify opportunities to improve reporting performance, usability, scalability, and maintainability
• Support business users with report functionality and data-related questions as needed
• Where necessary, provide effective training and support to product line teams to ensure effective access to and use of data
• Create on-demand reports and assist with data extraction as needed to support product line teams and executive management
• Help manage required regulatory reporting as needed
• Coordinate with Member Strategies to manage inventory of End User Computing (EUC) tools including development, maintenance and validation
• Manage external vendor relationships that support the data and reporting needs of the Members Division.

Skills

Data analytics

Data management

Data reporting

Stakeholder collaboration

Problem solving

Education

Bachelor's degree in Computer Science or Data Analytics

Tools

Power BI

Tableau

Qlik

SQL

Job description

FHLB Des Moines is seeking a Data Manager in the Members Division to lead data management, quality, and BI efforts. You will design, develop, and support enterprise reporting and analytics solutions, including Power BI dashboards, data quality initiatives, and data integration across product lines.

You will collaborate with IT and business partners, build robust reporting tools, and ensure data accuracy to drive sales enablement and strategic decisions.