Data Engineer

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

Job summary

SoTalent is partnering with a leading global financial institution to recruit a Senior Data Engineer. You will help modernize the Investment Management data ecosystem, architect advanced data products, and build high-performance batch and streaming pipelines to support strategic decisions.

You will collaborate with global architects and analysts, drive data modeling standards, ensure data quality, and mentor peers while delivering scalable warehouse solutions and impactful insights for

Qualifications

• Bachelor’s degree in CS, Engineering, or related quantitative field.
• 8+ years in Data Engineering, Data Modeling, and Database Design.
• 5+ years with ELT methodologies and SQL tuning.
• 3+ years of professional experience in Python, Scala, or Java.
• 2+ years of experience with the Spark framework.

Responsibilities

• Architect and maintain ELT/ETL workflows to synthesize diverse data sources into a unified data asset.
• Define and implement data quality frameworks and monitoring tools for reliable financial information.
• Partner with Investment Management stakeholders to translate business needs into robust specifications.
• Collaborate on data modeling standards and evolve database architecture.
• Mentor peer developers and provide feedback on system design and documentation.

Skills

ELT/ETL development

SQL tuning

Python/Scala/Java

Data modeling

Data quality monitoring

Mentoring

Education

Bachelor's degree in CS/Engineering or related field

Tools

Spark

Snowflake

Informatica IDMC

PowerCenter

Tableau

Power BI

Job description

Location: Springfield

The Opportunity

I am currently partnering with a leading global financial institution to find a seasoned Senior Data Engineer. This is a high-impact role within their Corporate Technology division, focusing specifically on the modernization of their Investment Management data ecosystem. You will be at the forefront of their digital transformation, architecting advanced data products, high-performance pipelines (batch and streaming), and scalable warehouse solutions that directly influence investment strategies and operational efficiency.

The Role

• In this position, you will bridge the gap between complex financial data and actionable insights. Working alongside a global team of architects and analysts, you will:
• Architect and maintain sophisticated ELT/ETL workflows to synthesize diverse data sources into a unified, high-integrity data asset.
• Define and implement rigorous data quality frameworks and monitoring tools to ensure the reliability of critical financial information.
• Partner with Investment Management stakeholders to translate complex business needs into robust technical specifications.
• Collaborate on data modeling standards and contribute to the evolution of the firm’s database architecture.
• Mentor peer developers and provide technical feedback on system design and documentation.

Core Requirements

• Education: Bachelor’s degree in CS, Engineering, or a related quantitative field.
• Experience: 8+ years in Data Engineering, Data Modeling, and Database Design.
• Tooling: 5+ years of hands-on experience with ELT methodologies and expert-level SQL tuning/troubleshooting.
• Coding: 3+ years of professional experience in Python, Scala, or Java.
• Big Data: 2+ years of experience utilizing the Spark framework.

Preferred Qualifications (The "Plus" List)

• FinTech Domain: Specific experience with Investment Management operations (Security Masters, Trade Recon, Pricing, or Reference Data).
• Platforms: Exposure to IBOR/ABOR systems (e.g., Aladdin, Charles River, Eagle STAR/Pace) or investment data hubs (e.g., GoldenSource, FINBOURNE, NeoXam).
• Modern Stack: Familiarity with Snowflake, Vertica, or other columnar distributed databases.
• ETL Tools: Knowledge of Informatica IDMC or PowerCenter.
• Visualization: Proficiency in reporting tools like Tableau or Power BI.
• Soft Skills: A consultative mindset with the ability to influence cross-functional teams and manage competing priorities in a fast-paced environment.

Why Apply?

This is a chance to work for a prestigious firm that values innovation and collaboration. You will have the autonomy to build modern data solutions that have a direct, tangible impact on global investment operations while working in a team that prioritizes professional growth and technical excellence.

Our client is an equal opportunity employer and values diversity at their company.