Apply on Employer Site

Avetta · 11 hours ago

Business Intelligence Engineer

United States

Full-time

Remote

Mid Level

$93K/yr - $122K/yr

4+ years exp

Avetta is a SaaS platform that connects organizations with qualified suppliers and vendors, providing visibility through cloud-based technology. The Business Intelligence Engineer will design and maintain data analytics pipelines to create scalable data models and enhance self-service analytics capabilities.

Enterprise SoftwareLogisticsSupply Chain Management

Work & Life Balance

H1B Sponsor Likely

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

DBTSnowflakeSQLData modeling techniquesData visualization toolsAgile deliveryTechnical metadata standardsCross-functional leadership

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)