Software Engineering, Sr. Data Engineer

MFS Investment Management•Boston, MA

4d•$98,500 - $141,500•Hybrid

About The Position

The Investment Data Management Office is seeking a Senior Investment Data Engineer to support the implementation, testing, and maintenance of modern data engineering and analytics solutions. The role contributes to developing, validating, enhancing, and supporting investment data platforms and pipelines, working closely with data architects, platform engineers, investment teams, and vendor partners. The ideal candidate has a strong quality-assurance mindset, advanced SQL skills, and experience validating complex data transformations and pipelines. This hands-on role involves working with financial instruments, investment data, and analytics across traditional and alternative asset classes. The engineer will collaborate with business and technology teams in a fast-paced environment to solve data challenges and build scalable solutions.

Requirements

Bachelor’s degree in Computer Science or a related discipline.
3–5+ years of experience in data engineering, data quality assurance, data testing, or supporting data-oriented applications and platforms.
Strong hands-on SQL experience, including advanced SQL concepts and the ability to develop complex queries for data validation, reconciliation, and troubleshooting.
Demonstrated experience performing QA/testing of data pipelines, ETL/ELT processes, data warehouses, and/or analytics platforms.
Experience validating data transformations, business rules, source-to-target mappings, data completeness, accuracy, and integrity.
Experience developing, maintaining, or testing data models using dbt (Data Build Tool).
Development or testing experience with cloud-based PaaS platforms such as Microsoft Azure, Google GCP, or Amazon AWS.
Familiarity with Agile SDLC, QA methodologies, DevOps practices, CI/CD processes, and automated testing.
Strong analytical, problem-solving, interpersonal, and communication skills.
Currently authorized to work in the United States on a full-time basis; this position is not eligible for sponsorship.

Nice To Haves

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

Responsibilities

Develop and maintain data models in dbt within Snowflake, implementing business logic and following established data standards and architectural principles.
Design, develop, and execute SQL-based data validation and QA testing for 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.
Help 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 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.

Benefits

Competitive incentive bonus based on individual and company performance.
MFS contributes an amount equal to 15% of base salary to a retirement account separate from the company-sponsored 401(k).
Education assistance: $100 monthly contribution toward a loan provider, up to a $10,000 lifetime maximum.
Tuition reimbursement up to $8,000 annually.
Access to discounted tutors and college coaches.
Generous time off and fully paid leaves, including 20 weeks for maternity leave and 12 weeks for parental and caregiver leaves.
Choice of medical and dental plans and an employer contribution to a Health Savings Account.
Tax-deferred commuter benefits and flexible spending accounts for medical and dependent care.
Wellness webinars and an employee assistance program focused on mental health.
Subsidized fitness benefit through Wellhub, including access to gyms, studios, virtual personal training, and well-being apps.