RxBenefits, Inc.Remote
Staff Analytics Engineer
United States of America
Full Time
3 weeks ago
$132,000 - $165,000 USD
H1B Sponsor Likely
Key skills
SQLDatabase developmentSnowflakeOracleETLELTReverse ETLData integrationData pipeline toolsCloud data warehouse platformsER diagramsData flow diagramsNormalization techniquesBusiness Intelligence toolsCoachingAnalyticsLookerBusiness IntelligenceTableauRedshiftDatabricksdbtFivetranMentoring
About this role
RxBenefits, Inc. is a company focused on creating and maintaining an enterprise data warehouse to support reporting and analytic functions. The Staff Analytics Engineer will design and implement data pipeline solutions, ensure data reliability and quality, and provide mentorship to other engineers.
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
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