• Responsible for delivering enterprise-level data solutions that empower business partners to provide affordable, high-quality patient care and services. • Engages with business owners and stakeholders to design and implement robust BI and analytics capabilities. • Develops, tests, and documents business intelligence and analytics solutions primarily leveraging Epic Clarity and Caboodle data models. • Collaborates with the BI Architect on the creation of custom Caboodle data models and maintenance of BI solutions. • Participates in design reviews, code standards, and development best practices. • Troubleshoots, diagnoses, and resolves ETL process failures and data anomalies.

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 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, and we’re looking for people who are comfortable working on complex data infrastructure and modeling challenges that support critical business functions across our streaming services. You’ll be working closely with other data scientists, analysts, and engineers to build and deploy solutions directly for our service – this work spans both foundational data platform work like data warehouse architecture, metric governance, and semantic consistency across our entire data stack. In addition, you’ll work with departments across the organization to understand their data needs and deliver high-performance, reliable data systems to help the entire team thrive. We are passionate about building robust, scalable data infrastructure and providing a high-quality data platform for the entire company, using both cutting-edge technologies and proven engineering practices in close collaboration with every department. To complete our work, we build on modern tools including AWS-native services, dbt, Segment, Snowflake, AWS SageMaker, Spark, Avo, BigEye and more. Some of the recent projects that data and analytics engineers at Philo have worked on include building new models for key financial data, dbt model design, data warehouse cluster upgrades and maintenance, per-query infra cost optimization, implementation of Apache Iceberg data storage, benchmarking & improving data warehouse performance, and evaluating alternative data warehouse technologies. The Role We're seeking a senior technical and foundational leader to own and drive the vision, strategy, and execution of our Data Engineering team, encompassing both the data engineering and analytics engineering functions at Philo. This is a strategic and high-impact role: you'll set the long-term direction for our entire data platform, lead and grow a team of data and analytics engineers, and roll up your sleeves to architect and build alongside them. The ideal candidate has owned both disciplines before — data infrastructure and analytics engineering — and brings strong opinions on how to structure a high-velocity, high-trust data organization. Responsibilities: - Own the vision and technical strategy for data engineering and analytics engineering at Philo, setting the direction for how data is ingested, modeled, and delivered across the organization - Own the team’s roadmap, balancing strategic long-term investments with near-term stakeholder needs - Lead and grow the Data Engineering team, including hiring, career development, performance management, and supporting the team in generally thriving - Lead the design and implementation of Philo's data platform architecture, including setting technical standards and best practices for data engineering and analytics engineering work - Collaborate with cross-functional teams to understand data platform needs and translate business requirements into technical solutions - Build and maintain stakeholder trust in data and reporting — ensuring that business teams have reliable, well-documented, and well-understood data products - Design scalable data pipelines and infrastructure; drive technical decisions with a focus on long-term sustainability - Implement data governance, security, and quality control processes as needed - Ultimately, deliver on the alchemy of transforming raw, messy application data into trusted business insight through scalable dimensional modeling and a metric layer that faithfully reflects product and customer behavior. Key Qualifications: - 10+ years of professional experience spanning data engineering and analytics engineering, ideally with a few years working on high-volume data platforms - 4+ years of experience managing and leading data teams, with demonstrated experience owning both data engineering and analytics engineering functions at a prior organization - Deep expertise in modern data stack technologies, particularly AWS data services, Snowflake, dbt, Airflow, Airbyte, Python, and SQL - Deep expertise in analytics engineering, including dbt model design, dimensional modeling, and delivering trusted, business-facing data products - Strong people management skills with experience providing coaching, performance feedback, and career development guidance to direct reports. - Track record of improving stakeholder trust in reporting and data quality across an organization - Strong track record of designing and implementing data platforms - Excellent communication skills with technical and non-technical stakeholders, simplifying complex data concepts for various business audiences Ideal Qualifications: - Experience in media/streaming industry with understanding of video delivery analytics and metrics - Demonstrated experience driving organizational alignment around data definitions, metrics, and a single source of truth - Experience with data governance and compliance requirements - Background in implementing data quality frameworks 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 service also includes 100+ free channels and premium add-ons like STARZ and MGM+. 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: $240K - $275K - Boston, DC Metro, Los Angeles, Seattle: $225K - $260K - Denver, Atlanta, Austin, Las Vegas, Sacramento, Chicago: $215K - $250K - Texas, Florida: $200K - $235K 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.

Why OpenlyOpenly is rebuilding insurance from the ground up. We are re-envisioning and enhancing every aspect of the customer experience. Doing this requires a rapidly growing team of exceptional, curious, empathetic people with a wide range of skill sets, spanning technology, data science, product, marketing, sales, service, claims handling, finance, etc. The Openly DifferenceWe created Openly because we saw an evident gap in the market for premium insurance made simple. Consumers deserve more complete coverage at competitive prices. - The Price Difference: Using cutting-edge data and technology, we provide you with customizable, competitive prices to protect your most valuable assets. - The Policy Difference: Coverages are truly customizable to meet your individual protection needs, for both standard coverages and optional add-ons. - The Experience Difference: From tailored claims handling to highly responsive customer service, we are focused on making the home insurance purchasing process a better overall experience. Welcome to your next adventure.At Openly, our people are just as important as our product. For us, collaboration, communication, and work-life balance are more than nice-to-haves— they’re the must-haves that make us who we are. We believe a great company is the result of a shared set of values, so we look for these qualities in every candidate we hire. - Integrity - Empathy - Teamwork - Curiosity - Urgency We've designed our hiring process with you, the candidate, in mind. At every step, you have the chance to present your strengths and learn more about what makes Openly a great place to work. We're committed to Diversity, Equity, & InclusionWe embrace individuality and believe diverse teams are winning teams. Our commitment to inclusion across race, gender, age, religion, identity, and experience drives us forward every day. Job Details We are seeking a Senior Data Engineer to be a technical leader on our data engineering team. This role involves designing and delivering robust, scalable data solutions for Openly's insurance platform. You will apply deep expertise across the data lifecycle—from architecture and pipeline design to optimization and mentoring—to shape how we build, manage, and access data for our products and business intelligence. Key Responsibilities - Architect, build, and maintain high-quality, scalable data pipelines, data models, and data infrastructure across our GCP-based platform. - Lead technical design decisions related to data architecture, pipeline orchestration, data modeling, and cloud infrastructure. - Develop and optimize complex SQL queries and data transformations in BigQuery and PostgreSQL, ensuring performance, reliability, and correctness. - Write production-grade code in Python and/or Go to build and enhance data management frameworks, services, and pipeline tooling. - Partner with data science, business intelligence, product, and operations teams to translate business requirements into reliable data solutions. - Own and improve the full Software Development Lifecycle (SDLC) for data projects: design, development, testing, CI/CD deployment, monitoring, and maintenance. - Leverage streaming and event-driven architectures using Kafka (Aiven/Debezium) to build real-time data pipelines. - Utilize and optimize distributed data processing frameworks such as Apache Spark for large-scale data transformations. - Mentor and provide technical guidance to junior and mid-level data engineers; conduct code reviews and promote engineering best practices. - Share your knowledge within the data engineer team and the engineering organization through all-hands presentations, learning hours, domain meetings, and written documentation. Our stack - Backend/Core: Go & Postgresql - Frontend: Browser-based, VueJS, Vite, Webpack, Nuxt & Tailwind - Research/Data Science: R, ArcGIS, Vertex, & Python - Data: GCP GCS, BigQuery, Composer/Airflow, Cloud Functions, Postgres, SQL, Python, Aiven Debezium and Kafka, Fivetran - Infrastructure: Google Cloud, specifically Cloud Run, Kubernetes, Pub/Sub, BigQuery, and CloudSQL, managed with Terraform. We use GitHub for code hosting, DataDog and for monitoring, PagerDuty for on-call, and CircleCI for running our CI/CD pipelines. - Remote work tools: Slack, Zoom Requirements - 4+ years of data engineering and data management experience, with a proven track record of delivering complex, production-grade data systems. - Strong proficiency in SQL and SQL optimization — including query tuning, indexing strategies, execution plan analysis, and data modeling in BigQuery and PostgreSQL. - Expert-level scripting and programming in Python; experience with Go is a strong plus. - Deep expertise with Google Cloud Platform (GCP), including BigQuery, GCS, Composer/Airflow, Cloud Functions, Cloud Run, Pub/Sub, and CloudSQL. - Proven experience building and operating event-driven and streaming data pipelines using Kafka or similar technologies (Aiven/Debezium experience a plus). - Strong understanding of modern data warehouse and Lakehouse architectures, including multi-layered data modeling patterns (bronze/silver/gold or equivalent). - Infrastructure as Code (IaC) experience with Terraform to define, manage, and version cloud data infrastructure. - Solid understanding of Software Development Lifecycle (SDLC) best practices: CI/CD pipelines, automated testing, code review processes, code repositories, and deployment management. - Experience with data replication tools (e.g., Fivetran, Debezium) and understanding of CDC (Change Data Capture) patterns. - Ability to independently drive data architecture decisions, translate business requirements into source-to-target data mappings, and deliver working, maintainable solutions. - Strong communication skills; able to effectively collaborate with and educate both technical and non-technical stakeholders. - Experience mentoring engineers and leading technical initiatives within a team environment. Nice to Have - Hands-on experience with Apache Spark or other distributed data processing frameworks for large-scale batch and/or streaming workloads. - Familiarity with data observability and monitoring tools (e.g., DataDog, Monte Carlo, Great Expectations). - Prior experience in a regulated industry such as insurance, finance, or healthcare. - Contributions to open-source data engineering projects or internal data platform tooling. - Experience with AI tools such as Claude, Copilot or equivalent Compensation & Benefits: Below is the budgeted salary range for this position. Actual compensation for this position will be determined based on the successful candidate's experience and skills. We are committed to providing a compensation package that not only reflects the responsibilities and requirements of the role, but also the unique expertise that the chosen candidate will bring to our team. Budgeted Salary Range $140,800—$158,400 USD The full salary range shows the min to max salary range for this position. Actual compensation will be commensurate with experience and qualifications and determined based on various factors including the candidate's qualifications, skills, and experience. Full Salary Range $140,800—$211,200 USD Benefits & Perks - Remote-First Culture - We supported #remotelife long before it was a given. We'll keep promoting it. - Competitive Salary & Equity - Comprehensive Medical, Dental, and Vision Plan Offerings - Life and disability coverage including voluntary options - Parental Leave - up to 8 weeks (320 hours) of paid parental leave based on meeting eligibility requirements (Birthing parents may be eligible for additional leave through STD) - 401K Company Contribution - Openly contributes 3% of the employee's gross income, even if the employee does not contribute. - Work-from-home stipend - We provide a $1,500 allowance to spend on setting up your home workplace - Annual Professional Development Fund: Each employee has $2,000 in professional development (PD) funds to spend on activities or resources annually. We want each Openly employee to achieve personal and professional success and to feel supported, confident, and informed about improving their efficiency and productivity. - Be Well Program - Employees receive $50 per month to use towards your overall well-being - Paid Volunteer Service Hours - Referral Program and Reward Depending on position, Employees generally are eligible for cash incentive compensation, including commissions for sales eligible roles. In all cases, eligibility for compensation and benefits is subject to applicable plan and policy terms in effect from time to time. U.S. Citizens, Green Card Holders, and those authorized to work in the U.S. for any employer and currently residing in the US will be considered. Openly is committed to equal employment opportunity and non-discrimination for all employees and qualified applicants without regard to a person's race, color, sex, gender identity or expression, age, religion, national origin, ancestry, ethnicity, disability, veteran status, genetic information, sexual orientation, marital status, or any characteristic protected under applicable law. Openly is an E-Verify Employer in the United States. Openly will make reasonable accommodations for qualified individuals with known disabilities under applicable law. We strive to provide an exceptional applicant and candidate journey when you engage with us. In an effort to respond to applicants in a timely manner, we leverage AI to organize applications and resumes based on required and applicable skills and experience. To allow our applicants to drive their initial interview experience with us, we may leverage an AI-supported scheduling tool so you can choose when to meet with our team. While AI assists with efficiency, all hiring decisions are made by our team members. Rest assured, your data is protected according to privacy laws and company policies. Contact our recruitment team with any questions about our AI-assisted hiring process.

• Passionate about teaching and eager to share knowledge as a freelancer • Act as a coach with a strong understanding of people and their motivations • Explain complex topics to new practitioners • Adapt to the diverse challenges of each day and each course • Apply a range of skills such as people leadership, project expertise, presentation and communication • Work in an agile way, iterating on and experimenting with materials to create great outcomes for students