Avetta · 13 hours ago
Business Intelligence Engineer
Lehi, UT
Full-time
Hybrid
Mid Level
4+ years expAvetta is a company that connects organizations with qualified suppliers through its SaaS platform. The Business Intelligence Engineer will design, build, and maintain data analytics pipelines, focusing on creating a scalable data foundation and delivering curated data models for analytics use cases.
Enterprise SoftwareLogisticsSupply Chain Management
Responsibilities
Use DBT to design modular data models, enforce data quality, document transformations, collaborate via Git, and deploy DBT pipelines in production
Architect layered DBT models (staging → intermediate → marts) for finance and customer master data
Develop a unified data model by integrating and transforming data from diverse sources
Build and maintain DBT models that serve as business rules frameworks, reducing reliance on external rules engines and streamlining data governance
Design and maintain standardized and conformed models (e.g., Client, Customer, Billing entities) that serve as the foundation for Gold analytics and semantic models
Delivery of certified data products and contributes to the semantic layer implementation in DBT (reusable dimensions, certified metrics, exposures, and macros)
Delivery of self-service analytics capabilities in Snowflake
Create and maintain technical metadata standards (i.e. lineage, technical definitions, etc.)
Implement DBT best practices: modular packages, Jinja logic, quality tests, and documentation standards
Collaborate with BI product owners, data analysts, and governance teams to apply consistent business logic across reporting tiers
Define and implement business-aligned data quality rules and certification standards
Partner with data governance to steward definitions, metrics, and lineage
Qualification
Required
4 years of experience with engineering analytics pipelines, preferably in a SaaS environment
1 year of experience using DBT to design modular models, enforce data quality, document transformations, collaborate via Git, and deploy DBT pipelines in production
Advanced proficiency in SQL (e.g., CTEs, window functions, recursion)
Experience with modern cloud data warehouses (e.g., Snowflake, BigQuery, Redshift, Databricks)
Strong understanding of different data modeling techniques (e.g., star schema, Snowflake schema, data vault)
Bachelor's degree in Data Analytics, Computer Science, Information Technology, Finance, or a related field
Strong understanding of DBT Fundamentals
Exposure to or training in Snowflake data warehousing concepts (e.g., Snowflake Data Warehousing Workshop – Badge 1)
Preferred
Experience with DBT Cloud IDE
Experience with data visualization tools, Power BI preferred
Familiarity with Snowflake and DBT CI/CD automation with GitHub Actions
Aptitude for Agile delivery, backlog management (JIRA), and cross-functional stakeholder leadership
Experience with business systems such as Salesforce, NetSuite, or Zuora
Benefits
Health, dental and vision insurance
401(k)
PTO
Company
Avetta
Avetta is a software company that offers a cloud-based platform for commercial marketplaces and supply chain risk management.
501-1000 employees
H1B Sponsorship
Avetta has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (3)
2022 (3)
2021 (4)
2020 (4)
Funding
Current Stage
Late StageTotal Funding
$35MKey Investors
Welsh Carson Anderson & StoweNorwest
2024-04-02Acquired
2019-02-14Private Equity
2018-03-21Private Equity
Leadership Team
Gretchen Eischen
Chief Market Officer
Recent News
Best ERP Software, Vendors, News and Reviews
2025-12-20
Company data provided by crunchbase