Senior Analytics Engineer Vancouver, BC

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

Benefits offered by this job

Health insurance

Home office setup budget

Gym/Fitness card

MacBooks with accessories

Fertility healthcare and family-form‑

Job summary

Asana is seeking a Senior Analytics Engineer in Vancouver to own data foundations end to end—turning raw data into reliable, business-ready datasets used by PMs, analysts, data scientists, and leaders. You will define business logic, metric standards, and self-serve data via governed gold layers and Genie spaces.

You will collaborate with Product, Data Science, and Engineering to translate ambiguous questions into scalable datasets, applying dbt, Airflow, and Databricks across the data stack.

Qualifications

• 4+ years in analytics engineering, data engineering, or a closely related analytics role.
• Advanced SQL and strong data modeling fundamentals, including dimensional models.
• Experience with a transformation framework (dbt) and orchestration (Airflow).
• Experience with modern warehouse platforms (Databricks preferred).
• Knowledge of data quality testing and data contracts.

Responsibilities

• Own the Gold data layer for a business domain and design scalable data models.
• Translate KPIs into governed, versioned metric marts and resolve disputes.
• Build semantic layer and Genie spaces to power self-serve analytics.
• Own the metric dictionary and ensure KPI consistency across domains.
• Write data contracts and SLAs; ensure data quality and on-call for issues.
• Create board-ready dashboards from governed Gold data with DS collaboration.
• Collaborate with Product, Data Science, and Engineering to translate questions into datasets.

Skills

Advanced SQL

Data modeling

dbt

Airflow

Git

Databricks

Semantic layer

Looker/LookML

Reverse-ETL

Tools

Unity Catalog

Looker/LookML

dbt

Salesforce

Gainsight

Job description

Senior Analytics Engineer

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.

This role is based in our Vancouver office with an office-centric hybrid schedule. The standard in-office days are Monday, Tuesday, and Thursday. Most Asanas have the option to work from home on Wednesdays. Working from home on Fridays depends on the type of work you do, and your recruiter can share more about the in-office requirements.

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 to 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. If you're interviewing for this role, speak with your recruiter to learn more about the total compensation and benefits for this role.

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.