Senior Data Manager

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

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 Members Division Data Manager is responsible for data management activities including data quality, data integration, reporting and business analytics tools. This role is also responsible for designing, developing, testing, and supporting enterprise reporting and business intelligence solutions. The role supports the product lines within the members division and collaborates with other departments or divisions to ensure the data needs of the division are met and managed. The role also produces tools, apps, reports, and participates in bank-wide data related projects to support the sales teams and contributes to achieving our business goalsAccountabilities:Responsibilities/Duties/Function/Tasks: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.Working with Member Strategies and IT partners, 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 reportingDevelop 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 dataCreate 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.Qualifications:Bachelor’s degree in Computer Science, Data Analytics, or a similar field of study or equivalent work experienceSeven (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.Excellent understanding of data integration, data quality and data administration/management functions.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.Compensation Range:Annual Salary: $114,474.00 - $135,938.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.