Smarty
Data Engineer
Orem, UT
Sponsorship not specified$90k-$120kDetected 8 hours ago
PythonCode ReviewGitSQLMySQLAWSdbtData EngineeringData VisualizationHubSpotSalesforceGoogle AnalyticsProblem SolvingBitbucket
> stay_score
odds of building a lasting career here
26Unrated
Cap-exempt (no lottery)0
Sponsors this role0
Entry-level history0
PERM / green-card track0
Lottery odds (Level II)66
Fits your clock70
No strong sponsorship signal in the public record yet. In the full product we resolve the exact legal entity and show its filing history with a confidence score — treat as unverified until then.
Lottery odds assume a STEM candidate.
Personalize to your clock →> community_outcomes
No reports yet — be the first to help the next applicant.
About the role
- 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.
- Apply and find out for yourself. - For more information about the company, please visit us at www.smarty.com.
Responsibilities
- 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
- 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
- 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
Requirements
- 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:
- Experience managing an Airbyte (or similar ELT tool such as Fivetran) deployment and its source connections
- Familiarity with MySQL or similar relational databases as data sources
- Experience with version control (Git/Bitbucket or similar) and code review workflows
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
- AWS certifications (e.g., AWS Certified Data Engineer, Solutions Architect)
- Competitive compensation (DOE)
- Range for this role is $90k - $120k
- 401(k) with company matching
Compensation
- $90k-$120k
Benefits
- Monitor pipeline health via AWS CloudWatch, respond to failures, and maintain data quality through dbt testing
Company info
- 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.
This listing is sourced directly from Smarty's careers page and normalized into a canonical job model.