Senior Analytics Engineer

The role

The Senior Analytics Engineer converts raw information into strategic insights and product features. You will design and maintain DBT data pipelines and data models to support buyer experience, experimentation, and ecommerce tracking.

What you will do

• Design, develop, and maintain robust DBT data pipelines and data models
• Build resilient and auto-recoverable data pipelines subject to strict SLAs
• Optimize data pipelines and debug analytical use cases and data quality issues
• Develop data models following best practices and industry standards
• Collaborate with stakeholders to translate business OKRs into technical solutions
• Document and maintain the data catalog
• Define semantic views to enable AI-ready, self-service data consumption
• Ensure data security, compliance, and cost efficiency across environments
• Mentor and guide other data platform associates with solutioning, code reviews and best practices adoption

Required qualifications

• 6+ years of experience in implementing enterprise data solutions
• 3+ years of experience using ETL/data pipeline and orchestration tools (dbt, Airflow, Airbyte, Glue, Prefect etc)
• 2+ years of hands-on experience in data modeling, optimization and database architecture
• Extensive experience in writing, debugging, and tuning SQL queries
• Strong programming experience in Python or Java
• Good understanding of the AWS data services (DynamoDB, RDS, Data Pipeline, EMR, Lambda, Glue, ECS, etc.) and cloud data warehouses like Snowflake
• Must have good knowledge of performance tuning, optimization and debugging of data pipelines
• Experience with enterprise data and business intelligence platforms serving large-scale enterprise deployments
• Proven track record of leading and delivering complex data projects within cloud environments
• Good problem-solving, leadership, and communication skills
• Good understanding of software engineering principles and standards
• Functionally understand ecommerce business processes, especially in the areas of customer transactions, ecommerce website experimentation and AB testing

Nice to have

• Understanding of distributed computing and frameworks like Apache Spark, Hadoop, and Apache Kafka
• Experience in data modeling, schema design, and optimizing data structures for performance in Snowflake
• Experience building semantic layers or AI-ready data products
• Working experience in startup environments
• Experience with Agile process methodology, CI/CD automation, Test Driven Development
• Experience in working with Google Analytics and/or Snowplow data
• Knowledge of data governance, security, and compliance standards within cloud-based data solutions
• Understanding of any reporting tools such as Tableau, Qlikview , Looker, PowerBI etc
• Database administration background

Before you apply

• You may opt out of AI-powered candidate evaluation by entering your email in the Automated Processing Legal Notice

About the company

G2 is the world's largest and most trusted software marketplace. It has joined forces with Capterra, SoftwareAdvice, and GetApp to create a large source of online data and software insights.