Data Warehouse Engineer
Core
Build and optimize a Snowflake data warehouse to support Business Intelligence teams and drive informed decision-making across the organization.
Role type
Junior Data Warehouse Engineer
Builds
Dimensional data models, ETL pipelines, and data storage/transformation solutions in Snowflake
Domain
Manufacturing software (PTC) / Cloud Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL, dimensional data modeling, Snowflake, ETL concepts, Git, Python (introductory)
Preferred skills
DBT, Apache Airflow, Terraform, Docker, GitLab CI/CD, SaaS business models, Agile methodologies
Technologies
Snowflake, DBT, Apache Airflow, GitLab, Terraform, Docker, Great Expectations
Responsibilities
Develop dimensional data models for subject areas like Technical Support and Web Analytics; Assist in creating and maintaining ETL pipelines; Manage Snowflake assets and optimize storage/compute; Collaborate with BI developers to provide data sets for analytics; Troubleshoot data warehouse and ETL issues; Document data models and processes.
Seniority
Junior, early career with mentorship
