M

MFS

Global asset manager of mutual funds

Senior Data Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-timeBoston, MA, USA

About the Job

Requirements

  • A bachelor's degree in Computer Science or a related discipline is required.
  • Three to five or more years of experience in data engineering, data quality assurance, data testing, or supporting data-oriented applications and platforms is required.
  • Strong hands-on SQL experience is required, including advanced SQL concepts and the ability to develop complex queries for data validation, reconciliation, and troubleshooting.
  • Demonstrated experience performing quality assurance or testing of data pipelines, ETL/ELT processes, data warehouses, or analytics platforms is required.
  • Experience validating data transformations, business rules, source-to-target mappings, data completeness, accuracy, and integrity is required.
  • Experience developing, maintaining, or testing data models using dbt (Data Build Tool) is required.
  • Development or testing experience with cloud-based PaaS platforms such as Microsoft Azure, Google Cloud Platform, or Amazon Web Services is required.
  • Familiarity with Agile software development lifecycle, quality assurance methodologies, DevOps practices, continuous integration/continuous delivery processes, and automated testing is required.
  • Strong analytical and problem-solving skills are required.
  • Applicants must be currently authorized to work in the United States on a full-time basis.

Responsibilities

  • Develop and maintain data models in dbt within Snowflake, implementing business logic and adhering to established data standards and architectural principles.
  • Design, develop, and execute SQL-based data validation and quality assurance testing for data pipelines, transformations, data models, and warehouse solutions.
  • Develop complex SQL queries to validate data accuracy, completeness, consistency, and integrity across source and target systems.
  • Perform data reconciliation, regression testing, root-cause analysis, and validation of ETL/ELT processes and business rules.
  • Contribute to automated data quality and testing capabilities, including validation of dbt models and transformation pipelines.
  • Improve data quality, resiliency, controls, monitoring, and operational efficiency across the investment data platform.
  • Troubleshoot data and system issues, identify root causes, and support resolution efforts in partnership with engineering and business teams.
  • Partner with engineers, platform leads, architects, and business stakeholders to define test scenarios, acceptance criteria, and data validation requirements.
  • Support integration and testing of data ingestion, transformation, orchestration, and validation tools within the unified data platform.
  • Provide operational and production support, including validation and troubleshooting during unexpected outages or incidents.

Desired Qualifications

  • Experience with Snowflake or other cloud-native databases is preferred.
  • Exposure to financial services, investment management, or investment data domains is preferred.
  • Experience working within the asset management industry and investment data domain is preferred.
  • Understanding of financial instruments, investment data, transactions, positions, and multi-asset investment platforms is preferred.
  • Certifications in Snowflake, dbt, cloud data engineering technologies, or related data platforms are a plus.
  • Interest in emerging artificial intelligence technologies and understanding of how AI-driven tools can improve engineering workflows, operational efficiency, and analytics processes is beneficial.
  • Experience using automation or AI-assisted development tools to support continuous improvement initiatives is beneficial.

About the Company

MFS

Global asset manager of mutual funds

MFS Investment Management is a global asset manager that runs mutual funds and active ETFs for individuals, financial advisors, and institutions. It manages money with an active investment approach, meaning portfolio managers pick securities they believe will outperform over time, and then structure these ideas into mutual funds and active ETFs. The company combines a long history (dating back to 1924 with the creation of the first mutual fund) and a global footprint under Sun Life Financial to offer a diverse set of investment products. Its difference lies in an established track record, collaborative active management, and a broad client base across regions, with about $619.6 billion in assets under management as of May 2025. The goal is to generate long-term value for clients by actively managing portfolios and seeking performance across markets.

Company size
1,001-5,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Boston, MA
Founded
1924

Recently Posted Jobs

Explore more opportunities at MFS

See more jobs