Hybrid Business Intelligence Engineer

at Avetta

• Job title: Business Intelligence Engineer
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $93,000 - $122,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: Amazon Redshift, BigQuery, Cloud, SQL, Vault
• Location requirements: Hybrid, Dallas, United States

About the role

• Business Intelligence Engineer at Avetta; designing, building, and maintaining finance and customer data analytics pipelines using DBT and Snowflake.

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.

Requirements

• 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).

Benefits

• health, dental, and vision insurance
• 401(k)
• PTO