Jathaniel Spengler

"""Founder of data consulting firm, combining enterprise data tooling with a personalized touch. We offer an approachable solution to solve business needs and regulatory requirements."""

• Developed scenario-based forecasting model for solar energy firm via SQL / Python.

• Partnered with FUSE Oregon to study correlation between housing market, shelter availability and rates of homelessness to generate advocacy report.

• Created segmentation tool using SQL and python leveraging cohorting techniques and dashboard visualizations to optimize campaign targeting, reducing CAC by double-digits.

• Ensured GDPR compliance via access policies and automated data validation checks.

• Maintained data catalog with automated dbt Docs and Airbyte metadata sync. Integrated metadata lineage with Looker and Bigquery for complete data transparency and discoverability.

• Implemented ETL pipelines using Dagster, integrating Salesforce, Dynamics, and marketing APIs into a centralized snowflake warehouse for a direct-to-consumer lifestyle brand.

• Designed star and snowflake schemas to support executive and operational dashboards.

• Integrated D365 F&O data (inventory, procurement) into a data lake using Azure Data Factory and DBT incorporating novel data sets and providing on-demand scaling.

• Created data tool for sales/marketing team of food allergy newsletter enabling the sizing and prioritization of customer cohorts. Migrated from ElasticSearch to Snowflake DWH.

"""Firstdata hire at a Y Combinator 2020 startup, developing reporting for sales/product, onboarding and supporting customers, and develop product for a data engineering software."""

• Owned end-to-end product roadmap, facilitating weekly syncs across product, engineering and sales to highlight customer feedback and prioritize most impactful features.

• Developed tailored curriculum and workshop series on SQL and dashboard tools for business teams, boosting product engagement and weekly active users (WAU) by over 20%.

• Mentored junior analysts and implemented skill-building development roadmap that reduced onboarding time by 30% and drove 2 internal promotions.

• Spearheaded GDPR and SOC2 compliance, setting up RBAC, data classification tagging, and encryption-at-rest policies in Snowflake and GCP. Created best practices guide for customers.

• Designed cloud-native Snowflake warehouse and replaced legacy pipelines with scheduled orchestration through custom SQL-based ETL tool, with optional DBT integration.

• Developed 40+ DBT models and tests, interfacing with custom UI tools and incorporating stakeholder-defined business logic into modular transformation blocks.

• Analyzed funnel metrics and user behavior to craft data-driven personas and optimize targeting, leading to a 30% reduction in customer acquisition cost.

• Designed Power BI dashboard with advanced DAX, implementing RLS and dynamic slicers for users to segment across country, team and initiative-level KPIs.

• Drove customer success and helped scale early-stage startup to 100+ enterprise accounts.

"""Founding member of growth analytics team, kicking off an era of unprecedented revenue expansion in an oppressively regulated market.Worked closely with engineering and product teams to develop the company and sector-growing the active user base by 20x. """

• Lead KPI definition and MBR reporting cadence for statewide operations; implemented dashboard suite in Tableau to align 25 dispensary partners to OKRs.

• Recruited and developed cross-functional team of 15 analysts, engineers, and growth associates; guided internal promotion of 3 people to director level.

• Built time-series forecasting model (XGBoost + seasonal adjustments) to optimize inventory for 600+ SKUs; integrated model into order planning and driver staffind workflow.

• Prepared and delivered executive reporting decks quarterly, translating technical KPIs into actionable metrics for C-suite stakeholders.

• Rapidly tested growth ideasvia Eaze Labs– sizing, testing and iterating on innovative customer and driver acquisition strategies on a weekly sprint cadence.

• Created partner performance scorecards to support BD/Legal resulting in $4MM/yr uplift.

• Managed $22MM P&L with quarterly forecasting. Drive over 4 million deliveries.