Business Data Consultant (Hybrid)

Principal Financial Group; Des Moines, Raleigh, Charlotte (IA, NC, NC); Hybrid; USD 73,000 - 105,000; Full time

Benefits offered by this job

Pension plan

Hybrid work environment

Job summary

Principal Financial Group seeks a Distribution Data Governance Data Steward to join the Benefits & Protection Distribution team in Des Moines. You will manage data definitions, quality rules, and taxonomy for Distribution subdomains and collaborate across governance and data platforms.

You'll lead data term certifications, map terms to technical attributes, and mentor analysts to raise governance fluency while ensuring data is trusted and fit for purpose in business decisions.

Qualifications

• Bachelor’s degree in Information Systems, Analytics, Finance, Business, Computer Science or related field, or equivalent experience.
• 4+ years of related work experience with reporting, analysis, development and administration.
• Intermediate SQL, profiling, validating and reconciling large datasets in cloud data platforms.
• Knowledge of metadata, business glossary, data quality rules, lineage, classification and master data.
• Data modeling literacy: ERDs, cardinality, keys, and dimensional modeling.
• Ability to lead working sessions and translate between business, technical and executive audiences.

Responsibilities

• Serve as a Data Steward for Distribution subdomains and represent B&P in sub-domain groups.
• Write and certify business term definitions, data quality rules and taxonomies.
• Link certified terms to technical attributes in the enterprise data catalog.
• Help designate Core Data Elements and Keys for data products.
• Lead root-cause analysis and remediation with data custodians, engineering and operations.
• Govern firm hierarchies and relationship mappings through acquisitions and restructures.
• Mentor analysts and raise governance fluency across the team.

Skills

SQL

Data governance

Data modeling

Leadership

Communication

Education

Bachelor's degree or equivalent

Tools

Snowflake

AWS

DB2

SAS

Power BI

Job description

What You’ll Do

The Distribution Data Governance team sits within Benefits & Protection Distribution. We are the business-side stewards of Distribution data: the firms, financial professionals and relationships that shape how Principal’s products are sold, serviced and retained. We work closely with Enterprise Data & Analytics Governance, the Distribution Data Domain Steering Group, Sales Compensation Administration, Master Data Management, Privacy, Compliance and B&P Data & Analytics. Together, we make sure the data behind partner strategy, and executive decisions is clearly defined, trusted and fit for purpose.

What You’ll Do:

• Serve as a Data Steward for Distribution subdomains, including Firm, Financial Professional and Distribution Relationships. Represent B&P in sub-domain working groups and bring recommendations to the Distribution Data Domain Steering Group.
• Write, refine and move business term definitions, data quality rules, taxonomy structures and entity relationship diagrams through certification. Settle conflicting definitions across business units.
• Link certified business terms to technical attributes in the enterprise data catalog, so definitions, classifications and quality standards carry through to the systems and data products that use them.
• Help designate Core Data Elements and Key Joining Attributes. Help data products built on the Enterprise Data Foundation reach full governance scores and certification.
• Lead root-cause analysis and remediation with Data Custodians, engineering and operations partners. Turn recurring issues into lasting controls instead of one-off fixes.
• Govern firm hierarchies, parent-child rollups and relationship mappings through acquisitions, consolidations and restructures. Assess downstream impacts on policy ownership, attribution and reporting.
• Contribute to data governance communities of practice, maturity scoring, newsletters and data literacy efforts. Mentor analysts and raise the team’s governance fluency.

Who You Are

We are looking for someone with:

• Bachelor’s degree in Information Systems, Analytics, Finance, Business, Computer Science or a related field, or equivalent experience.
• 4+ years of related work experience, with three years proven experience with a combination of reporting, analysis, development and administration
• Intermediate SQL, including profiling, validating and reconciling large datasets in cloud data platforms.
• Working knowledge of data governance disciplines: metadata, business glossary, data quality rules, lineage, classification and master data.
• Data modeling literacy: ERDs, cardinality, primary, foreign and surrogate keys, and dimensional modeling.
• Proven ability to lead working sessions to decisions and to translate between business, technical and executive audiences.

Preferred Qualifications:

• Experience in insurance, financial services or employee benefits distribution, especially broker and general agency ecosystems and firm hierarchies.
• Experience with enterprise data catalog or governance platforms (Data360, Ataccama, Alation or similar).
• Experience with data products, certification frameworks or data contracts.
• Technical experience with Snowflake, AWS, DB2, SAS, Power BI

How We Work:

• Steward mindset: You treat data as an enterprise asset, not a byproduct.
• Systems thinking: You see how a definition change propagates to a calculation, dashboard or report.
• Intellectual rigor: You validate first, and you show your work.

Salary Range Information

Salary ranges below reflect targeted base salaries. Non-sales positions have the opportunity to participate in a bonus program. Sales positions are eligible for sales incentives, and in some instances a bonus plan, whereby total compensation may far exceed base salary depending on individual performance. Actual compensation for all roles will be based upon geographic location, work experience, education, licensure requirements and/or skill level and will be finalized at the time of offer.

Salary Range (Non-Exempt expressed as hourly; Exempt expressed as yearly)

$73150 - $105000 / year

Time Off Program

Flexible Time Off (FTO) is provided to salaried (exempt) employees and provides the opportunity to take time away from the office with pay for vacation, personal or short-term illness. Employees don’t accrue a bank of time off under FTO and there is no set number of days provided.

Pension Eligible

Yes

Work Environments

This role offers in-office, hybrid (blending at least three office days in a typical workweek). You’ll work with your leader to figure out which option may align best based on several factors.

Work Authorization/Sponsorship

At this time, we're not considering candidates that need any type of immigration sponsorship (additional work authorization or permanent work authorization) now or in the future to work in the United States. This includes, but IS NOT LIMITED TO: F1-OPT, F1-CPT, H-1B, TN, L-1, J-1, etc. For additional information around work authorization needs please use the following links.

Nonimmigrant Workers and Green Card for Employment-Based Immigrants

Investment Code of Ethics

For Principal Global Investors positions, you’ll need to follow an Investment Code of Ethics related to personal and business conduct as well as personal trading activities for you and members of your household. These same requirements may also apply to other positions across the organization.

Experience Principal

While our expertise spans the globe, we’re bound by one common purpose: to foster a world where financial security is accessible to all. And our success depends on the unique experiences, backgrounds, and talents of our employees – individually and all of us together. Explore our core values, benefits and why we’re an exceptional place to grow your career.

Principal is an Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

Principal uses artificial intelligence tools to assist in reviewing and evaluating job applications, fraud prevention, and candidate matching and comparisons. These AI tools support our human recruiters in the initial review process but do not make final hiring decisions without human involvement. By submitting your application, you acknowledge this use of AI in our recruitment process. Please review our Workforce (U.S.) Privacy Notice for more details on our practices and your data privacy rights.