Sr. Analytics Engineer

Philo: a streaming service for TV and movie lovers

At Philo were 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 were building the TV experience that weve always wanted for 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. Philos 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.

Philos Data Engineering team encompasses both data engineering and analytics engineering. As an analytics engineer at Philo youll 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. Youll 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

Were looking for a Senior Analytics Engineer to own and elevate the data modeling layer that powers decision-making across this role youll be the person who transforms raw messy application and event data into clean trusted well-documented data products that the entire company relies on. Youll 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 theres always a clear reliable answer.

This is a high-impact IC role: youll 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. Youll 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 Philos 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 Philos 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 were a company that puts people firstboth 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.

Were 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. Were committed to supporting every candidate and employee. If you need an accommodation at any stage of the process please email and well 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 85000 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 thats 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
• $2000 annual vacation bonus (we pay you to take a two week vacation)
• $5250 annually for professional development and educational assistance
• $1250 annual home office TV stipend during first year of employment ($250 annually thereafter)
• $500/month ($6000/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: Philos 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.