Onsite Data Engineer — AWS, dbt & Pipelines

Smarty; Orem (UT); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

100% paid health, dental, and basic v

Long-term disability insurance

401(k) with company matching

In-office chiropractic services

Company retreats and trips

Job summary

Smarty in Orem, UT is seeking a skilled Data Engineer to design, build, and maintain data infrastructure powering analytics and reporting. You will work with analysts and stakeholders to ensure clean, reliable data accessible where needed.

Onsite role in Orem, UT with a focus on AWS data services, Airbyte, dbt, and Python. Collaboration with BI to support Power BI reporting and data quality through tests and automation.

Qualifications

• 3+ years of experience in a Data Engineering or similar role.
• Strong hands-on experience with dbt — modeling, incremental strategies, testing, and documentation.

Responsibilities

• Design, build, and maintain scalable data pipelines and ELT workflows using open-source/self-hosted Airbyte and Python.
• Develop and maintain dbt models, tests, and documentation to transform raw source data into reliable fact and dimension tables.
• Manage and optimize AWS data lakehouse architecture, including S3 storage, Glue data catalog, and Athena query layer.
• Orchestrate automated data workflows using AWS Step Functions and EventBridge schedules.
• Deploy and manage Lambda functions for near-real-time pipelines, reverse ETL, and Slack-based data delivery.
• Manage infrastructure as code using AWS CloudFormation for Lambdas, Step Functions, and Glue resources.
• Maintain and administer Airbyte for data ingestion across sources (HubSpot, MySQL, GA, etc.).
• Write and maintain bespoke Python pipelines for custom sources.
• Monitor pipeline health via AWS CloudWatch, respond to failures, and ensure data quality with dbt tests.
• Manage AWS services including ECS/ECR, Secrets Manager, SNS, and IAM.
• Collaborate with data analysts to support Power BI reporting with scheduled semantic model refreshes.
• Document data architecture, pipelines, and runbooks.

Skills

dbt

Python

SQL

AWS data services

Airbyte

Power BI

Tableau

Git/Bitbucket

data modeling

ETL/ELT

Tools

Amazon S3

Amazon Athena

AWS Glue

AWS Lambda

AWS Step Functions

EventBridge

AWS ECS/ECR

AWS CloudFormation

AWS CloudWatch

Secrets Manager

MySQL

HubSpot

Job description

Smarty in Orem, UT is seeking a skilled Data Engineer to design, build, and maintain data infrastructure powering analytics and reporting. You will work with analysts and stakeholders to ensure clean, reliable data accessible where needed.

Onsite role in Orem, UT with a focus on AWS data services, Airbyte, dbt, and Python. Collaboration with BI to support Power BI reporting and data quality through tests and automation.