Advanced Data Engineer 630 views

A career with them means you will work alongside exceptional people and be empowered to reach your professional and personal goals. Their employees are the foundation of what makes MassMutual a strong, stable, and ethical business. They seek and value unique and varied perspectives and experiences because they believe they are stronger when all voices are heard. They invite you to bring your bright, innovative ideas to MassMutual as they continue to help millions of Americans rely on each other.

Together, they are stronger

What Great Looks Like In This Role

Their ideal Advanced-Data Engineer is a collaborative leader skilled in data analytics, data modeling, and database design. You’re also committed to data integrity, are highly analytical, and can work on multiple projects at once. You’ll use your skills to develop, monitor, and manage data systems across our platform. Additionally, you will act as a mentor to junior team members and coach them on best practices and engineering standards. The team culture of working collaboratively, cross-functionally, using new technologies combined with the work/life balance provided by MassMutual are core reasons people enjoy working on the Data Analytics team at MassMutual.

Objectives of the role:

• Design, build, and measure complex ELT jobs to process disparate data sources and form high integrity, high quality, clean data asset.
• Working on a range of projects including batch pipelines, data modeling, and data mart solutions you’ll be part of collaborative project teams working to implement robust data collection and processing pipelines to meet the specific business needs.

Daily And Monthly Responsibilities

• Design, build, and measure complex ELT jobs to process disparate data sources and form high integrity, high quality, clean data asset.
• Executes and provides feedback for data modeling policies, procedures, processes, and standards.
• Assists with capturing and documenting system flow and other pertinent technical information about data, database design, and systems.
• Develop data quality standards and tools for ensuring accuracy.
• Work across departments to understand new data patterns.
• Translate high-level business requirements into technical specs.

Basic Qualifications

• Bachelor’s degree in computer science or engineering.
• 5+ years of experience with data analytics, data modeling, and database design.
• 3+ years of coding and scripting (Python, Java, Scala) and design experience.
• 3+ years of experience with Spark framework.
• Experience with ELT methodologies and tools.
• Expertise in tuning and troubleshooting SQL.
• Strong data integrity, analytical, and multitasking skills.
• Excellent communication, problem-solving, organizational, and analytical skills.
• Able to work independently.

Preferred Qualifications

• Master’s degree in computer science or engineering.
• Familiar with agile project delivery process.
• Knowledge of SQL and use in data access and analysis.
• Ability to manage diverse projects impacting multiple roles and processes.
• Able to troubleshoot problem areas and identify data gaps and issues.
• Ability to adapt to a fast-changing environment.
• Experience with Python.
• Basic knowledge of database technologies (Vertica, Redshift, etc.).
• Experience designing and implementing automated ETL processes.