Senior Investment Data Engineer | dbt, Snowflake, QA

Massachusetts Financial Services Company; Boston (MA); Hybrid; USD 99,000 - 142,000; Full time

Benefits offered by this job

Hybrid work environment

Competitive total rewards

Annual incentive bonus

Education assistance

Job summary

At MFS, a Senior Investment Data Engineer is sought to lead data engineering, QA testing, and data quality initiatives for investment data platforms. The role emphasizes advanced SQL, data validation, and dbt model development within Snowflake.

You will partner with cross-functional teams and vendor partners in a fast-paced environment. The position requires a hands-on mindset, experience validating data transformations, and comfort with cloud-native databases.

Qualifications

• Bachelor’s degree in Computer Science or a related field.
• 3–5+ years of data engineering, QA, or data platform support.
• Strong SQL skills with complex queries for validation and troubleshooting.
• Experience with dbt, data models, ETL/ELT, and data warehousing.

Responsibilities

• Develop and maintain data models in dbt within Snowflake, applying business logic and standards.
• Design, develop, and run SQL-based data validation and QA testing for pipelines and warehouses.
• Create complex SQL queries to verify data across source and target systems.
• Perform data reconciliation, regression testing, and root-cause analysis of ETL/ELT processes.
• Contribute to automated data quality testing and platform resiliency initiatives.
• Collaborate with engineers, architects, and stakeholders to define test scenarios and acceptance criteria.
• Support data ingestion, transformations, orchestration, and validation on the unified platform.
• Provide production support and troubleshoot outages as needed.

Skills

SQL

dbt

Snowflake

Data Quality

QA Testing

Cloud Platforms

Agile SDLC

Financial Data

Education

Bachelor’s degree in Computer Science or related discipline

Tools

dbt (Data Build Tool)

Snowflake

Job description

At MFS, a Senior Investment Data Engineer is sought to lead data engineering, QA testing, and data quality initiatives for investment data platforms. The role emphasizes advanced SQL, data validation, and dbt model development within Snowflake.

You will partner with cross-functional teams and vendor partners in a fast-paced environment. The position requires a hands-on mindset, experience validating data transformations, and comfort with cloud-native databases.