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!
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 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
Willing to consider applicants at multiple job levels.
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!
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.