Sr. Analytics Engineer
at Philo
Brooklyn, Cambridge, San Francisco, New York, United States, Remote
Philo: a streaming service for TV and movie lovers
At Philo, we're a group of technology and product people who set out to build the future of television, marrying the best in modern technology with the most compelling medium ever invented — in short, we're building the TV experience that we've always wanted for ourselves. In practice this means leveraging cloud delivery, modern tech stacks, machine learning, and hand-crafted native app experiences on all of our platforms. We aim to deliver a rock solid experience on the streaming basics, while cooking up next generation multi-screen and multi-user playback experiences.
Data at Philo
Data underpins everything we do at Philo: making informed business decisions; analyzing and improving the quality of our streaming experience; running product experiments to optimize our signup flows and improve user journeys; and making it effortless for our users to find the perfect thing to watch. Philo serves over a billion streams to its users every year, generating a wealth of data that we leverage at all levels of the organization. Philo's data platform operates at a very large scale, processing trillions of events annually in a petabyte-scale data lake and supporting thousands of data workflows and analytical queries that power decision-making across the company.
Philo's Data Engineering team encompasses both data engineering and analytics engineering. As an analytics engineer at Philo, you'll own the data modeling layer that turns raw event and application data into the clean, trusted data products the entire company relies on — from metric definitions and dimensional models to the governed semantic layer that ensures everyone is looking at the same numbers. You'll work closely with data scientists, analysts, and business stakeholders across the organization to understand their analytical needs and translate them into well-modeled, well-documented, and performant data products in dbt and Snowflake.
We are passionate about providing a high-quality, trustworthy data platform for the entire company, using both cutting-edge technologies and proven engineering practices in close collaboration with every department. Our analytics engineering stack centers on dbt and Snowflake, supported by tools like Segment, Avo, and BigEye for event tracking, data quality, and observability.
Some of the recent projects that analytics engineers at Philo have worked on include building new models for key financial data, dbt model design and refactoring, metric definition and governance, per-query cost optimization in Snowflake, and developing data quality testing and documentation frameworks.
The Role
We're looking for a Senior Analytics Engineer to own and elevate the data modeling layer that powers decision-making across Philo. In this role, you'll be the person who transforms raw, messy application and event data into clean, trusted, well-documented data products that the entire company relies on. You'll design and maintain dimensional models, define and govern key business metrics, and ensure semantic consistency across our data stack — so that when someone asks "what does this number mean?", there's always a clear, reliable answer.
This is a high-impact IC role: you'll partner directly with stakeholders across Finance, Product, Marketing, Ad Sales, and Engineering to deeply understand their analytical needs and translate them into scalable, performant dbt models and data products. You'll also work closely with the data engineering side of the team to ensure the underlying infrastructure supports your modeling work, and with analysts and data scientists to make sure the data you deliver is easy to use, well-tested, and trustworthy.
The ideal candidate has strong opinions about how analytics engineering should be done — how to structure a dbt project, when to denormalize, how to manage slowly changing dimensions, how to build a metric layer that people actually trust — and the experience to back those opinions up.
Responsibilities:
- 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
Key Qualifications:
- 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)
Ideal Qualifications:
- Experience in the media, streaming, or entertainment industry, with familiarity with video delivery analytics, content performance metrics, or advertising data
- Familiarity with event tracking design and tools like Segment or Avo
- Experience with Apache Iceberg, Spark, or other large-scale data processing frameworks
- Familiarity with data governance frameworks and building organizational alignment around a single source of truth
- Experience mentoring junior analytics engineers or analysts
More about Philo
At Philo, we're a company that puts people first—both our subscribers and our team. We empower our colleagues to do their best work while supporting one another in pursuing shared goals. We value pragmatism, pride in our work, and passion, with transparency and openness as fundamental parts of our culture.
We're committed to diversity, equity, inclusion, and accessibility as we grow the Philo team and shape the future of TV. We believe that a diverse range of voices and perspectives enables us to innovate faster and create the best experiences for our subscribers. Philo is proud to be an Equal Opportunity Employer. We're committed to supporting every candidate and employee. If you need an accommodation at any stage of the process, please email recruiting@philo.com and we'll work with you to meet your needs.
Philo offers 70+ top-rated networks streaming live and on-demand, including AMC, BET, CMT, Comedy Central, Discovery Channel, Food Network, Hallmark Channel, HGTV, HISTORY, Investigation Discovery, Lifetime, MTV, Nickelodeon, OWN, VH1, We TV, and more. It also includes all the groundbreaking originals and blockbuster movies available with AMC+ and access to HBO Max Basic With Ads and discovery+. Our extensive library boasts over 85,000 titles, and our unlimited DVR allows users to save their favorite shows and movies for up to a year, skipping ads for a seamless viewing experience. Stream on up to three devices simultaneously, whether on your phone, tablet, laptop, or TV using Roku, Apple TV, Fire TV, Samsung TV, Android TV, Vizio TV, or Chromecast.
Philo is headquartered in San Francisco, with offices in New York City and Cambridge, MA. Our leadership team includes alums from HBO, Tubi, and Meraki, and is backed by NEA and industry partners like Warner Brothers Discovery, Viacom, AMC, and A&E.
Join us at Philo and be part of a team that's shaping the future of TV!
Status: Full-time
Location: San Francisco, CA, Brooklyn, NY, Cambridge, MA, or remote within the U.S.
Compensation: Includes annual salary, company stock options, and health benefits. Salary is determined by experience and location:
- San Francisco, New York City: $170K - $205K
- Boston, DC Metro, Los Angeles, Seattle: $160K - $195K
- Denver, Atlanta, Austin, Las Vegas, Sacramento, Chicago: $155K - $185K
- Texas, Florida: $145K - $175K
We value a diverse and inclusive workplace and we welcome people of different backgrounds, experiences, skills, and perspectives. Philo is an equal opportunity employer. We believe that everyone does their best work when they are supported by each other and the company, and we offer a generous set of benefits to make sure the Philo team is happy and healthy. Here is a sampling of the benefits we offer our team:
- 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!
For California Residents: Philo's CCPA Notice at Collection – Employees, Applicants, Owners, Directors, Officers and Contractors
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
