Data Engineer - Corporate Technology Data Engineering & 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

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.