Data Engineer

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

We are looking for a skilled Data Engineer to join our Business Intelligence team at Smarty, a growing SaaS company. In this role, you will be responsible for designing, building, and maintaining the data infrastructure that powers our analytics and reporting capabilities. You will work closely with data analysts and business stakeholders to ensure that clean, reliable, and well-structured data is always available when and where it's needed.

This is an onsite, non-remote position in Orem, UT.

What You'll Do

• Design, build, and maintain scalable data pipelines and ELT workflows using open-source/self-hosted Airbyte and custom Python
• Develop and maintain dbt models, tests, and documentation to transform raw source data into reliable fact and dimension tables
• Manage and optimize our 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 such as HubSpot, MySQL databases, Google Analytics, and others
• Write and maintain bespoke Python pipelines for sources and use cases not well-served by off-the-shelf connectors
• Monitor pipeline health via AWS CloudWatch, respond to failures, and maintain data quality through dbt testing
• Manage AWS services including ECS/ECR (containerized pipeline execution), Secrets Manager, SNS, and IAM
• Collaborate with data analysts to support Power BI reporting, including scheduled semantic model refreshes
• Document data architecture, pipelines, and operational runbooks to support team knowledge and continuity

Who You Are

• 3+ years of experience in a Data Engineering or similar role
• Strong hands-on experience with dbt (data build tool) — modeling, incremental strategies, testing, and documentation
• Proficiency in Python for data pipeline development and automation
• Strong working knowledge of AWS data services, including:
• Amazon S3 — storage management, partitioning, lifecycle
• Amazon Athena — query optimization, DDL management
• AWS Glue — data catalog, crawlers, DDL management
• AWS Lambda — event-driven processing and automation
• AWS Step Functions & EventBridge — pipeline orchestration and scheduling
• AWS ECS/ECR — running containerized workloads
• AWS CloudFormation — infrastructure as code
• AWS CloudWatch — logging and monitoring
• AWS IAM & Secrets Manager — permissions and credential management
• Experience managing an Airbyte (or similar ELT tool such as Fivetran) deployment and its source connections
• Solid SQL skills and comfort with data modeling concepts (staging, intermediate, fact/dimension layers)
• Familiarity with MySQL or similar relational databases as data sources
• Experience with version control (Git/Bitbucket or similar) and code review workflows
• Strong problem-solving skills and a proactive approach to pipeline monitoring and data quality
• Nice to have:
• Experience integrating with SaaS APIs such as Salesforce, HubSpot, Google Analytics, or Help Scout
• Familiarity with Power BI or other BI tools (Tableau, Looker, etc.)
• Experience with reverse ETL patterns (pushing transformed data back to source systems)
• Experience working in a SaaS company environment or with product usage/billing data
• Familiarity with Apache Iceberg or similar table formats (VACUUM/OPTIMIZE operations)
• AWS certifications (e.g., AWS Certified Data Engineer, Solutions Architect)

Benefits and Perks

• Competitive compensation (DOE)
• Range for this role is $90k - $120k
• 100% paid health, dental, and basic life insurance premiums (including family coverage)
• Long-term disability insurance
• Generous PTO that increases with tenure
• 401(k) with company matching
• Ongoing training and professional development
• Adjustable standing desk and modern tools
• Drinks, snacks, team lunches, and activities
• In-office chiropractic services
• Company retreats and trips to genuinely fun places

We are an Equal Opportunity Employer and we require all candidates (that receive and accept employment offers) to complete a background check.

About Smarty

Since its founding in 2011, Smarty has become a recognized industry leader in address data intelligence (exciting, we know). We provide enterprise-grade SaaS solutions worldwide for address validation, geocoding, and data enrichment.

Our culture is all about creating, building, helping, and collaborating with energy and excitement. We want to enjoy our time together by being outward toward others, making appropriate efforts to master our respective crafts, and doing lots of fun things together.