Analytics Engineer
Redox
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, your responsibilities will include:
- Manage Redox’s 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.
To be successful in the role, your skills and experience should include:
- 3+ years with SQL and a cloud data warehouse (such as Redshift, BigQuery, Snowflake)
- Experience with data modeling business processes and writing performant SQL transforms in a data warehouse
- ETL/ELT experience, including scripted data pipelines
- “Full Stack” analytics (ingestion, warehousing, transformation, analysis/BI)
- Familiarity with working at the command line
Nice to have skills:
- Use of dbt or similar tools for data transformation
- Use of tools such as Airflow, Luigi for data orchestration
- Scripting in languages such as Python or JS
- Familiarity with successful data visualization principles and tools
- Familiarity with AWS Infrastructure such as S3 and Lambdas
- Use of big data technologies such as Hadoop, Presto, Spark
The base salary range for this position is expected to be between $120,000- 130,000 per year.