Philo: TV on the Internet (TVoIP)

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 Engineering at Philo

The Data Engineering practice is the backbone of all data-related processes and enables the Data Science team to develop and deploy a wide variety of algorithms and models that power our streaming service, business development, and product experimentation. Our infrastructure is used by the whole company for analytics, reporting, forecasting and research. We care about having a reliable infrastructure with quality data. We think that continuous testing of data is as important as testing code.

Some of the recent Analytics Engineering projects we have worked on include:

  • Implementation of dbt incremental models for core Philo metrics
  • Standardize and build product experimentation data models
  • Development of quality of experience models
  • Setup and deployment of Apache Superset for standardized reporting and APIs for our content partners

Qualifications

Philo is seeking an Analytics Engineer with demonstrated expertise in SQL based modeling of digital consumer products. This analytics engineer will be responsible for developing and maintaining key ETL pipelines and developing best practices and reusable components for Data Scientists and other Engineers to utilize. At the core of Philo’s data modeling is dbt (data build tool) to process incoming data (primarily delivered through Segment and Airbyte) within our Redshift data warehouse. In this role you would be instrumental in developing robust, fast, and tested processing and modeling of Philo’s data.

Responsibilities:

  • Build common reusable components through SQL and Python in dbt
  • Identify and design patterns for incremental data processing to enable a low latency data warehouse
  • Maintain high levels of data integrity and ensuring secure handling of PII
  • Provide feedback and support Data Scientists and Software Engineers in building feature stores with the data warehouse
  • Create and maintain Mode dashboards for understanding Philo product performance and customer behaviors
  • Run queries to support ad-hoc product questions and create Mode reports, Superset dashboards, and other visualizations for stakeholders
  • Own your analytics projects, proactively identify issues and opportunities to improve data processing

Key Qualifications:

  • 3+ years of experience in data analytics and engineering
  • Expert with relational databases and SQL, in particular how to optimize SQL in large (multiple TB or PB sized) data warehouses
  • Experience with dbt, airflow, or similar software solutions
  • Understanding of CI / CD best practices (we use SQLfluff to maintain SQL style standards and plan to enable slim CI features in dbt)
  • Strong analytics fundamentals – a degree in statistics, computer science, a related field, or similar professional experience

More about Philo

We strive to build engaging and easy to use streaming apps across a large number of platforms (Android Mobile, Android tablets, Android TV, Amazon FireTV, Roku, iOS, Apple TV, and web), while delivering a large variety of content to our users. 

Today there are over 60 channels included in our basic package -- our lineup includes many popular cable networks, like A&E, Accuweather, Animal Planet, AXS TV, BBC America, BET, Cheddar, ComedyCentral, CMT, Discovery Channel, Food Network, Game Show Network, Hallmark, HGTV, IFC, INSP,Lifetime, MTV, Newsy, Nickelodeon, OWN, Paramount Network, Sundance, TV One, Vice and VH1. We also offer premium add-on channels from Starz and Epix, and we’re always adding more content!

We’re a company that puts people first — both our subscribers and our team. At Philo, our philosophy is to empower our colleagues to do their best work while supporting each other in pursuing shared goals. We value pragmatism, pride in our work, and passion. We believe in having transparency and openness across all parts of the company. We are committed to diversity and inclusion as we grow the Philo team and shape the future of TV -- we believe that a diverse set of voices and perspectives on our team enables us to innovate faster and create the best experience for our subscribers.

Philo is headquartered in San Francisco, with additional offices in New York and Cambridge, MA. Our leadership team includes a cofounder of Facebook as well as alums of Meraki and HBO. Philo is backed by NEA and industry partners including Discovery, Viacom, AMC, and A&E.

Projected Start Date: ASAP
Status: Full-time
Location: Boston, NY, San Francisco

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
  • Flexible working hours
  • Generous 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)
  • $5000 annually for professional development and educational assistance
  • $500 “TV stipend” for new employees to upgrade their home watching setup
  • Dog-friendly office
  • And much more!

For California Residents: Philo’s CCPA Notice at Collection – Employees, Applicants, Owners, Directors, Officers and Contractors

Apply for this Job

* Required

  
  


Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Philo’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.