Job Information
RxBenefits Staff Analytics Engineer in Salt Lake City, Utah
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.
Essential Job Responsibilities Include:
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
Required Skills / Experience:
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
Based on relevant market data and other factors, the anticipated hiring range for this role is $132,000 - $165,000 annually. Final compensation rates will be determined based on various factors, including but not limited to experience, skills, knowledge, and internal equity considerations. This role is also short-term incentive eligible. Incentive amounts will vary by individual and business goals.
We are committed to fair and equitable compensation practices. The final salary offered to the selected candidate may vary from the posted range due to individual qualifications. Our goal is to ensure that all teammates are compensated fairly and competitively based on their contributions to our organization.
RxBenefits is also committed to providing best in class benefits to our teammates. We offer a robust total rewards package that includes:
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 mos t
RxBenefits provides equal opportunities for everyone who works for us and everyone who applies to join our team, without regard to sex or gender, gender identity, gender expression, age, race, religious creed, color, national origin, ancestry, pregnancy, physical or mental disability, medical condition, genetic information, marital status, sexual orientation, any service, past, present, or future, in the uniformed services of the United States (military or veteran status), or any other consideration protected by federal, state, or local law.