Analytics Engineer

As an Analytics Engineer for RVO Health, you will be responsible for designing, building, and optimizing the Looker semantic layer. You will leverage your extensive data modeling knowledge to deliver high-quality analytics-ready datasets and provide expertise on setting up a HIPAA compliant Looker environment. Additionally, you will partner with data engineers to improve the internal data infrastructure and support the initial implementation and maintenance of Looker in a HIPAA compliant environment. This role requires experience with Looker implementation, data warehouses, LookML, SQL, and Python/Scala for data analysis.

Design, build and optimize the Looker semantic layer

Design, develop and automate high-quality, scalable solutions across the entire data lifecycle

Leverage extensive data modeling knowledge to design and deliver best-in-class analytics-ready datasets

Provide expertise and guidance on setting up a HIPAA compliant Looker environment to support multiple HIPAA compliant and non-HIPAA businesses across the enterprise

Partner with data engineers to define, build and improve our internal data infrastructure

Experience with Looker implementation, leading/driving the project and taking the implementation to completion

5+ year’s experience working with Data Warehouses (eg. Redshift, Snowflake, BigQuery)

2+ years of LookML and Looker-specific experience

Experience maintaining and debugging LookML code, building user-friendly Explores and defining caching policies

Experience optimizing queries, data modeling layer and LookML for report performance

Strong analytical and interpersonal skills

Excellent understanding of data development processes and agile methodologies

Experience with the initial implementation and maintenance of Looker in a HIPAA compliant environment

Experience supporting and automating reporting infrastructure and deployment pipelines (Looker, GitHub, pull request process)

Advanced knowledge of SQL, Python and/or Scala for data analysis

• Design, build and optimize the Looker semantic layer
• Design, develop and automate high-quality, scalable solutions across the entire data lifecycle
• Leverage extensive data modeling knowledge to design and deliver best-in-class analytics-ready datasets
• Provide expertise and guidance on setting up a HIPAA compliant Looker environment to support multiple HIPAA compliant and non-HIPAA businesses across the enterprise
• Partner with data engineers to define, build and improve internal data infrastructure
• Experience with Looker implementation, leading/driving the project and taking the implementation to completion
• 5+ years of experience working with Data Warehouses (eg. Redshift, Snowflake, BigQuery)
• 2+ years of LookML and Looker-specific experience
• Experience maintaining and debugging LookML code, building user-friendly Explores and defining caching policies
• Experience optimizing queries, data modeling layer, and LookML for report performance
• Strong analytical and interpersonal skills
• Excellent understanding of data development processes and agile methodologies
• Experience with the initial implementation and maintenance of Looker in a HIPAA compliant environment
• Experience supporting and automating reporting infrastructure and deployment pipelines (Looker, GitHub, pull request process)
• Advanced knowledge of SQL, Python, and/or Scala for data analysis

• Health Insurance Coverage (medical, dental, and vision)
• Life Insurance
• Short and Long-Term Disability Insurance
• Flexible Spending Accounts
• Paid Time Off
• Holiday Pay
• 401(k) with match
• Employee Assistance Program
• Paid Parental Bonding Benefit Program