Analytics Engineer
This role will help to shape the future of our centralized (hub and spoke) analytics service model as part of a fast growing team and company. As an Analytics Engineer at Podium, you will be responsible for the infrastructure that supports all analytics projects, dashboards, reports, and models. Your direct stakeholders will be the internal analytics team and you will work closely with talented Data Analysts, Data Engineers, and Data Scientists. The core responsibility requires you to create new data pipelines using SQL and scripting languages (R/Python). This role is a balance between a Data Analyst and a Data Engineer. You should be equally comfortable and excited about coding and modeling as you are about mentoring, training, and empowering a team of Analysts and Data Scientists.
Responsibilities:
- Design and implement a semantic data warehouse layer on top of our datalake using Snowflake and dbt
- Architect data models through SQL
- Collect and transform data using scripting languages (R/Python)
- Write documentation for best practices and to record Podium’s data
- Follow best practices around version control and mentor Data Analysts and Data Scientists on version control
Your background:
- 3+ years of work experience in SQL and experience with multiple flavors, Snowflake preferred
- 2+ years of work experience with a scripting language (R or Python)
- 2+ years of work experience using Git for version control
- Experience using dbt and Snowflake is desirable
- Strong drive to organize and document data in a reproducible manner
- Ability to understand the business logic for structuring data in a given way while also understanding and overcoming the technical limitations and challenges of implementing the desired data structure
- Eagerness to work on development of internal tools, systems, packages, process, and documentation
- You have a proven record of providing analyses that have tangible impact on the business
- Degree in Computer Science, Math, Statistics, Engineering, Economics, Information Systems, or hands on job experience with data science or analytics
- You are committed to honesty and a diverse and inclusive workplace