If residing within commutable distance to one of our offices, a hybrid schedule would be required (3 days in office, 2 days work from home). Those outside of commutable distance may be considered on a remote basis.
SUMMARY
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.
ESSENTIAL DUTIES AND 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.
PREFERRED QUALIFICATIONS, IDEAL EDUCATION AND TRAINING:
- 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.
METRICS THAT MATTER:
- 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.
At Avetta, we are committed to salary transparency to ensure equitable hiring practices and promote trust. The salary range included in this job posting is based on internal and market data and the role's responsibilities. The final compensation offered to a candidate will be determined by several factors, including work location, job-related skills, experience, and relevant education or training.
The salary range for this position is $74,000 - $143,000 USD per year, with a potential bonus.
We also offer a comprehensive benefits package, which includes health, dental and vision insurance, 401(k), and PTO.
Avetta is an equal opportunity employer and values diversity. We encourage individuals from all backgrounds and experiences to apply.
To apply for the Analytics Engineer position, please submit your online application by May 31, 2026.
#LI-REMOTE