Principal Financial Group Data Engineer, Data Warehouse/ETL - #222316 in Des Moines, Iowa

Job Area: ITBusiness Area: PGI OtherLocation: IA - Des MoinesCareer Category: Experienced ProfessionalFull/Part Time: Full-TimeRegular/Temporary: RegularDate Posted: 2018-10-11


Principal Global Investors is looking for an experienced Data Engineer with 4+ years of experience and in-depth knowledge of data warehousing principles and ETL data manipulation tools to join our team and empower the team to continuously mature our critical data ecosystem. If you have a programming background and are looking to use those skills to maintain, improve, clean, manipulate and enhance data in both operational and analytics databases, then please consider applying today!

Responsibilities include:

  • Handle large datasets, both clean and un-clean, and work with teammates to build technical data infrastructure solutions and models that are scalable, fast, maintainable and reusable.

  • Design, implement and maintain enterprise data warehouse and data marts including development of proof-of-concepts in alignment with data and analytics vision and strategy.

  • Develop ETL specifications, source to target mappings and other documentation required for ETL development

  • Understand and aid in implementation of database requirements, troubleshoot issues, analyze and optimize performance.

  • Development and deployment of robust and scalable data platforms for advanced analytics and data processing.

  • Help architect, build and launch highly scalable and reliable data pipelines.

  • Accountable for leading and mentoring other team members in best practices, standardization and procedures around data warehousing and development processes to ensure data quality and integrity

  • Research, maintain and evaluate emerging data engineering and warehousing technologies and solutions for continuous improvements to solve business problems.


  • Associate's or Bachelor's degree in a science, technology, engineering, or math related field or equivalent work experience (6 years of experience equates to an Associate’s degree when defining “equivalent work experience”)

  • 4+ years of Data Engineering experience (preferably working in an ODS or Data Warehouse)

  • Preference will be given to candidates who have a strong Software Development/Engineering background

Additional preferred technical experience:

  • Cloud computing, data movement and analysis - AWS ecosystem

  • Database design - SQL, no-SQL, JSON, file and data tagging

  • Operational and Enterprise data, reporting data marts and services

  • Data processing and analysis - R and Python scripting

  • Data visualization - MS PowerBI

  • Data optimization

  • Data architecture, modeling, storage, mapping, transformation, utilization, analytics

Keys to success in this position:

  • Eagerness to learn and apply a basic to advanced knowledge of investment management products and services

  • Strong work ethic

  • Ability to challenge the status quo

  • Desire to continuously improve

  • Aptitude for solving problems using resources available

  • Servant leadership

Job Level

Willing to consider applicants at multiple job levels.

Additional Information

What’s next? Innovation at its finest.

We’ll review your application and if you’re selected for an interview, you’ll receive an invite for a pre-recorded interview experience. Haven’t done that before, don’t worry. We’ve got all the tips and tricks available to help you be successful. With a pre-recorded interview, you can add your own flair and personality – at your pace.

Be sure to check your email frequently. We’ll communicate our decisions through the email address used on your online profile. If you receive an email from our Principal Talent Acquisition Team, you’ve been selected to begin your pre-recorded interview experience and have a set time to submit.

Benefits designed with you in mind.

Because each employee is unique, our benefit packages give you lots of choices. We offer comprehensive benefits that helps contribute to the healthy, fulfilling life and gratifying work experience you deserve, at an affordable cost. Click here to see just a few benefits you’ll receive once you join our team.

Not an exact match for this role?

We’ve got a lot of opportunities, so check out some of the others. And creating an email alert on our career site will help you keep you connected and informed of opportunities you’re interested in with a just a few clicks!

Work Authorization/Sponsorship

At this time, we're not able to consider candidates who would need sponsorship now or in the future or those needing work authorization for this role. (This includes students on F1-OPT, F1-CPT, J-1, etc.) However, we’d hope you continue to keep us in mind for other potential opportunities in the future.

Principal is an Affirmative Action and Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to of age, race, color, religion, sex, gender identity, gender expression, pregnancy, national origin, citizenship status, disability, genetic characteristics, sexual orientation, marital status, domestic partner status, military status, protected veteran status, disability status or any other characteristic protected by law.

Investment Code of Ethics

For positions with Principal Global Investors, you will be required to comply with a Code of Ethics which covers a number of obligations 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.