Data Engineer

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

Benefits offered by this job

Health insurance

Dental insurance

Life insurance

Paid time off

401(k) with match

Training & development

Job summary

Smarty, LLC. in Orem, UT is hiring a Data Engineer for its Business Intelligence team. You will design, build, and maintain scalable data pipelines and the AWS data lakehouse to power analytics and reporting for stakeholders.

The role emphasizes reliable, well-structured data and close collaboration with data analysts. You’ll implement dbt models and Python pipelines, manage AWS services, orchestrate workflows, and contribute to data quality through testing, documentation, and runbooks in a SaaS

Qualifications

• 3+ years of experience in a Data Engineering or similar role.
• dbt modeling, testing, and documentation.
• Python for data pipeline development.
• AWS data services including S3, Athena, Glue, and Lambda.
• Airbyte deployment and maintenance.
• SQL and data modeling concepts.
• Git/version control and code review workflow.
• Experience with SaaS APIs such as Salesforce, HubSpot, Google Analytics.

Responsibilities

• Design, build, and maintain scalable data pipelines and ELT workflows.
• Develop and maintain dbt models, tests, and docs.
• Manage AWS data lakehouse (S3, Glue, Athena) and orchestration with Step Functions.
• Deploy Lambda functions for near-real-time pipelines and reverse ETL.
• Manage infrastructure as code with CloudFormation.
• Collaborate with data analysts for Power BI reporting and semantic models.
• Monitor pipeline health with CloudWatch and ensure data quality via dbt tests.
• Document data architecture and runbooks.

Skills

dbt

Python

AWS services

SQL

Airbyte

Git

Data modeling

MySQL

ETL pipelines

Power BI

APIs integration

Reverse ETL

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.