Browse thousands of opportunities across our network of innovative companies
MDM Data Engineer
MassMutual
Data Science
Multiple locations
Posted on Aug 20, 2024
Objectives of the role
As an MDM Data Engineer, you will work in a fast-paced, innovative, and collaborative environment on exciting data management directives. You will design, build, and measure complex Informatica Power Center and MDM processes to master data for different Master Data domains in MassMutual. This role involves working on a range of projects including batch pipelines, data modeling, and Master Data solutions to implement robust data collection and processing pipelines to meet specific business needs.
The Team
The Data Platform Data Engineering team comprises a diverse group of data engineers, analysts, and data architects who are passionate about data integrity and innovation. The team is motivated by the opportunity to drive business decisions through accurate and reliable data. We foster a collaborative culture where knowledge-sharing and continuous learning are encouraged. Our MDM team is dedicated to mastering data management processes that are essential for MassMutual's data-driven strategies.
The Impact:
- Design, construct, and evaluate intricate ELT/ETL tasks: Assimilate data from diverse sources into a high-quality, reliable data repository, directly impacting the accuracy of MassMutual's data-driven decisions.
- Develop Master Data Management (MDM) solutions: Implement solutions across various master data domains within MassMutual, ensuring data consistency and reliability.
- Provide comprehensive support for MDM solutions: Manage data ingestion, master record creation, outbound data extracts, and API integration to maintain seamless data operations.
- Implement data modeling policies and procedures: Establish standards for data modeling, contributing to the efficiency and consistency of data processes.
- Collaborate across departments: Engage with various teams to understand emerging data patterns, translating high-level business needs into precise technical specifications.
- Actively engage in the development and rollout of MDM Solutions and other Information Management initiatives at MassMutual.
- Establish data quality benchmarks and develop tools/processes to ensure data accuracy.
The Minimum Qualifications
- Bachelor’s degree in computer science or engineering.
- 5+ years of experience with Informatica Power Center.
- 5+ years of experience in data analytics, data modeling, and database design.
- 3+ years of coding and scripting (Python, Java, Scala) and design experience.
- 3+ years of experience with the Informatica MDM platform in the customer/party subject area.
- 3+ years of experience in ELT methodologies, SQL tuning, and troubleshooting.
- 3+ years of experience with Oracle database and AWS.
- 2+ years of experience with basic UNIX commands and shell scripts.
- 3+ years of experience with RESTful APIs and near real-time mastering via SIF.
The Ideal Qualifications
- Master’s degree in computer science or engineering.
- Familiarity with agile project delivery processes.
- Proficiency in SQL and data access/analysis.
- Ability to manage diverse projects impacting multiple roles and processes.
- Experience with Python, Kafka, and database technologies like Vertica or Redshift.
- Experience designing and implementing automated ETL processes.
- Willingness to provide Level 2 support for batch processing cycles outside business hours.
What to Expect as Part of MassMutual and the Team
- Regular collaboration with the Data Management Team.
- Focused one-on-one time with your manager.
- Access to mentorship opportunities.
- Networking opportunities, including access to Asian, Hispanic/Latinx, African American, women, LGBTQ, veteran, and disability-focused Business Resource Groups.
- Access to learning content on Degreed and other informational platforms.
- Your ethics and integrity will be valued by a company with a strong and stable ethical business, with industry-leading pay and benefits.
#LI-RK1
Salary Range:
$113,100.00-$148,400.00At MassMutual, we focus on ensuring fair equitable pay, by providing competitive salaries, along with incentive and bonus opportunities for all employees. Your total compensation package includes either a bonus target or in a sales-focused role a Variable Incentive Compensation component.
Why Join Us.
We’ve been around since 1851. During our history, we’ve learned a few things about making sure our customers are our top priority. In order to meet and exceed their expectations, we must have the best people providing the best thinking, products and services. To accomplish this, we celebrate an inclusive, vibrant and diverse culture that encourages growth, openness and opportunities for everyone. A career with MassMutual means you will be part of a strong, stable and ethical business with industry leading pay and benefits. And your voice will always be heard.
We help people secure their future and protect the ones they love. As a company owned by our policyowners, we are defined by mutuality and our vision to put customers first. It’s more than our company structure – it’s our way of life. We are a company of people protecting people. Our company exists because people are willing to share risk and resources, and rely on each other when it counts. At MassMutual, we Live Mutual.
MassMutual is an Equal Employment Opportunity employer Minority/Female/Sexual Orientation/Gender Identity/Individual with Disability/Protected Veteran. We welcome all persons to apply. Note: Veterans are welcome to apply, regardless of their discharge status.
If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.
At MassMutual, we focus on ensuring fair, equitable pay by providing competitive salaries, along with incentive and bonus opportunities for all employees. Your total compensation package includes either a bonus target or in a sales-focused role a Variable Incentive Compensation component. For more information about our extensive benefits offerings please check out our Total Rewards at a Glance.