About the company
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.
Responsibilities
- 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.
Requirements
- 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.
Conditions
- Generous, transparent and fair compensation system (base salary and RSUs)
- Contract of Employment (and the option of 50% tax deductible costs for author’s rights usage in respect of applicable roles)
- Health insurance with dental and travel coverage (Lux Med)
- Breakfast and lunch catering on the days that you work from the office
- Vacation allowance
- Career growth budget
- 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