Priya Raghavan
Analytics Engineer · Austin, TX · priya.raghavan@example.com · linkedin.com/in/priyaraghavan
Summary
Analytics engineer with 5 years turning raw warehouse data into governed, tested dbt models that business teams trust. Built a 40-model semantic layer that took metric disputes to zero and analyst turnaround from days to hours. Deep SQL (Snowflake, BigQuery), dbt Core and Cloud, dimensional modeling, and the stakeholder habit of defining a metric with finance before modeling it.
Professional Experience
Analytics Engineer · Ledgerline
Mar 2023 – Present
- Took company-wide metric disputes to zero by consolidating 120 ad-hoc reports into a 40-model dbt metric layer with a documented semantic contract signed off by finance and RevOps.
- Cut analyst request turnaround from 3 days to under 4 hours by shipping self-serve Looker explores on top of tested dbt marts, retiring the SQL-request queue for 60 business users.
- Reduced warehouse spend 32% ($9K/month) by refactoring full-refresh models to incremental materializations and pruning unused columns flagged by usage metadata.
- Prevented an estimated 15 bad-data incidents/quarter by adding 600+ dbt tests (uniqueness, referential, freshness) and routing failures to on-call Slack with model-level ownership.
- Halved onboarding time for new analysts by documenting every mart in dbt docs and enforcing a naming standard through CI checks on every pull request.
Data Analyst · Corvus Retail Group
Jun 2020 – Feb 2023
- Recovered $1.1M/yr in missed reorder revenue by building an inventory-gap model in SQL and getting it adopted as the merchandising team’s weekly buy list.
- Cut executive reporting prep from 2 days to 30 minutes by migrating 14 spreadsheet reports into version-controlled SQL feeding a single Tableau workspace.
- Standardized revenue definitions across 3 regional teams, ending a quarter-long dispute between finance and sales dashboards.
Projects
Open-source: dbt-usage-audit
- Built a dbt package that flags unused models and columns from warehouse query logs; 400+ GitHub stars and adopted by 3 data teams to cut warehouse cost.
Technical Skills
- Modeling & transformation: dbt (Core, Cloud), SQL (Snowflake, BigQuery), dimensional modeling, semantic layers, incremental materializations, data testing & observability
- Pipeline & BI: Airflow, Fivetran, Looker (LookML), Tableau, Python (light scripting), Git & CI (GitHub Actions)
Certifications & Education
- B.S. Economics, University of Texas at Austin — May 2020
- dbt Labs, Analytics Engineering Certification — Sep 2023