Senior Analytics Engineer - Marketing Data || Remote || W2 Role

Remote • Posted 1 hour ago • Updated 1 hour ago
Contract Independent
Contract W2
6 Months
No Travel Required
Remote
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Python
  • Google Analytics
  • Extract, Transform, Load
  • Mapping
  • JIRA
  • Data Structure
  • Data Validation
  • Reporting
  • Extraction
  • Continuous Integration
  • Communication
  • Business Rules
  • Marketing
  • Modeling
  • Automated Testing
  • Collaboration
  • Electronic Commerce
  • Code Review
  • Retail
  • Stored Procedures
  • Scripting
  • Git
  • Semantics
  • Snow Flake Schema
  • Management
  • Data Engineering
  • Continuous Delivery
  • Documentation
  • JavaScript
  • Testing
  • Acceptance Testing
  • Version Control
  • Use Cases
  • Analytics
  • SQL
  • Usability

Summary

Partner with business and technical stakeholders to understand CDP use cases and determine whether available data is sufficiently detailed, complete, timely, and appropriately structured to support them.

Identify, design, and build the Snowflake models, aggregations, materializations, and other data structures needed to support CDP performance and usability, using views, dynamic tables, semantic views, stored procedures, and other appropriate technologies.

Support the continued evolution of CDP and marketing data requirements following initial implementation.

Develop a strong working understanding of the data produced by marketing and ecommerce platforms, including web behavioral events, campaign interactions, customer identifiers, orders, and related business activity.

Elicit the underlying business need from requests that may initially be incomplete, unstructured, or solution-oriented; identify gaps and contradictions and distinguish among ingestion, modeling, CDP, activation, and reporting requirements.

Challenge assumptions or proposed solutions when they do not align with the available data, system capabilities, or intended business outcome.

Analyze source-system data and API documentation to determine whether the necessary objects, fields, identifiers, events, and levels of detail are available.

Translate business needs and source-system findings into clear, technically actionable Jira tickets and acceptance criteria for data ingestion and modeling work.

Communicate technical constraints, tradeoffs, data limitations, and scope boundaries clearly as stakeholder requests and project priorities evolve.

Write advanced, performant SQL to transform, combine, and prepare data in Snowflake.

Develop Snowflake stored procedures and supporting utilities using Python, JavaScript, or Snowflake Scripting, with Python as the preferred language.

Evaluate generated or externally supplied code for correctness, maintainability, performance, security, and alignment with engineering standards.

Work within established development practices, including Git, version control, peer review, automated testing, and CI/CD.

Partner with data engineers to define ingestion requirements and map business needs to the objects, endpoints, fields, identifiers, and extraction methods available from marketing, ecommerce, and customer-data sources.

Build or modify data ingestion processes when needed, while generally partnering with other data engineers for primary pipeline development.

Troubleshoot source-data and integration issues in collaboration with internal engineers and external vendors.

Validate modeled data against source systems, business expectations, and downstream use cases, including identifier coverage, record completeness, event granularity, and business-rule accuracy.

Perform user acceptance testing on upstream datasets delivered by other engineers and identify missing, incorrect, or unusable data before downstream implementation.

Participate in troubleshooting data incidents and implement durable fixes for issues involving owned models or processes.

 

Top Requirements

(Must haves)

               

Approximately five or more years of relevant professional experience in analytics engineering, data engineering, marketing data, or a closely related role.

Professional, hands-on experience working with Google Analytics data in a business or production environment. Coursework, certifications, or self-directed learning without applied work experience are not sufficient.

Professional experience supporting data in a retail or ecommerce environment.

Advanced SQL skills and hands-on experience designing fit-for-purpose data models, transformations, and materializations in Snowflake.

Working proficiency in Python, including the ability to read, evaluate, troubleshoot, and improve code written by others.

Experience reviewing API documentation and mapping API objects, endpoints, fields, and identifiers to business requirements.

Experience with Git and version-controlled development practices, including code review, testing, and CI/CD.

Demonstrated ability to elicit requirements from stakeholders, bring structure to ambiguous or nonlinear discussions, and translate business needs into precise, actionable technical work.

Strong understanding of data validation across multiple stages of a data pipeline.

Exceptional written and verbal communication skills in English.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91140717
  • Position Id: 9146110
  • Posted 1 hour ago
Contact the job poster
Ashish Joshi

Ashish Joshi

Recruiter @ AKAASA Technologies

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.