Performance Management Engineer

Job Description

Optomi, in partnership with a leading organization undergoing a major marketing transformation, is seeking an Analytics Engineer to join their team in Stamford, CT. This role will focus heavily on data engineering, transformation, automation, data quality, and production support within a 100% Snowflake environment. The Analytics Engineer will work directly with the team lead to manage and validate large datasets used within Marketing Mix Modeling (MMM) and Multi-Touch Attribution (MTA) initiatives. This person will be responsible for understanding data from end to end, ensuring the accuracy of data being sent to third-party partners, auditing processed outputs, and connecting model results back to the underlying source data.
The ideal candidate is a self-starter who is strong with Snowflake and SQL, understands ETL processes, and is comfortable owning technical tasks with minimal oversight.

Taking ownership of data transformation, automation, and data quality initiatives
Supporting data that directly impacts marketing measurement and business decision-making
Solving data quality issues across large and complex datasets
Working in a role that combines data engineering, QA, data stewardship, and production support
Advanced SQL skills, including transformations, aggregations, and data validation
Familiarity with AWS S3
Strong understanding of ETL processes and data pipelines
Experience performing data quality audits and QA on large datasets
Ability to quickly identify data discrepancies and determine root causes
Experience supporting scheduled workflows, jobs, or production data processes
Experience owning or stewarding data delivered to or received from third-party vendors
Comfortable creating and curating data views for downstream business use
Design, execute, and maintain data quality audits across large datasets
Use Snowflake and SQL to transform, aggregate, validate, and prepare data
Build and support automated data processes using Power Automate
Work with data moving between internal sources, AWS S3, Snowflake, and third-party partners
Validate data before it is delivered to external modeling partners
Audit data after processing to ensure outputs align with source data and business expectations
Understand what data enters the modeling process and how resulting outputs connect back to the underlying datasets
Identify data quality issues and work quickly to correct discrepancies
Serve as a steward for third-party data outputs, ensuring accuracy, completeness, and consistency