What are the responsibilities and job description for the Analytics Engineer position at Optomi?
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
Salary : $50 - $66