Analytics Engineer (Finance)

Avetta, LLC

2d•$74,000 - $143,000•Hybrid

About The Position

Avetta’s SaaS platform connects the world’s leading organizations with qualified suppliers, contractors, and vendors. We bring unmatched visibility to companies through cloud-based technology and human insights to improve supply chair risk and compliance. As a result, we foster sustainable growth for businesses and their supply chains globally. Our SaaS subscription-based software is used by 85k+ active customers in over 100 countries spanning across a wide range of industries. The Analytics Engineer (Finance) within Avetta’s Financial Planning & Analysis (FP&A) team will serve as a critical partner in driving insights that influence executive decisions and operational efficiency. This role will collaborate across Finance, Billing, Sales Operations, Business Intelligence, and Leadership teams to gather valuable insights and data, and optimize complex revenue analytics and planning processes to improve the accuracy and quality of the revenue forecast and reporting.

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.
Understanding of business, the why (not just the what), and numbers.
Accuracy of analysis and inputs that slide into strategic decisions
Turnaround time, flexibility to adjust to changing environment / business needs, and leveraging of systems.
Consistent delivery with an ownership mentality.
Customer delight with supporting active engagement with cross-functional leaders.

Nice To Haves

Proficiency in AI-based tech stack solutions, agent design or company-specific LLM tooling.

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.