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 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.