Software Engineering, Sr. Data Engineer

At MFS, you will find a culture that supports you in doing what you do best. Our employees work together to reach better outcomes, favoring the strongest idea over the strongest individual. We put people first and demonstrate care and compassion for our community and each other. Because what we do matters – to us as valued professionals and to the millions of people and institutions who rely on us to help them build more secure and prosperous futures.

THE ROLE

The Investment Data Management Office is seeking a Senior Investment Data Engineer with strong SQL and data quality assurance experience to support the implementation, testing, and maintenance of modern data engineering and analytics solutions. This role will contribute to the development, validation, enhancement, and support of investment data platforms and pipelines while partnering closely with data architects, platform engineers, investment teams, and vendor partners. The ideal candidate brings a strong QA mindset, advanced SQL skills, and experience validating complex data transformations and pipelines. 

Are you a hands-on and detail-oriented individual interested in financial instruments, investment data, and analytics? Do you enjoy solving complex data challenges and building scalable data solutions? Are you interested in working across a broad range of traditional and alternative asset classes while collaborating with business and technology teams in a fast-paced environment?

PRINCIPAL 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 QA 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.

• Assist in improving 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.

JOB REQUIREMENTS: 

• Bachelor’s degree in Computer Science or 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).

• Experience with Snowflake and/or other cloud-native databases is preferred.

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

• Exposure to financial services, investment management, or investment data domains is preferred.

• Strong analytical, problem-solving, interpersonal, and communication skills.

PREFERRED QUALIFICATIONS

• 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 are a plus. 
• 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 is beneficial. 

Applicants must be currently authorized to work in the United States on a full-time basis. This position is not eligible for sponsorship.

#LI-SS1

Base Salary Range: $98,500.00 - $141,500.00

This position is eligible for competitive incentive bonus. 

At MFS, we believe in fair and transparent compensation. For that reason, we’re including the salary range for this position. This range reflects our good-faith expectation for what we’ll pay depending on the candidate’s experience, training and education. In addition to the salary, we also offer significant and competitive incentive compensation based on both individual and company performance. Other components of our Total Rewards Package include:

• MFS contributes an amount equal to 15% of your base salary to your retirement account that is separate from the company -sponsored 401(k) 

• Education Assistance: MFS contributes $100 monthly up to $10,000 lifetime maximum directly to loan provider

• Education Assistance: Tuition reimbursement up to $8,000 annually 

• Education Assistance: Access to discounted tutors and college coaches

• Generous time off and fully paid leaves including 20-weeks for maternity, 12-weeks for parental and caregiver leaves

• Choice of medical and dental plans and an and an employer contribution into the Health Savings Account

• Tax deferred commuter benefits & flexible spending accounts (medical & dependent care)

• Wellness Programs: Robust wellness webinars, employee assistance program with a focus on mental health, subsidized fitness benefit via Wellhub (formerly Gympass), where you can workout at gyms, studios and boutique fitness locations near you, join virtual personal training sessions and access a wide variety of well-being apps

Our compensation philosophy is to pay competitively for talent while ensuring equity across employees performing comparable work. We are committed to transparency – if you have questions about how we arrived at this range or what additional benefits and bonus opportunities come with the role, we’ll be happy to discuss them

#LI-HYBRID

At MFS, we are dedicated to building a diverse, inclusive and authentic workplace. If you are excited about this role but your past experience doesn't align perfectly, we encourage you to apply - you might be just the right candidate for this role or others.

MFS is a hybrid work environment (remote/onsite) unless otherwise stated in the job posting.

If any applicant is unable to complete an application or respond to a job opening because of a disability, please contact MFS at 617-954-5000 or email talent_acquisition@mfs.com for assistance. 

MFS is an Equal Opportunity Employer and it is our policy to not discriminate against any employee or applicant for employment because of race, color, religion, sex, national origin, age, marital status, sexual orientation, gender identity, genetic information, disability, veteran status, or any other status protected by federal, state or local laws. Employees and applicants of MFS will not be subject to harassment on the basis of their status. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited. Please see the Know Your Rights: Workplace Discrimination is Illegal document, linked for your reference.