Analytics Engineer
Salary
The base salary range for this position is expected to be between $123,000- $135,000 per year.
Redox is on a mission to accelerate healthcare’s transformation with useful data. Redox accelerates the development and distribution of healthcare products with a full-service integration platform to securely and efficiently exchange healthcare data. With just one connection, data can be transmitted across a growing network of 7,300+ provider organizations and 240+ healthcare products. Redox connections serve tens of millions of patient records per day, leveraging a single data standard compatible with more than 90 electronic health record systems.
As an Analytics Engineer, you’ll be primarily responsible for the development and evolution of our analytics infrastructure, namely our data ingestion, warehousing, transformation, and analysis. We’re looking for a curious and adaptable data enthusiast who can translate business needs from subject matter experts into usable data models that will drive the organization’s decision-making and growth.
As an Analytics Engineer, some of your responsibilities will include:
- Manage our analytics infrastructure: ELT/ETL processes, data warehouse, data orchestration and transformation tools, and business intelligence and presentation layer.
- Build usable and performant data marts ready for analysis and end-user consumption.
- Engage with business stakeholders to understand the questions driving the business and distill them into the right data sets.
Background and experience needed:
- 3+ years with SQL and a cloud data warehouse (Redshift, BigQuery, Snowflake, etc.)
- Experience with data modeling business processes and writing performant SQL transforms in a data warehouse
- 1+ years experience designing data pipelines using Python as well as commodity ELT (e.g., Stitch / Fivetran).
- “Full Stack” analytics (ingestion, warehousing, transformation, analysis/BI)
Other must have skills:
- SQL for analytics and ETL/ELT
- dbt for building a data warehouse
- Python for data analytics and building data pipelines
Skills that are preferred but not required:
- Data orchestration: Airflow, Luigi, etc.
- Other scripting languages (e.g., JS)
- Familiarity with successful data visualization principles and tools
- AWS and/or GCP Infrastructure
- Big data technologies: Presto, Spark, etc.