Staff Analytics Engineer

RxBenefits, Inc.

5h•$132,000 - $165,000•Remote

About The Position

The Staff Analytics Engineer contributes to the creation and maintenance of the enterprise data warehouse that will support all reporting and analytic functions at the company. This position analyzes, tests, and implements ELT, connections, and extracts supporting various business applications (including definition, structure, documentation, long-range requirements, operational guidelines). Ensures data warehouse resilience, availability, recovery, maintenance, data integrity and capacity planning requirements. Provides a high degree of coordination between user, technical, application and corporate entities to ensure effective data management as a corporate enterprise. Has a willingness to work with customers of varying levels of technical ability in a growing, complex environment.

Requirements

5 years Database SQL development (Snowflake/Oracle preferred)
Ability to create and tune highly complex SQL queries
5 years ETL/ELT/Reverse ETL data integration experience
Excellent knowledge creating and analyzing ETL and other data integrations
Experience with modern data pipeline tools (e.g., Fivetran, Airbyte, dbt, Prefect, Luigi, etc.)
1-2 years’ experience in Snowflake or cloud data warehouse platform (Redshift, Databricks, Firebolt) required
Advanced education/training in database development required
Knowledge of ER diagrams, data flow diagrams, and normalization techniques
Knowledge of Business Intelligence tools (Qlik, SAS, Tableau, Looker, etc.)
Experience in Snowflake required
Inquisitive and willing to learn business processes and innovative technologies
Team player with strong interpersonal skills
Experience mentoring and coaching other team members required

Responsibilities

Design and implement data pipeline solutions
Recommend tools and processes to maximize value
Ensure data reliability, efficiency, and quality
Automate data pipelines and data quality checks
Lead efforts focusing on cost optimization for data pipeline and warehouse consumption
Provide mentorship and coaching to Analytics Engineers and Senior Analytics Engineers
Work closely with the Data Architect to ensure data pipeline can feed and support data mart structure
Ensure standardization of coding practices and adherence to coding standards and change control
Ensures security policies are followed in relations to HIPAA (Health Insurance Portability and Accountability) compliance and company standards
All other duties as assigned

Benefits

Remote first work environment
Choice of a HDHP or PPO Medical plan, we pay 100% of the premium for the HDHP for you and your eligible family members
Dental, Vision, Short- and Long-Term Disability, and Group Life Insurance that we also pay 100% of premiums (for your family too on Dental and Vision)
Additional buy-up options for Short- and Long-Term Disability and Life Insurance
401(k) with an employer match up to 3.5% available after 60 days
Community Service Day to give back and support what you love in your community
10 company holidays including MLK Day, Juneteenth, and the day after Thanksgiving plus a floating holiday to use as you like
Reimbursements for high-speed internet, we’ll send you a computer and monitors to help you do your best work
Tuition Reimbursement for accredited degree programs
Paid New Parent Leave that can be used for adoption or birth
Pet insurance to protect your furbabies
A robust mental health benefit and EAP service through Spring Health to support you when you need it most