Data Engineer - Corporate Technology Data Engineering & Analytics

MassMutual; Boston (MA); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Restaurant d'entreprise

Indemnités de stage/alternance

Job summary

MassMutual is seeking a Data Engineer within Corporate Technology Data Engineering & Analytics to drive data and technology strategy across Investment Management. You will build streaming and batch pipelines, data marts, and data warehouses to support business requirements.

You will collaborate with data analysts, data architects, BI developers, and business stakeholders to deliver scalable, high-quality data solutions while translating complex requirements into technical specifications and

Qualifications

• Bachelor's degree in a technical field and 8+ years of data analytics experience.

Responsibilities

• Design, build, and optimize ELT pipelines for multiple data sources to deliver high-quality data assets.
• Develop data quality standards and monitoring tools to ensure data accuracy.
• Collaborate with Investment Management stakeholders and data teams to translate requirements into technical specs.
• Document data flows, schemas, and system interactions for governance and transparency.
• Support scalable data solutions aligned with business goals.

Skills

Data analytics

Data modeling

Database design

ELT

SQL

Python

Java

Scala

Spark

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

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

LI-RK1

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.

California residents: For detailed information about your rights under the California Consumer Privacy Act (CCPA), please visit our page.