Analytics Engineer, Forecasting & Revenue Intelligence

What you'll do

• Build and maintain dbt models on Snowflake to integrate Salesforce, subscription, billing, and hierarchy data.
• Model data with clear grains, stable keys, and definitions consistent with the shared metric dictionary.
• Maintain historical data to ensure any published number can be reproduced as it stood on a specific date.
• Manage the mapping between accounts, territories, sellers, and the sales hierarchy during organizational changes.
• Reconcile data against Salesforce and Finance records to identify and resolve discrepancies.
• Build datasets for weekly forecast packs, business reviews, and leadership dashboards.
• Implement tests and monitoring for data freshness, completeness, and accuracy.
• Explain data issues and trade-offs to non-technical partners and agree on technical fixes.

What we're looking for

• Bachelor’s degree in a technical or quantitative field, or equivalent practical experience.
• 3+ years in analytics engineering, data engineering, or BI development building models for others.
• Experience using dbt in production with tests and documentation.
• Strong SQL skills, including window functions and incremental models, in a cloud data warehouse like Snowflake.
• Working knowledge of the Salesforce data model, including accounts, opportunities, line items, and ownership.
• Ability to explain data problems to non-technical stakeholders and reach decisions together.
• Experience with dbt snapshots or slowly changing dimensions for point-in-time reporting (preferred).
• Python for transformation or orchestration with Airflow or similar (preferred).