Analytics Engineer II
Analytics Engineer II
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 119200 - 156450
1 Vacancy
Job Description
Hi were Oscar. Were hiring an Analytics Engineer II to join our Data team.
Oscar is the first health insurance company built around a full stack technology platform and a focus on serving our members. We started Oscar in 2012 to create the kind of health insurance company we would want for ourselvesone that behaves like a doctor in the family.
About the role
The Analytics Engineer II plays a leading role in the design implementation optimization and maintenance of Oscars analytics platform including data transformation infrastructure and downstream semantic layer systems. You will help Oscar transition their CDS (Certified Datasets) from an inhouse data transformation tool to DBT. You will build and architect our DBT implementation with an eye towards improving our development workflows. You will also help manage selfservice BI in Looker onboarding new dimensional data models with performance and usability in mind. You will collaborate with business users and subject matter experts to explore data define requirements and deliver data products to our endusers. Youll help improve and enhance our analytics stack on an ongoing basis as we look to expand our capabilities in data services and governance.
You will report to the Associate Director Data.
Work Location:
Oscar is a blended work culture where everyone regardless of work type or location feels connected to their teammates our culture and our mission.
If you live within commutable distance to our New York City office (in Hudson Square) our Tempe office (off the 101 at University Dr) or our Los Angeles office (in Marina Del Rey) you will be expected to come into the office at least two days each week. Otherwise this is a remote / workfromhome role.
You must reside in one of the following states: Alabama Arizona California Colorado Connecticut Florida Georgia Illinois Indiana Iowa Kansas Kentucky Maine Maryland Massachusetts Michigan Minnesota Missouri Nevada New Hampshire New Jersey New Mexico New York North Carolina Ohio Oregon Pennsylvania Rhode Island South Carolina Tennessee Texas Utah Vermont Virginia Washington or Washington D.C. Note this list of states is subject to change. #LIRemote
Pay Transparency:
The base pay for this role in the states of California Connecticut New Jersey New York and Washington is: $119200 $156450 per year. You are also eligible for employee benefits participation in Oscars unlimited vacation program company equity grants and annual performance bonuses.
Responsibilities
- Develop an understanding and expertise of Oscars analytics technologies and tools contributing to the continuous improvement of Oscars analytics ecosystem.
- Play a role in the design build and implementation of the next generation of CDS utilizing technologies such as DBT Github actions and others as necessary with an eye towards improving data governance and developer productivity.
- Optimize our existing data models so they are more reliable efficient fast and scalable using dimensional modeling principles.
- Contribute to the administration of the analytics platform including but not limited to active participation in support channels and actioning on access requests.
- Lead crossfunctional shorttomid term projects focused on optimizing and scaling the analytics tech stack ensuring its efficiency and effectiveness in meeting business needs. Participate in build or buy analyses of additional services required.
- Contribute to the development and documentation of best practices for engineering and analytics development ensuring adherence to industry standards and internal guidelines.
- Work with other Analytics Engineers Subject Matter Experts and Business stakeholders to explore data and define business requirements for one or more data transformation and/or downstream semantic layer systems.
- Contribute towards development of our BI tools Looker and Looker Studio Pro improving performance adding new content and maintaining our process automation scripts.
- Train and mentor data scientists and data engineers in analytics engineering best practices.
Qualifications
- 3 years of experience in Analytics Engineering Data Science 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.
- 2 years of experience developing in a semantic modeling language (e.g. LookML).
- 2 years of experience developing within a modern data transformation tool like DBT.
- 2 years of experience with cloud database tools (GCP AWS Azure).
- 1 years of experience working with and presenting to nontechnical stakeholders.
Bonus Points
- Experience developing within a Business Intelligence Platform like Looker Tableau or Power BI.
- Experience integrating DBT and Looker (or equivalent ETLtoBI integration).
- Experience working with healthcare data analytics and reporting.
- Experience with GCP.
- Experience with Python.
- 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 nontechnical users.
This is an authentic Oscar Health job opportunity. Learn more about how you can safeguard yourself from recruitment fraud here.
At Oscar being an Equal Opportunity Employer means more than upholding discriminationfree hiring practices. It means that we cultivate an environment where people can be their most authentic selves and find both belonging and support. Were on a mission to change health care an experience made whole by our unique backgrounds and perspectives.
Pay Transparency: Final offer amounts within the base pay set forth above are determined by factors including your relevant skills education and experience. Fulltime employees are eligible for benefits including: medical dental and vision benefits 11 paid holidays paid sick time paid parental leave 401(k) plan participation life and disability insurance and paid wellness time and reimbursements.
Reasonable Accommodation: Oscar applicants are considered solely based on their qualifications without regard to applicants disability or need for accommodation. Any Oscar applicant who requires reasonable accommodations during the application process should contact the Oscar Benefits Team to make the need for an accommodation known.
Artificial Intelligence (AI) Guidelines: Please see our AI Guidelines for the acceptable use of artificial intelligence during the interview process at Oscar.
California Residents: For information about our collection use and disclosure of applicants personal information as well as applicants rights over their personal information please see our Notice to Job Applicants.
Employment Type
Full-Time
