Analytics Engineer

• Connect with relevant stakeholders to comprehend business needs
• Design, build, and maintain critical data pipelines and dashboards to ensure accurate and reliable business reporting
• Monitor daily job execution and diagnose issues to ensure SLAs are met
• Identify data discrepancies and maintain clear and up-to-date code to ensure business requirements and ETL logic match
• Make data model and ETL code improvements to improve pipeline efficiency and data quality
• Contribute to the company s Looker data models by creating and maintaining new and existing views
• Own data import/export pipelines

Job Requirements:

• Bachelor s/Master s degree in Engineering, Computer Science (or equivalent experience)
• A minimum of 3+ years of experience in an analytics engineering, business intelligence, or technical data analytics role
• Prior experience with SQL and ETL optimization techniques, especially within cloud-based data warehouses like Snowflake, BigQuery, and/or Redshift
• Demonstrable experience and familiarity with version control software (Git)
• Experience with data pipeline management technologies with dependency checking, such as Airflow, schema design, and dimensional data modeling tools (dbt)
• Extensive experience with data visualization technologies, such as Looker or Tableau
• Experience in LookML Development
• Experience with Python, data ingestion tools (such as Fivetran, Stitch, Alooma, or Matillion), and the AWS ecosystem (Redshift, S3, Spectrum)
• Ability to demonstrate tools, business intuition, and attention to detail for data validation and QA
• Excellent English communication skills, particularly when explaining technical or sophisticated matters to less technical co-workers
• Experience working with digital and offline media data (such as Facebook, Google, programmatic, TV, and streaming audio)
• Solid understanding of digital marketing measurement concepts (i.e., Multi-touch attribution)
• Prolific experience in SQL and Redshift
• Experience in Git, Airflow, and DBT
• Experience with Looker and 5tran for data ingestion
• Nice to have experience in Python
• Strong fundamentals around version control