Senior Analytics Engineer

Asana; Vancouver; On-site; CAD 106,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Breakfast and lunch catering

Home office setup budget

Gym/Fitness card

Fertility healthcare

Mental Health Support

Group life insurance

MacBooks

Job summary

Asana is seeking a Senior Analytical Engineer to own data foundations across a business domain, turning raw data into trusted datasets for PMs, analysts, and leaders. You will define business logic and metric standards that enable AI-powered self-serve insights and govern the Gold layer for dashboards, Genie spaces, and ELT reporting.

You will design canonical KPI logic, curate the semantic layer, and maintain the metric dictionary while partnering with Data Engineering and Data Science to

Qualifications

• 4+ years in analytics engineering, data engineering, or a closely related analytics role, owning data models.
• Advanced SQL and strong data modeling fundamentals (dimensional modeling, star/snowflake schemas, SCDs).
• Hands-on experience with a transformation framework (dbt or equivalent), orchestration tooling (Airflow), version control (Git).
• Experience with modern warehouse/lakehouse platforms (Databricks).
• Data quality testing, observability, schema management, data contracts, query/performance optimization.
• Domain fluency in PLG funnels, SLG pipeline, marketing attribution, or revenue data.

Responsibilities

• Own the Gold layer for a business domain and design curated data models used by dashboards and Genie spaces.
• Implement canonical business logic for core KPIs as versioned metric marts.
• Build semantic layer and Genie spaces enabling self-serve data queries in plain language.
• Own the metric dictionary and ensure KPI definitions are consistent across domains.
• Define data contracts and SLAs at Silver→Gold boundary, managing data quality and freshness.
• Develop board-ready dashboards on governed Gold data and translate insights into reusable products.
• Collaborate with Product, Data Science, and Engineering to turn ambiguous questions into scalable datasets.

Skills

Advanced SQL

Data modeling

dbt

Airflow

Git

Databricks

Unity Catalog

Tools

Looker/LookML

Job description

The Data Science & Analytics team at Asana is how the company turns data into decisions — defining the questions that matter, surfacing the answers, and making sure insight is at the center of every critical product and business call. As a Senior Analytical Engineer, you sit at the intersection of Data Engineering, Analytics, and Data Science, and you own the data foundations for a business domain end to end. Your mandate is to turn raw data into reliable, business-ready datasets that PMs, analysts, data scientists, and leaders actually trust and use — and to define the business logic and metric standards that make AI-powered self-serve trustworthy. You consume governed Silver tables and produce the Gold layer and semantic layer beneath Asana's most important metrics, dashboards, and Genie spaces.

What You’ll Achieve

• Own the Gold layer for a given business domain (e.g., PLG funnel, marketing attribution, revenue, NPI/AWM): Design and continuously improve the curated, dimensional data models that downstream dashboards, Genie spaces, and ELT reporting depend on.
• Implement the canonical business logic behind your domain's core KPIs: Translate KPIs into governed, versioned metric marts that resolve "this number doesn't match" disputes for good.
• Build and curate the semantic layer and Genie spaces that power self-serve in your domain: Author the metadata, documentation, and prompt/metric definitions that let stakeholders query governed data in plain language through Claude and Databricks Genie.
• Own the metric dictionary for your domain: a single source of truth for what each metric means, who owns it, and where to find it. Partner with peers across DS&A to keep KPI definitions consistent where domains overlap.
• Author data contracts and SLAs at the Silver→Gold boundary, partnering with Horizontal Data Engineering on the inputs you depend on, and owning data quality, freshness, and oncall for Gold/metric-mart failures in your domain.
• Build and maintain certified, board-ready dashboards on governed Gold data, partnering with Data Science to translate insight requirements into trusted, reusable products rather than one-off builds.
• Partner directly with Product & Business, Data Science, and Engineering to turn ambiguous, underspecified questions into scalable datasets — anticipating downstream reporting impacts before they become incidents, and raising the data-model quality bar across the domains you touch.

About You

• Demonstrates curiosity about AI tools and emerging technologies, with a willingness to learn and leverage them to enhance productivity, collaboration, or decision-making.
• 4+ years in analytics engineering, data engineering, or a closely related analytics role, with a track record of independently owning the data models a team relies on for decisions.
• Advanced SQL and strong data modeling fundamentals: dimensional modeling, star/snowflake schemas, slowly changing dimensions, and semantic layer design.
• Hands‑on experience with a transformation framework (dbt or equivalent), orchestration tooling (e.g. Airflow), version control (Git), and modern warehouse/lakehouse platforms (Databricks experience preferred).
• Practical experience with data quality testing and observability, schema management and data contracts, and query/model performance and cost tuning.
• Demonstrated domain fluency in at least one business area (e.g. PLG funnels, SLG pipeline, marketing attribution, Product telemetry, revenue/ARR) and the judgment to translate "I don't trust this number" into a specific, durable model fix.
• Strong cross‑functional partnership skills: requirement gathering, prioritization, documentation and enablement, driving alignment on metric definitions, and explaining technical tradeoffs to non‑technical partners.
• Curiosity about AI-native analytics — NL2SQL, metadata/semantic layers for self‑serve, and using tools like Claude and Genie to multiply your reach rather than replace rigor. Exposure to Unity Catalog, Looker/LookML, or reverse‑ETL/activation (Salesforce, Marketo, Gainsight) is a plus.

At Asana, we're committed to building teams that include a variety of backgrounds, perspectives, and skills, as this is critical to helping us achieve our mission. If you're interested in this role and don't meet every listed requirement, we still encourage you to apply.

What We’ll Offer

• Generous, transparent and fair compensation system (base salary and RSUs)
• Health insurance with dental
• Breakfast and lunch catering on the days that you work from the office
• Home office setup budget
• Gym/Fitness card
• Fertility healthcare and family‑forming support with Carrot
• Mental Health Support in Modern Health
• Group life insurance
• MacBooks with all necessary accessories

For this role, the estimated base salary range is between $106,000 - $120,000 CAD annually. The actual base salary will vary based on various factors, including market and individual qualifications objectively assessed during the interview process. The listed range above is a guideline, and the base salary range for this role may be modified.

In addition to base salary, your compensation package may include additional components such as equity and sales incentive pay (for most sales roles), and benefits.

About Us

Asana is a leading platform for human + AI collaboration. Millions of teams around the world rely on Asana to achieve their most important goals, faster. Asana has been named to Fortune's Best Workplaces for 7+ years and recognized by Fast Company, Forbes, and Gartner for excellence in workplace culture and innovation. We offer an exceptional office‑centric culture while adopting the best elements of hybrid models to ensure that every one of our global team members can work together effortlessly. With 13+ offices all over the world, we are always looking for individuals who care about building technology that drives positive change in the world and a culture where everyone feels that they belong.

We believe in supporting people to do their best work and thrive. Our goal is to ensure that Asana upholds an environment where all people feel that they are respected and valued, whether they are applying for an open position or working at the company. We provide equal employment opportunities to all applicants without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression or any other characteristic protected by law.