Data Engineer

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 DoDesign, build, and maintain scalable data pipelines and ELT workflows using open-source/self-hosted Airbyte and custom PythonDevelop and maintain dbt models, tests, and documentation to transform raw source data into reliable fact and dimension tablesManage and optimize our AWS data lakehouse architecture, including S3 storage, Glue data catalog, and Athena query layerOrchestrate automated data workflows using AWS Step Functions and EventBridge schedulesDeploy and manage Lambda functions for near-real-time pipelines, reverse ETL, and Slack-based data deliveryManage infrastructure as code using AWS CloudFormation for Lambdas, Step Functions, and Glue resourcesMaintain and administer Airbyte for data ingestion across sources such as HubSpot, MySQL databases, Google Analytics, and othersWrite and maintain bespoke Python pipelines for sources and use cases not well-served by off-the-shelf connectorsMonitor pipeline health via AWS CloudWatch, respond to failures, and maintain data quality through dbt testingManage AWS services including ECS/ECR (containerized pipeline execution), Secrets Manager, SNS, and IAMCollaborate with data analysts to support Power BI reporting, including scheduled semantic model refreshesDocument data architecture, pipelines, and operational runbooks to support team knowledge and continuityWho You Are3+ years of experience in a Data Engineering or similar roleStrong hands-on experience with dbt (data build tool) — modeling, incremental strategies, testing, and documentationProficiency in Python for data pipeline development and automationStrong working knowledge of AWS data services, including:Amazon S3 — storage management, partitioning, lifecycleAmazon Athena — query optimization, DDL managementAWS Glue — data catalog, crawlers, DDL managementAWS Lambda — event-driven processing and automationAWS Step Functions & EventBridge — pipeline orchestration and schedulingAWS ECS/ECR — running containerized workloadsAWS CloudFormation — infrastructure as codeAWS CloudWatch — logging and monitoringAWS IAM & Secrets Manager — permissions and credential managementExperience managing an Airbyte (or similar ELT tool such as Fivetran) deployment and its source connectionsSolid SQL skills and comfort with data modeling concepts (staging, intermediate, fact/dimension layers)Familiarity with MySQL or similar relational databases as data sourcesExperience with version control (Git/Bitbucket or similar) and code review workflowsStrong problem-solving skills and a proactive approach to pipeline monitoring and data qualityNice to have:Experience integrating with SaaS APIs such as Salesforce, HubSpot, Google Analytics, or Help ScoutFamiliarity 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 dataFamiliarity with Apache Iceberg or similar table formats (VACUUM/OPTIMIZE operations)AWS certifications (e.g., AWS Certified Data Engineer, Solutions Architect)Benefits and PerksCompetitive compensation (DOE)100% paid health, dental, and basic life insurance premiums (including family coverage)Long-term disability insuranceGenerous PTO that increases with tenure401(k) with company matchingOngoing training and professional developmentAdjustable standing desk and modern toolsDrinks, snacks, team lunches, and activitiesIn-office chiropractic servicesCompany retreats and trips to genuinely fun placesWe are an Equal Opportunity Employer and we require all candidates (that receive and accept employment offers) to complete a background check.J-18808-Ljbffr