DBT Investment Lead Data Engineer

MFS International Australia Pty Ltd; Boston (MA); On-site; USD 110,000 - 158,500; Full time

Benefits offered by this job

Education assistance

Generous time off

Retirement match 15%

Medical and dental plans

Job summary

MFS is seeking a skilled data engineer in Boston to contribute to a long-term strategic initiative unifying investment data across multi-asset platforms. You will design and implement scalable data models and pipelines, collaborating with the Enterprise Data Management Office to enable accurate risk management and client reporting.

The role requires 5-6+ years in data engineering, strong SQL, dbt, Snowflake experience, and cloud platform knowledge.

Qualifications

• 5-6+ years of experience in design and building data-oriented applications.
• Minimum 2-4 years of hands-on experience from SQL to Advanced SQL.
• Experience in developing and maintaining data models in dbt.
• Experience with data integration, data warehouse, and analytics architecture.
• Knowledge of Snowflake and cloud-native databases preferred.
• Cloud platforms (Azure, AWS, GCP) experience.

Responsibilities

• Develop and maintain data models in dbt within Snowflake, implementing business logic and ensuring alignment with data standards.
• Manage and contribute to dbt projects, ensuring code quality, proper documentation, and modular design patterns.
• Design, build, and administer scalable data pipelines and a robust data warehouse for reporting and analytics.
• Lead development activities and implement solutions aligned with program objectives.
• Drive continuous improvement of data quality, resiliency, and monitoring.
• Troubleshoot complex system interactions to identify root causes.
• Collaborate with platform and data architects to upgrade and integrate ingestion and delivery tools.
• Upgrade transformation, validation, and orchestration tools within the platform.
• Provide support during outages.

Skills

SQL

Data Modeling

Cross-team Collaboration

Analytical Thinking

Problem Solving

Education

Bachelor's degree in Computer Science or related

Tools

dbt

Snowflake

ETL/ELT

Airflow

Job description

Overview

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. The role, in conjunction with the Enterprise Data Management Office, is to contribute 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 detail‑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?

What You Will Do

• Develop and maintain data models in dbt (Data Build Tool) within Snowflake, implementing business logic and ensuring alignment with existing architecture and 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, develop and implement solutions to meet business requirements that align with program strategic objectives.
• Drive continuous improvement of data quality, resiliency, control, efficiency, and monitoring.
• Troubleshoot complex system interactions to find the root cause of problems.
• Partner with platform lead to design, develop, implement and deploy new software components to the investment data platform.
• Partner with data architect to evaluate and finalize the unified data model.
• Partner with integration architect to upgrade and integrate data ingestion and data delivery tools with the unified data platform.
• Upgrade and integrate transformation tool, data validation tool and orchestration tools with the unified data platform to implement data engineering, analytical engineering and data maintenance capabilities.
• 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.
• Experience in developing and maintaining data models in dbt.
• Experience working in data integration (ETL/ELT), data warehouse, data analytics architecture and 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 like Microsoft Azure, Google GCP or Amazon AWS.
• Deep understanding of Agile SDLC, DevOps and cloud technologies required, in addition to exposure to multiple, diverse technologies, platforms, and processing environments.
• Knowledge about various architectures, patterns such as unified data management architecture (UDM), data mesh architecture, event‑driven architecture, real‑time data flows, non‑relational repositories, data virtualization, etc.
• Experience with building solutions in the financial services domain with an understanding of financial instruments, transactions, and positions, is desired.
• Good interpersonal and communication skills with the ability to lead cross‑team collaboration and partnerships across a variety of internal and external constituencies.

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 day‑to‑day 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 is a plus.

Compensation & Benefits

Base Salary Range: $110,000.00 – $158,500.00. Eligible for competitive incentive bonus. MFS contributes 15% of your base salary to your retirement account. Education assistance: $100 monthly up to $10,000 lifetime maximum for loan repayment; tuition reimbursement up to $8,000 annually. Generous time off and fully paid leaves, including 20 weeks maternity, 12 weeks parental and caregiver leaves. Choice of medical and dental plans with employer contribution to a Health Savings Account. Tax‑deferred commuter benefits and flexible spending accounts (medical & dependent care). Wellness programs: webinars, employee assistance program, mental health focus, subsidized fitness benefit via Wellhub, access to virtual personal training and well‑being apps.

Equal Opportunity Employer

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. Retaliation, including intimidation, threats, or coercion, for filing a complaint or assisting in a review is prohibited. Please see the Know Your Rights: Workplace Discrimination Is Illegal document for additional information.