Staff Analytics Engineer

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 most