Enable self-service analytics for all team members by designing clean, intuitive data models and metrics through dbt, empowering employees to make informed, data-driven decisions.
Develop and refine custom data pipelines that ingest data from operational systems to our analytics platform, handling both streaming and batch data using third-party tooling and homegrown solutions.
Maintain and optimize the data platform infrastructure, focusing on data quality, ELT efficiency, and platform hygiene.
Architect and implement key components of the analytics infrastructure, such as BI, semantic layers, and a foundational data warehouse.
Develop and maintain streaming data pipelines from various databases and data sources.
Collaborate across business units to understand data needs and ensure the required data is collected, modeled, and available to team members.
Document best practices and coach/advise other data analysts, product managers, engineers, etc. on data modeling, SQL query optimization & reusability, etc. Keep our data platform tidy by managing roles and permissions and deprecating old projects.
Requirements
5+ years of experience with a proven track record in data or analytics engineering.
Experience transforming raw data into clean models using standard tools of the modern data stack and a deep understanding of ELT and data modeling concepts.
Proficiency in python and orchestration tooling like prefect or dagster.
Experience in designing, building, and administering modern data pipelines and data warehouses.
Experience with dbt.
Experience with semantic layers like cube or metricflow.
Experience with Snowflake, BigQuery, or Redshift.
Experience with version control tools such as Github or Gitlab.
Experience with ELT tools such as Stitch or Fivetran.
Experience with CI/CD and IaaC tooling such as github Actions and Terraform.
Experience with business intelligence solutions (Metabase, Looker, Tableau, Periscope, Mode)
Excellent communication and project management skills with a customer service focused mindset.
Be sure to mention "coffee" in your application so we know you read this.
Tech Stack
Amazon Redshift
BigQuery
Python
SQL
Tableau
Terraform
Benefits
Multiple health/dental coverage options (100% coverage for employee, 50% for family)