Design, build, and maintain Philo's core dimensional models and data marts in dbt, serving as an owner of the analytics engineering layer of our data stack
Define and govern key business metrics and KPIs, ensuring consistent definitions and reliable calculations across all downstream reporting and analytics
Partner with stakeholders across the organization (Finance, Product, Marketing, Ad Sales, Content, and others) to understand their data needs and translate business questions into well-modeled, performant data products
Establish and enforce best practices for dbt project structure, model design patterns, documentation, and testing — raising the quality bar for analytics engineering at Philo
Build and maintain comprehensive data documentation and a data catalog so that analysts, data scientists, and business users can confidently self-serve
Implement and maintain data quality checks and monitoring (e.g., via dbt tests, BigEye, or similar tools) to proactively catch issues before they reach stakeholders
Optimize query performance and warehouse cost efficiency in Snowflake through thoughtful model design, materialization strategies, and incremental processing patterns
Collaborate with data engineers on pipeline design and data ingestion to ensure raw data lands in forms that support clean, efficient downstream modeling
Drive alignment across teams on data definitions, naming conventions, and a single source of truth — building stakeholder trust in data and reporting over time
Contribute to the evolution of Philo's overall data platform strategy, particularly as it relates to the semantic/metric layer, data governance, and analytics engineering tooling

Requirements

8+ years of professional experience in analytics engineering, data modeling, or a closely related role, with significant hands-on experience building and maintaining production dbt projects or a similar data transformation tool
Deep expertise in SQL and dbt, including advanced model design patterns (dimensional modeling, incremental models, slowly changing dimensions, and snapshot strategies)
Experience developing in a BI tool that leverages semantic layers, such as Mode, Looker, Omni, SSAS Cubes, or similar
Strong experience with Snowflake or a comparable cloud data warehouse, including performance tuning and cost optimization
Proven ability to translate ambiguous business questions into clean, well-structured data models that stakeholders trust and rely on
Experience defining, governing, and maintaining business metrics and KPIs across an organization
Strong communication skills — you can explain data modeling decisions to a VP of Finance just as clearly as to a fellow engineer
A strong sense of ownership and quality: you care deeply about data accuracy, documentation, testing, and making the data stack better over time
Experience working with data quality and observability tools (e.g., BigEye, Elementary, dbt tests, Great Expectations, or similar)

Benefits

Full health, dental and vision coverage for you and your family
401(k) plan with employer contributions (we match 100% of deferrals up to 3% of pay and 50% of the next 2% of pay)
Flexible working hours
Up to 20 weeks of fully paid parental leave
Unlimited paid time off for vacation and sick leave
$2,000 annual vacation bonus (we pay you to take a two week vacation)
$5,250 annually for professional development and educational assistance
$1,250 annual home office + TV stipend during first year of employment ($250 annually thereafter)
$500/month ($6,000/year) bonus for employees who commit to working at least 3 days per week in our offices, plus generous commuter benefits ($315/month towards transit, rideshare, bike rental, or parking at our HQ office in San Francisco)
Free Gympass subscription — an all-in-one corporate benefit that gives employees the largest selection of gyms, studios, classes, training and wellness apps
Dog-friendly office
And much more!

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

analytics engineeringdata modelingSQLdbtdimensional modelingincremental modelsslowly changing dimensionssnapshot strategiesdata quality checksperformance tuning

Soft Skills

strong communication skillsownershipquality focusstakeholder trustcollaboration