Data Engineer

• 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

• 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)

401(k) matching, Paid time off, Dental insurance, Life insurance, Disability insurance Full-time Orem, UT 84058, * 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 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., 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.