Avetta is a SaaS platform that connects organizations with qualified suppliers, enhancing visibility and compliance through technology. The Analytics Engineer (Finance) will play a crucial role in the Financial Planning & Analysis team, collaborating across various departments to optimize revenue analytics and improve forecasting 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