Lead Data Engineer, Corporate Tech Data & Analytics

MassMutual; Springfield (MA); On-site; USD 130,000 - 180,000; Full time

Benefits offered by this job

Equal opportunity employer

Accommodations on request

Job summary

MassMutual is seeking a Data Engineer within Corporate Technology Data Engineering & Analytics to drive data and technology strategy for Investment Management. Build streaming and batch pipelines, data marts, and data warehouses while ensuring robust data collection and processing aligned with business requirements.

You’ll collaborate with Data Analysts, Data Architects, and BI developers to deliver scalable data solutions, translate business needs into technical specs, and uphold data quality

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems or related technical field.
• 8 years of experience with data analytics, data modeling, and database design.
• 5 years experience with ELT methodologies and tools.
• 5 years experience in designing, developing, tuning and troubleshooting SQL.
• 3 years of coding and scripting (Python, Java, Scala) and design experience.
• 2 years of experience with Spark framework.

Responsibilities

• Design, build, and measure complex ELT jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
• Executes and provides feedback for data modeling policies, procedure, processes, and standards.
• Assists with capturing and documenting system flow and other pertinent technical information about data, database design, and systems.
• Develop comprehensive data quality standards and implement effective tools to ensure data accuracy and reliability.
• Collaborate with various Investment Management departments to gain a better understanding of new data patterns.
• Collaborate with Data Analysts, Data Architects, and BI developers to ensure design and development of scalable data solutions aligning with business goals.
• Translate high-level business requirements into detailed technical specs.

Skills

Data analytics

Data modeling

Database design

ELT methodologies

SQL

Python

Java

Scala

Spark

Power BI

Tableau

Education

Bachelor's degree in Computer Science, Engineering, Information Systems or related technical field

Tools

Informatica PowerCenter

Informatica IDMC

Vertica

Snowflake

GoldenSource

FINBOURNE

NeoXam

RIMES

JPM Fusion

Power BI

Tableau

Job description

MassMutual is seeking a Data Engineer within Corporate Technology Data Engineering & Analytics to drive data and technology strategy for Investment Management. Build streaming and batch pipelines, data marts, and data warehouses while ensuring robust data collection and processing aligned with business requirements.

You’ll collaborate with Data Analysts, Data Architects, and BI developers to deliver scalable data solutions, translate business needs into technical specs, and uphold data quality