Lead Analytics Engineer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Collaborate with Data Scientists and Product teams to tackle complex analytics challenges.

• Define and establish metrics and standards for advertiser revenue, monetization performance, funnel/cohort metrics, and experiment outcomes.

• Lead comprehensive analytics projects that encompass data modeling, pipeline development, dashboard creation, and implementation.

• Conduct root-cause analysis to address discrepancies across dashboards, data warehouses, and pipelines.

• Review the work of and mentor analysts and analytics engineers.

• Design and maintain production SQL pipelines, data models, data cubes, aggregate tables, and semantic layers.

• Create and manage Airflow DAGs for revenue and monetization pipelines, including SLAs, on-call procedures, backfilling, and incident management.

• Set and maintain standards for data quality, reconciliation, and observability.

• Optimize data pipelines for cost efficiency and latency on tables with over a billion rows.

• Contribute to technical decision-making, migration strategies, design documentation, and reviews.

• Take ownership of executive and cross-functional dashboards in Tableau and/or Superset.

• Manage metrics through definitions, ownership, source-of-truth queries, validation, and deprecation processes.

• Facilitate self-serve analytics by providing documentation, certified metrics, sensible defaults, and coaching.

⛳️ Requirements

• Over 9 years of combined experience in Data Analytics, Business Intelligence, or Analytics Engineering roles.

• A minimum of 3 years in a Senior-level position or higher within an analytics-related role at a high-scale technology, ad-tech, marketplace, or fintech organization.

• Previous experience as the lead analytics individual contributor on an embedded team or a compelling case for readiness to assume that role.

• Proven track record of managing end-to-end analytics projects.

• Direct experience collaborating with US-based Data Science, Product, and Engineering leaders.

• Expert-level proficiency in SQL, including window functions, CTEs, intricate joins, query optimization, incremental patterns, skew mitigation, and cost management on tables exceeding a billion rows.

• Extensive hands-on experience with at least two of the following: Presto, Trino, Hive, Spark SQL, Snowflake, BigQuery, or Redshift.

• Advanced experience with Airflow, encompassing large DAG ecosystems, cross-DAG dependencies, extensive backfills, and SLA management; equivalent orchestrators are also acceptable.

• Expertise in data architecture and modeling, including Kimball methodology, star schema, dimensional modeling, OLAP cubes, wide fact tables, slowly-changing dimensions, and semantic layer design.

• Experience in ETL/ELT architecture, focusing on incremental loads, backfills, idempotency, data quality frameworks, and data lineage.

• Proficiency in Python for data tasks, including pandas, PySpark, scripting, and basic tool development.

• Strong preference for experience with dbt or similar transformation frameworks.

• Background in contributing to or reviewing design documents and RFCs for data platforms and pipelines.

• Experience in production dashboard creation using Tableau and/or Apache Superset; familiarity with Looker, Power BI, or Mode is also acceptable.

• Experience promoting metric governance and self-serve BI at an organizational level.

• Solid understanding of KPI definition, metric design, funnel analysis, cohort analysis, and A/B testing methodologies.

• Background in digital advertising/monetization metrics is highly preferred.

• Native or near-native English proficiency, both spoken and written — a non-negotiable requirement.

• Proven ability to lead initiatives from start to finish with minimal supervision.

• Experience in drafting design documents, RFCs, requirement specifications, and postmortems.

• Experience in mentoring or coaching junior analysts and analytics engineers.

• Capability to present analytics work to Director- and VP-level stakeholders and justify recommendations.

• Possess an ownership mindset typical of a full-time employee, even in a contract capacity.

🏝️ Benefits

• Competitive salary and performance bonuses.

• Opportunities for professional development and growth.

• Flexible working hours and remote work options.

• Comprehensive health and wellness benefits.

• Collaborative and innovative work environment.