MDM Data Engineer
Boston, Massachusetts; Springfield, Massachusetts
Job ID: R16161
Overview
A career with us means you’ll help our customers secure their future and protect the ones they love. It also means you’ll work alongside exceptional people and be empowered to reach your professional and personal goals. Our employees are at the foundation of what makes MassMutual a strong, stable, and ethical business.
Our culture embodies the idea that we all are stronger and better through our support for one another. By valuing people for who they are, how they think, and what they bring to the table, we’ve become a better, more innovative company.
We invite you to explore the possibilities.
What our employees say
Job Description
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
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.
State and federal laws and regulations, including the Violent Crime Control and Law Enforcement Act, limit employment of individuals with certain criminal backgrounds.
EEO Statement(Opens in new window)MassMutual will accept applications on an ongoing basis until such time as a candidate has been offered employment.
Salary Range: $113,100.00-$148,400.00
Hiring Process
-
Explore
To get started, explore our open jobs by clicking 'search jobs' to find a position that aligns with your experience and skills. You may also consider joining our Talent Network to receive information on jobs that may interest you and stay up-to-date with the latest MassMutual news.
-
Apply
To apply for a specific position, please click the “apply” button on that job posting to complete and submit your application. Your application will be reviewed by a recruiter which, due to the volume of applications received, may take some time as we carefully consider each application.
-
Screen
After your application has been reviewed, if you meet the qualifications for the role, a recruiter will reach out to you to start a conversation.
-
Interview
If you are invited for an interview, you will be scheduled to meet with the hiring manager and hiring team. Coordinating calendars for interview schedules can take time, so your patience and flexibility is appreciated.
-
Offer
If you are extended an offer to join MassMutual and accept, your start will be contingent upon a satisfactory background check.
-
Hire
If you accept the offer, we will be so excited to welcome you to the MassMutual community!
Recruitment Fraud Awareness
Job recruiter fraud is a scam by impostors posing as recruiters or representatives of a company promoting fake job opportunities to job seekers.
MassMutual will never ask job candidates to pay any kind of fee, make cash or check advancements, cash checks or make an investment in any product or service or provide information such as credit card numbers or banking PIN numbers as part of our hiring process.
If you are contacted by anyone asking for information outlined above it is likely fraudulent. If you have any concerns about the veracity of a request, please contact us directly to verify its legitimacy.
If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.
Award-Winning Culture
MassMutual is guided by a single purpose: We help people secure their future and protect the ones they love. As a company operated for the benefit of our members and participating policyowners, we are defined by mutuality and our vision to provide financial well-being for all Americans. 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.
We strive to embrace diversity in every sense, focusing on building a thriving community where everyone is valued, included, and feels that they belong.
At MassMutual, we Live Mutual.
Benefits for the whole you (and your loved ones)
There’s more to your life than your job and there’s more to your aspirations than a paycheck. We take a holistic view of compensation and benefits that provides the flexibility to create a healthy balance in your life for work, family, and community. We offer the benefits you’d expect, like medical, dental, 401(k), and generous vacation time, but we also offer ones you might not expect, like three paid days for volunteering, a $1250 annual wellness wallet, and up to 320 hours of caregiver leave.
Explore some of our offerings below. Full benefits details can be found here.
- In addition to generous vacation time, paid holidays, and flexible holidays, MassMutual offers 'take care' time to take care of yourself or someone you love—whether for physical illness or mental health.
- Medical and dental insurance
- Life, disability short-term and long-term insurance
- Well-being wallet: $1,250 per year for a wide range of qualifying wellness expenses
- Well-being support: Mindfulness, nutrition, fitness
- Personalized mental health solutions
- Adoption and surrogacy reimbursement programs
- Competitive salary and bonuses
- 401(k): Up to 10% total benefit, consisting of a 5% company match and a 5% annual contribution
- Educational assistance program
- Childcare support
- Financial counseling
- Caregiver Leave (up to 320 hours)
- Maternity Leave (a total of 18 weeks, 10 maternity + 8 parental)
- Parental Leave (8 weeks for all parents, birth or adoption, continuous or intermittent)
- Bereavement Leave: Up to 15 days to mourn the loss of a loved one, and you define 'loved one'
- Matching Gift: 100% match on employees’ charitable contributions to non-profits up to $5,000
- Volunteering: Three paid days for employees to volunteer with eligible nonprofits of their choice
- Matching time: MassMutual Foundation awards dollars to organizations for which employees volunteer
- Qualified Commuter Program through which eligible employees can pay qualified workplace commuting expenses with before-tax dollars
- Commuter wallet option for employees based at Boston and NYC campuses
Why MassMutual?
Compliance Consultant
Service Management Consultant
Head of Experience Journey Mapping
How we work
MassMutual’s flexible workplace approach combines the importance of connecting in person and the flexibility of working remotely. Our hybrid model puts collaboration first with employees coming in at least three days per week to our spectacular campus settings and also enjoying the flexibility of remote Fridays, company-wide remote weeks, and a bank of flexible remote weeks to use throughout the year.
Where we work
Springfield Office
1295 State Street,
Springfield, MA
Boston Office
10 Fan Pier Blvd,
Boston, MA
New York Office
2 Park Ave,
New York, NY
Virtual
New Job Openings
-
SAP Business Analyst Springfield, Massachusetts
-
Business Operations Consultant (Staffing, Demand & Capacity) Springfield, Massachusetts
Interested in pursuing a career as a financial professional? Learn how you can build your business and help people secure their future and protect the ones they love.