Software Engineering Lead Data Engineer

MFS Investment Management; Boston (MA); Hybrid; USD 110,000 - 159,000; Full time

Benefits offered by this job

Retirement match 15%

Tuition reimbursement

Education assistance

Wellness programs

Flexible spending

Job summary

MFS Investment Management is seeking a Lead Data Engineer to join the Enterprise Data Management Office and help unify our investment data. You will design and implement data pipelines, maintain dbt models in Snowflake, and partner across teams to deliver trusted data for investment, risk, and client reporting.

The role emphasizes hands-on engineering, agile collaboration, and continuous improvement, with a hybrid work setup and strong focus on data quality and scalable architecture within a

Qualifications

• Bachelor's degree in Computer Science or related disciplines.
• 5-6+ years of experience designing and building data-oriented applications.
• 2-4 years of hands-on experience from SQL to Advanced SQL.
• Hands-on dbt development and data modeling experience.
• Experience managing dbt transformation workflows.
• Experience in ETL/ELT, data warehouse, and analytics architecture with Snowflake and cloud databases.
• Experience on cloud PAAS platforms (Azure, AWS, GCP).
• Strong knowledge of Agile SDLC, DevOps, and diverse tech environments.
• Knowledge of UD M, data mesh, event-driven architectures, and real-time data flows.
• Experience in financial services data domain is a plus.
• Strong interpersonal and cross-team collaboration skills.

Responsibilities

• Design, develop, and implement data pipelines for the unified data platform.
• Create and maintain technical design and architecture docs.
• Develop and execute unit tests and document results.
• Develop and maintain dbt models in Snowflake with business logic.
• Lead dbt projects and ensure code quality and documentation.
• Build scalable data pipelines and a robust data warehouse for reporting.
• Lead development activities to meet business requirements.
• Develop data pipelines from internal and external systems.
• Drive data quality, resiliency, and operational reliability.
• Troubleshoot complex system interactions and root causes.
• Collaborate with platform/data architects to upgrade integration tools.
• Support enterprise architecture alignment and modernization initiatives.
• Leverage AI-assisted development and automation to improve productivity.
• Provide support during outages.

Skills

Data engineering

SQL

dbt

Snowflake

Cloud platforms

Agile SDLC

Data pipelines

ETL/ELT

Data modeling

Team leadership

Education

Bachelor's degree in Computer Science or related

Tools

dbt (Data Build Tool)

Snowflake

Azure Cloud

AWS Cloud

Google Cloud

Job description

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

In conjunction with the Enterprise Data Management Office, the Lead Data Engineer contributes to a long-term strategic initiative to unify and harmonize our investment data. This initiative enables enhanced investment decision making, risk management and client reporting for our multi-asset platform by delivering consistent, timely, accurate and user-friendly data to investors, risk teams and clients.

Are you a hands-on and detailed-oriented individual working on the cutting edge of financial instruments, investment data, and analytics? Are you interested in investment data strategies across a wide variety of traditional and alternative asset classes? Are you a thinker who enjoys devising innovative and flexible business solutions to meet emerging business needs?

The MFS Enterprise Data Management Office is actively searching for a Lead Data Engineer to implement data engineering and analytics solutions. Primary responsibilities include full implementation and maintenance of data ingestion, data maintenance, data validation and data delivery of investment data. We are looking for someone who thrives in an agile, collaborative, team-based environment, working closely with technology peers across MFS, investment professionals and key vendor partners. This position offers the opportunity to shape the future of investment data at MFS.

WHAT YOU WILL DO

• Design, develop, and implement data pipelines to maintain the unified data platform for the Enterprise Data Management Office.
• Create and maintain detailed technical design and architecture documentation to support development, implementation, and ongoing enhancement of data engineering solutions.
• Develop and execute comprehensive unit tests, ensuring thorough test coverage and clear documentation of test cases and results.
• Develop and maintain data models in dbt (Data Build Tool) within Snowflake, implementing business logic and ensuring alignment with existing architecture and enterprise data standards.
• Manage and contribute to dbt projects, ensuring code quality, proper documentation, and alignment with modular, scalable design patterns.
• Design, build, and administer scalable data pipelines and a robust data warehouse to support reporting, analytics, and operational use cases.
• Lead and participate in all development activities, developing and implementing solutions to meet business requirements aligned with strategic program objectives.
• Responsible for new and ongoing development of data pipelines sourcing from internal and external systems.
• Drive continuous improvement of data quality, resiliency, control, efficiency, monitoring, and operational reliability.
• Troubleshoot complex system interactions to identify and resolve root causes of issues.
• Partner with platform leads to design, develop, implement, and deploy new software components to the investment data platform.
• Partner with data architects to evaluate and finalize the unified data model.
• Partner with integration architects to upgrade and integrate data ingestion and data delivery tools with the unified data platform.
• Upgrade and integrate transformation tools, data validation tools, and orchestration tools with the unified data platform to implement data engineering, analytical engineering, and data maintenance capabilities.
• Support enterprise architecture alignment, scalable engineering governance, and modernization initiatives across the investment data platform.
• Leverage AI-assisted development practices, automation capabilities, and intelligent engineering tools to improve productivity, operational efficiency, and continuous improvement initiatives.
• Provide support during unexpected outages.

WHAT WE ARE LOOKING FOR

• Bachelor's degree in Computer Science or related disciplines.
• 5-6+ years of experience in design, development, and building data-oriented complex applications.
• Minimum of 2-4 years of hands-on progressive experience from SQL to Advanced SQL.
• Strong experience developing and maintaining data models in dbt (Data Build Tool) with at least a couple of years of hands‑on experience.
• Experience managing dbt transformation workflows and implementing scalable modular design patterns.
• Experience working in data integration (ETL/ELT), data warehouse, and data analytics architecture with a sound understanding of design principles. Knowledge of and experience with Snowflake and other cloud‑native databases is highly preferred.
• Development experience in cloud‑based PAAS platforms such as Microsoft Azure, Google GCP, or Amazon AWS.
• Deep understanding of Agile SDLC, DevOps, and cloud technologies, in addition to exposure to multiple diverse technologies, platforms, and processing environments.
• Knowledge of architectures and patterns such as unified data management architecture (UDM), data mesh architecture, event‑driven architecture, real‑time data flows, non‑relational repositories, and data virtualization.
• Experience building solutions in the financial services domain with an understanding of financial instruments, transactions, and positions is desired.
• Strong interpersonal and communication skills with the ability to lead cross‑team collaboration and partnerships across a variety of internal and external constituencies.
• Demonstrated ability to contribute to strategic architecture initiatives and enterprise data standards alignment.

PREFERRED QUALIFICATIONS

• Experience working within the asset management industry and investment data domain, with exposure to multi‑asset investment platforms and related data ecosystems.
• Understanding of asset management concepts and knowledge of various financial instruments and products, including traditional and alternative asset classes.
• Industry certifications in Snowflake, dbt, cloud data engineering platforms, data warehousing technologies, or financial markets/investment operations are highly valued.
• Demonstrated interest in emerging AI technologies and an understanding of how AI‑driven tools can improve engineering processes, data quality, operational efficiency, and analytics workflows.
• Familiarity with leveraging AI‑assisted development, automation, or data engineering best practices to enhance productivity and continuous improvement initiatives.

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: $110,000.00 - $158,500.00This 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 forwhat we'll pay depending on the candidate's experience, training and education. In addition to the salary, we also offer significant and competitive incentive compensationbased 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.

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 [e-mail] 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.