Analytics Engineer

Optomi; Stamford (CT); On-site; USD 110,000 - 150,000; Full time

Job summary

Optomi Stamford, CT is seeking an Analytics Engineer to join a team undergoing a major marketing transformation. The role focuses on data engineering, transformation, automation, data quality, and production support within a 100% Snowflake environment.

The Analytics Engineer will work directly with leadership to manage and validate large datasets used in MMM and MTA initiatives, ensuring data accuracy and connecting model results back to source data with autonomy.

Qualifications

• Strong hands-on Snowflake experience and SQL proficiency.
• Experience with ETL data pipelines and data quality audits.
• Ability to own technical tasks with minimal oversight.
• Experience with Power Automate and AWS S3.

Responsibilities

• 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 data flow into the modeling process and how outputs connect back to the underlying datasets.
• Monitor scheduled workflows and troubleshoot production processes.
• Identify data quality issues and correct discrepancies quickly.
• Create Snowflake views for business and downstream use.
• Serve as a data steward for third-party data outputs, ensuring accuracy.

Skills

Snowflake

SQL

ETL

Data pipelines

Data quality audits

Power Automate

AWS S3

Data validation

Production support

Data stewardship

MMM/MTA data modeling

Tools

Power Automate

AWS S3

Snowflake

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.

What the Right Candidate Will Enjoy

• Working hands-on in a Snowflake environment
• Taking ownership of data transformation, automation, and data quality initiatives
• Working directly with leadership with a high level of autonomy
• Supporting data that directly impacts marketing measurement and business decision-making
• Solving data quality issues across large and complex datasets
• Gaining exposure to MMM and MTA marketing measurement models
• Working in a role that combines data engineering, QA, data stewardship, and production support

What Type of Experience Does the Right Candidate Have?

• Strong hands-on experience with Snowflake
• Advanced SQL skills, including transformations, aggregations, and data validation
• Experience with Power Automate
• 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
• Ability to work independently and execute tasks with minimal oversight

Responsibilities

• 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
• Monitor scheduled workflows and production processes and troubleshoot failures when they occur
• Identify data quality issues and work quickly to correct discrepancies
• Create and curate Snowflake views for business and downstream use
• Serve as a steward for third-party data outputs, ensuring accuracy, completeness, and consistency