Hybrid Analytics Engineer, Finance

at Avetta

• Job title: Analytics Engineer, Finance
• Job type: Full Time
• Experience level: Junior, Mid level
• Salary: $74,000 - $143,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: Cloud, SQL
• Location requirements: Hybrid, United States

About the role

• Analytics Engineer collaborating across Finance and Operations teams to optimize revenue analytics for Avetta’s SaaS platform. Driving insights to enhance operational efficiency and reporting accuracy.

Responsibilities

• Raise the Company’s FP&A Cash Billings analytics & reporting function by optimizing:
• Trace and join invoicing and customer-activity events end-to-end using clear, testable logic.
• Design and build out an analytically-derived “Connection Subscription Ledger”: a detailed, time-aware log of monetized (billable) client–supplier connections, morphing into a handoff-ready dataset that Corporate BI productionizes in Snowflake.
• Build analytics-ready warehouse models (SQL + modeling):
• Write high-performance SQL to create curated tables/views that support:
• Cohort creation and retention (by activation/event timing).
• Expansion/contraction and product mix shifts.
• Renewal behavior and customer lifecycle segmentation.
• Price lift measurement and attribution.
• Churn classification and event-driven “bridge” logic.
• Establish foundational tables with carefully chosen and clearly defined data grain, durable surrogate/primary keys, and consistent dimensional attributes.
• Bring data modeling rigor into Finance reporting:
• Translate finance requirements into data logic: partner with the Business Analyst to define rules, acceptance criteria, and edge-case handling.
• Run tight iteration loops: prototype → validation protocols → refine → document → finalize.
• Provide “definition control” so recurring reporting stays consistent month-over-month.
• Foster a wholistic understanding of the business (including underlying drivers and relationship/impact) within and across the entire FP&A team, leading to improved processes, collaboration, insight generation and optimal business outcomes.
• Develop and monitor business performance indicators, highlighting trends, opportunities for improvement, causes of unexpected variance, and partner with finance and business partners to optimize downstream actions.

Requirements

• Bachelor’s Degree in relevant field; additional education/certification is a plus.
• 2–5 years of experience in data engineering / analytics engineering / advanced analytics roles in Snowflake or other modern cloud data warehouse.
• Strong SQL (complex joins, window functions, incremental logic, recursive query development, performance tuning), with proven ability to model data for analytics (facts/dimensions, grain, keys, cohort logic).
• 1 year of experience supporting dbt-style modular SQL, testing, and documentation.
• Proficiency in AI-based tech stack solutions, agent design or company-specific LLM tooling.

Benefits

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