Data Engineer – Corporate Technology Data Engineering & Analytics

MassMutual; Boston (MA); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading insurance and financial services company is seeking a Data Engineer to drive their data and technology strategy. This role involves building data solutions, establishing robust pipelines, and collaborating with various teams on impactful Corporate Technology initiatives. The ideal candidate will have extensive experience in data analytics and SQL, along with strong skills in Python and Spark framework.

Qualifications

• 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 experience.

Responsibilities

• Design, build, and measure complex ELT jobs to process disparate data sources.
• Develop comprehensive data quality standards and implement effective tools.
• Collaborate with Data Analysts, Data Architects, and BI developers.
• Translate high-level business requirements into detailed technical specs.

Skills

Data analytics

Data modeling

SQL

Python

Java

Scala

Spark framework

Reporting tools (Power BI, Tableau)

Analytical and problem-solving skills

Education

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

Tools

Informatica Power Center

Informatica IDMC

Vertica

Snowflake

Job description

The Opportunity

Join our dynamic team as a Data Engineer – Corporate Technology Data Engineering & Analytics, where you'll play a pivotal role in driving the execution of our data and technology strategy. This role is crucial in driving digital transformation and operational efficiency across Investment Management. As part of this role, you will engage in building data solutions including streaming and batch pipelines, data marts & data warehouse. You will be responsible for establishing robust data collection and processing pipelines to fulfill Investment Management business requirements.

The Team

You’ll be an integral part of our Corporate Technology Team, focused on Data Engineering & Analytics. Our team operates on a global scale, driving innovation and excellence across diverse areas of expertise. As a Data Engineer, you'll play a critical role in high impact Corporate Technology Investment Initiatives, ensuring alignment with organizational objectives and driving impactful outcomes. This is an opportunity to collaborate closely with Corporate Technology Data and Analytics team and Investment management business stakeholders. Our team thrives on collaboration, innovation, and a shared commitment to excellence. Together, we're shaping the future of technology within our organization and making a lasting impact on a global scale. Join us and be part of a dynamic team where your contributions will be valued and your potential unleashed.

The Impact

• 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.

The Minimum 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.

The Ideal Qualifications

• Knowledge of Informatica Power center and Informatica IDMC.
• Knowledge of distributed, column- orientated technologyto create high-performant database technologies like - Vertica, Snowflake.
• Strong data analysis skills for extracting insights from financial data
• Proficiency in reporting tools (e.g., Power BI, Tableau).
• Domain knowledge of Investment Management operations including Security Masters, Securities Trade and Recon Operations, Reference data management, Pricing.
• Familiarity with regulatory requirements and compliance standards in the investment management industry.
• Experience with IBOR’s such as Blackrock Alladin, CRD, Eagle STAR (ABOR), Eagle Pace, and Eagle DataMart.
• Familiarity with investment data platforms such as GoldenSource, FINBOURNE, NeoXam, RIMES, and JPM Fusion.
• Strong analytical and problem-solving abilities.
• Exceptional communication and interpersonal skills.
• Ability to influence and motivate teams without direct authority.
• Excellent time management and organizational skills, with the ability to prioritize multiple initiatives.

MassMutual is an equal employment opportunity employer. We welcome all persons to apply. If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.