Job Description
Preference will be given to candidates located in the Houston, TX or Lehi, UT areas who live within a reasonable commuting distance to an Avetta office and are open to a hybrid work schedule (3 days onsite, 2 days remote).
SUMMARY:
Avetta’s SaaS platform connects the world’s leading organizations with qualified suppliers, contractors, and vendors. We bring unmatched visibility to companies through cloud-based technology and human insights to improve supply chair risk and compliance. As a result, we foster sustainable growth for businesses and their supply chains globally. Our SaaS subscription-based software is used by 85k+ active customers in over 100 countries spanning across a wide range of industries.
The Business Intelligence Engineer will design, build, and maintain the bronze, silver, and gold layers of the Finance and Customer data analytics pipelines using DBT and Snowflake. This role will focus on creating a modular and scalable data foundation and delivering curated data models to meet specific analytics use cases. The BI Engineer will need to develop a deep understanding of business rules and use cases and use that understanding to guide the design of self-service datasets and foundational reports.
ESSENTIAL DUTIES AND 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.
IDEAL EXPERIENCE:
- 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).
PREFERRED QUALIFICATIONS:
- 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.
IDEAL EDUCATION & TRAINING :
- 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).
We also offer a comprehensive benefits package, which includes health, dental and vision insurance, 401(k), and PTO.
Avetta is an equal opportunity employer and values diversity. We encourage individuals from all backgrounds and experiences to apply.
To apply for the Business Intelligence Engineer position, please submit your online application by March 31, 2026.
#LI-HYBRID
