Responsibilities
- Design, build, and monitor complex ELT jobs that integrate disparate data sources into clean, high-integrity data assets.
- Contribute to and enforce data modeling policies, procedures, processes, and standards.
- Document system flows and other technical details related to data, database design, and surrounding systems.
- Develop data quality standards and implement tooling to safeguard data accuracy and reliability.
- Collaborate with Investment Management teams to understand new data patterns and requirements.
- Partner with Data Analysts, Data Architects, and BI developers to craft scalable data solutions aligned with business goals.
- Translate high level business requirements into detailed technical specifications.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related technical field.
- 8+ years of experience in data analytics, data modeling, and database design.
- 5+ years of experience with ELT methodologies and tools.
- 5+ years of experience designing, developing, tuning, and troubleshooting SQL.
- 3+ years of coding and scripting experience (Python, Java, Scala) and design work.
- 2+ years of experience with the Spark framework.
Technologies
- Python
- Java
- Scala
- SQL
- Spark
- Informatica PowerCenter
- Informatica IDMC
- Vertica
- Snowflake
- Power BI
- Tableau
- Blackrock Aladdin
- CRD
- Eagle STAR
- Eagle Pace
- Eagle DataMart
- GoldenSource
- FINBOURNE
- NeoXam
- RIMES
- JPM Fusion
Benefits
- Paid Time Off with holidays, flexible holidays, and additional care time for personal or family needs.
- Health & Well-Being medical and dental coverage, mental health resources, and wellness stipends.
- Financial Well-Being competitive compensation with 401(k) options and company contributions.
- Taking Care generous maternity and parental leaves, bereavement leave, and caregiver leave up to 320 hours.
- Giving Back three paid volunteering days and a foundation that matches donations up to $5,000 annually.
- Commuter Benefits pre-tax transit options and a commuter wallet for qualifying Boston and NYC campuses.
Overview
A career with MassMutual means collaborating with exceptional colleagues and pursuing professional and personal growth. The company emphasizes supporting employees as they work toward their goals, helping people secure their futures and protect what they love. The culture is built on mutual respect, inclusion, and belonging, reflecting the idea that people are stronger together.
Award-Winning Culture
MassMutual prioritizes its mission to help people secure their financial futures and protect loved ones. The organization operates for the benefit of members and policyowners, guided by mutuality and a commitment to financial well-being for all Americans. It aims to foster a community where everyone is valued and included, living the principle of mutual care.
How We Work
The company supports a flexible, hybrid work model that blends in-person collaboration with remote work. Employees are encouraged to come to the Boston or other campuses at least three days per week, with remote Fridays and periodic remote weeks to accommodate balance and focus.
Benefits for the Whole You
MassMutual takes a holistic view of compensation and benefits, offering core programs plus additional perks designed to support life beyond the job. In addition to medical and dental coverage and a 401(k) plan, employees gain access to wellness resources, volunteering opportunities, education assistance, and generous time off to balance personal and professional aspirations.
