Senior Business Intelligence Engineer

Summary

Join Oscar's Data team as a Business Intelligence Engineer II and optimize our Business Intelligence platform, encompassing Looker and dbt on BigQuery. Bridge the gap between business needs and technical solutions, ensuring user-friendliness and high performance. This role involves leading platform maintenance, expansion, and scaling, collaborating with stakeholders to deliver effective BI solutions. You will also mentor data scientists and engineers, fostering a culture of excellence. The position offers a blended work culture with remote options and a competitive salary range of $119,200-$156,450 per year, along with comprehensive benefits.

Requirements

• 3+ years of experience in Analytics Engineering, Business Intelligence, or a related field
• 3+ 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 working with a variety of business intelligence platforms, such as Looker, Tableau, PowerBI, or others
• 2+ years of experience developing in a semantic modeling language (e.g. LookML)
• 1+ years of experience working with and presenting to non-technical stakeholders
• 1+ years experience with Python or another OOP/scripting language

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
• Lead the maintenance, optimization and expansion of our Business Intelligence platform (Looker) and LookML semantic layer
• Partner with stakeholders to expand BI content areas, taking in business requirements, maintaining alignment, and delivering performant, scalable products that meet our end-user needs
• Scale our business intelligence stack by improving query performance, overseeing the administration, supporting duties necessary to service the developers and end-users of our platform, and 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, contributing to the continuous improvement of Oscar's analytics ecosystem
• Provide training and mentorship to empower data scientists and data engineers, to promote a culture of excellence in business intelligence and encourage skill development

Preferred Qualifications

• Experience integrating DBT and Looker (or equivalent ETL-to-BI integration)
• Experience working with healthcare data, analytics, and reporting
• Experience with GCP
• A background in healthcare and/or insurance
• Experience communicating updates and resolutions to technical and non-technical end users, exhibited through at least 1 project or initiative

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