Hybrid Data Engineer

at Avetta

• Job title: Data Engineer
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: AWS, Cloud, Terraform
• Location requirements: Hybrid, Houston, United States

About the role

• Data Engineer managing DBT and Fivetran platforms for analytics at Avetta. Ensuring reliable data pipelines and leading technical standards in data engineering team.

Responsibilities

• Own the DBT and Fivetran platforms, including configuration, environment setup, access controls, and ongoing maintenance.
• Manage DBT Cloud environments, including job configuration, scheduling, orchestration, and dependency management.
• Configure and manage Fivetran connectors, sync schedules, schemas, transformations, and performance tuning.
• Build, operate, and optimize end-to-end ELT pipelines from source systems through Snowflake using Fivetran and DBT.
• Design and maintain robust orchestration patterns for DBT runs, incremental models, and downstream dependencies.
• Ensure pipelines are reliable, scalable, and cost-efficient.
• Own and manage data platform infrastructure using Terraform to create Snowflake resources.
• Implement, maintain and own CI/CD pipelines using GitHub Actions for DBT deployments, testing, and environment promotion.
• Implement and maintain data quality solutions (e.g., freshness checks, anomaly detection).
• Build and manage monitoring and observability solutions for pipelines, jobs, and data SLAs.
• Define and track platform and data reliability metrics, alerting on failures, delays, or data issues.
• Own Snowflake administration, including warehouses, roles, permissions, resource monitoring, and cost optimization.
• Tune performance for DBT models and queries through clustering, warehouse sizing, and query optimization.
• Ensure security, governance, and best practices across Snowflake environments.

Requirements

• 6 years of experience in data engineering or analytics engineering, with demonstrated senior-level ownership is preferred.
• Bachelor's or Master’s Degree in Data Engineering, Computer Science, or related field is preferred.
• Certifications in DBT (Advanced), Snowflake (SnowPro), GitHub Actions Certification, AWS Certified Solutions Architect – Professional is preferred.
• Comfortable in supporting analytics-ready DBT models, including staging, intermediate, and mart layers.
• Experience implementing data observability or data quality frameworks.
• Familiarity with modern metrics layers or semantic models.
• Experience supporting analytics and BI.
• Strong documentation and stakeholder communication skills.
• Aptitude for Agile delivery (e.g., JIRA) and backlog management in cross-functional data teams.

Benefits

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