Senior Data Engineer

Summary

Join Avetta as a Senior Data Engineer and lead the design and delivery of certified data products for enterprise analytics. You will own the architecture of scalable data models in Snowflake, lead data transformation in dbt, and serve as the product owner for the Finance Data Roadmap. This role involves designing and maintaining data models, defining best practices, delivering performant data products, and partnering with stakeholders to align on metrics and requirements. You will also prototype new ideas, experiment with emerging technologies, and ensure data models are well-documented and supported. The position requires managing CI/CD processes, leading reviews of dbt projects, and monitoring production data assets. A hybrid work schedule is expected if you reside within 30 miles of an Avetta office.

Requirements

• 8+ years of experience in data engineering, analytics architecture, or BI product development
• Deep expertise in dbt, Snowflake, and SQL, with a track record of delivering scalable dimensional data models
• Experience leading end-to-end delivery of certified data products for consumption in Power BI or similar tools
• Strong product ownership skills with experience managing analytics roadmaps, prioritizing requirements, and working directly with business partners
• Strong communicator with the ability to collaborate cross-functionally, align stakeholders, and present complex concepts in business terms
• Familiarity with financial KPIs, subscription revenue models, and forecasting or retention analytics
• Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field

Responsibilities

• Design and maintain scalable data models using dbt and Snowflake, aligned to enterprise standards (staging → intermediate → facts/dims)
• Define and enforce best practices for semantic modeling, naming conventions, testing, and reusability of certified data assets
• Deliver performant and trusted certified data products used across enterprise BI tools like Power BI
• Serve as Product Owner for the Finance analytics roadmap—owning the backlog and prioritizing data development that enables key use cases (forecasting, margin trends, ARR/churn analytics)
• Partner with Finance, Revenue Operations, and business stakeholders to align on metrics, iterate on requirements, and ensure consistent metric definitions across use cases
• Collaborate with internal customers to prototype new ideas and data products, turning conceptual use cases into technical proofs-of-concept
• Experiment with emerging technologies (e.g., AI-powered insights, automated data classification, predictive BI features) to expand the impact of the data platform
• Identify opportunities to integrate modern capabilities into certified data workflows and communicate value back to business and technical stakeholders
• Partner with the Data Governance Lead to ensure all certified data models are documented with business definitions, transformation logic, and usage guidelines
• Contribute to the development of a centralized data catalog, and lead communications around model releases, data updates, and enablement resources
• Promote self-service analytics by ensuring that certified data products are discoverable, well-documented, and supported by shared standards
• Implement and manage CI/CD processes for dbt code and model deployments (including versioning, test coverage, and rollback plans)
• Lead reviews of internal and third-party dbt projects, ensuring adherence to modeling, performance, and data governance standards
• Continuously monitor production data assets for reliability, accuracy, and usage trends; implement refinements based on feedback and results
• Influence and guide a community of analysts, engineers, and BI developers in adopting best practices for data modeling and analytics engineering
• Lead architectural design reviews and model workshops, and provide technical mentoring on dbt, Snowflake, and semantic modeling principles
• Coordinate and align 3rd-party implementation teams to the organization's standards and priorities

Preferred Qualifications

• Experience with AI/ML in the context of analytics (e.g., predictive modeling, LLMs for insights, anomaly detection)
• Prior experience working in or supporting Finance, RevOps, or SaaS metrics domains
• Experience with GitHub, dbt Cloud, Power BI Service, and orchestration tools (Airflow, Prefect, or equivalent)
• Certifications: dbt Certified Developer, Snowflake
• Relevant certifications and continuous learning in data engineering, analytics, and related fields

Benefits

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