Senior Business Intelligence Engineer

Summary

Join Oscar, a health insurance company built on a full-stack technology platform, as a Senior Business Intelligence Engineer. You will be responsible for defining and executing the technical vision of Oscar's business intelligence platform, which includes Looker and DBT built on BigQuery. You will work hands-on with developers to improve data visualization infrastructure, semantic layer systems, and oversee supporting Python script infrastructure. You will ensure developers and end users receive the necessary support to achieve their goals, including designing, documenting, and improving architecture, CI/CD workflows, access paradigms, and development best practices. You will also influence the strategy of increasing user adoption and self-service. This role reports to the Associate Director, Analytics Engineering and is a blended work culture, allowing for remote work with the option to work from the New York City, Tempe, or Los Angeles offices at least two days a week. The base pay for this role is between $144,000 and $189,000 per year, and you are eligible for employee benefits, unlimited vacation, company equity grants, and annual performance bonuses.

Requirements

• 4+ years of experience in Analytics Engineering, Business Intelligence, or a related field
• 4+ years of experience working with a variety of database languages, including SQL, DDL and DML with demonstrated ability to efficiently transform data and databases
• 3+ years of experience developing in a semantic modeling language (e.g. LookML)
• 3+ years of experience working with a variety of business intelligence platforms, such as Looker (preferred), Tableau, PowerBI, or others
• 2+ years of experience working with and presenting to non-technical stakeholders

Responsibilities

• Champion development best practices for Looker development
• Scope CI/CD tools, automation, processes and guidelines to ensure adherence
• Level-up our existing dashboard infrastructure, partnering with developers to improve dashboard usability, visualization, and query performance
• Own the maintenance, optimization and expansion of our Business Intelligence platform (Looker) and LookML semantic layer
• Partner with business stakeholders to expand BI content areas, taking in stakeholder-defined business requirements, maintaining alignment, and delivering performant, scalable products that meet our end-user needs
• Lead cross-functional mid-to-long term projects focused on optimizing and scaling the business intelligence stack, ensuring its scale, performance, and ability to meet business needs
• Oversee the administration and support duties necessary to service the developers and end users of our platform, finding opportunities to build tools and automation to reduce the amount of inbound requests
• Develop an in-depth understanding and expertise of Oscar's analytics technologies and tools, contributing to the continuous improvement of Oscar's analytics ecosystem
• Provide training and mentorship to empower data scientists and data engineers, cultivating a culture of excellence in business intelligence and fostering continuous skill development

Preferred Qualifications

• Experience integrating DBT and Looker (or equivalent ETL-to-BI integration)
• Experience with Python or another OOP/scripting language
• Experience working with healthcare data, analytics and reporting
• Experience with GCP
• A background in healthcare and/or insurance
• Strong communication skills, verbal and written, as demonstrated by experience on at least 1 project or initiative requiring communication between technical and non-technical users

Benefits

• Medical, dental, and vision benefits
• 11 paid holidays
• Paid sick time
• Paid parental leave
• 401(k) plan participation
• Life and disability insurance
• Paid wellness time and reimbursements