dbt / Data Engineer

Pioneer IT Systems LLC
Des Plaines, IL, United States
24 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
4 years minimum
Working hours
Regular working hours
Job source

Tech stack

Databases Continuous Integration Information Engineering Data Integration Data Transformation Data Systems Data Vault Modeling Dimensional Modeling Python (Programming Language) Microsoft SQL Server Power BI Freeform SQL
+7 more
Azure Data Factory Sql Optimization Snowflake Git Star Schema Data Management Data Pipelines

Job description

We are seeking an experienced dbt Engineer / Data Engineer to support the transitioning, development and modernization of a healthcare data and analytics platform.

  • Design, develop, test, and deploy production-grade dbt models, including dependencies, tests, and data transformations.
  • Develop and optimize data solutions transitioning data from SQL Server into Snowflake while managing complex SQL queries and data pipelines.
  • Configure and troubleshoot ADF connectors and data-integration processes.
  • Build analytical datasets, dimensional models, and Power BI dashboards/reports for business users.

Technical Stack

Expert: dbt, hands-on experience with models, dependencies, packages and deployments

Strong: Snowflake, SQL Server, advanced SQL, databases, Power BI

Hands-on: ADF (Azure Data Factory), Python, Git

Data Modeling: Star schema, dimensional modeling, Data Vault

Preferred: CI/CD

Requirements

Experience: At least 10 years in Data Engineering, minimum 4 years with dbt

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

4:59 min

Bringing DevOps practices to data transformation with DBT

Matthias Niehoff Matthias Niehoff · World Congress 2024

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

2:10 min

Validating data state and utilizing open-source dbt packages

Matthias Niehoff Matthias Niehoff · World Congress 2023

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · World Congress 2022

Videos

See all

Related articles

See all