Analytics Lead directing data infrastructure and reporting capabilities at Affirm. Leading the design, modeling, and delivery of trusted people data insights.
Responsibilities
Design and deliver relational and non-relational database models, data pipelines, reporting, and visualization solutions while supporting all phases of the analytics development life cycle (ADLC), including requirements gathering, design, development, testing, and deployment.
Develop, maintain, and scale robust ETL/ELT pipelines across HR data sources (e.g., Workday, Greenhouse Recruiting, internal tools such as Arbor), ensuring reliability, performance, and extensibility.
Architect and implement scalable data models optimized for analytical querying and long-term maintainability.
Ensure data quality, integrity, and reliability across all data assets, introducing automation and best practices for monitoring and validation.
Collaborate with People Analytics stakeholders to translate requirements into sound technical solutions and influence longer-term data architecture decisions.
Manage and optimize cloud data warehouse infrastructure (e.g., Snowflake), including performance tuning, cost management, and secure access patterns.
Leverage AI and LLMs to automate data quality checks, enhance metadata management, and extract insights from unstructured HR data.
Stay current on technology best practices and advocate for engineering excellence across the People Analytics team.
Own and manage data governance, security, privacy, and retention standards across all People Analytics systems.
Requirements
5+ years and expertise with dbt (Data Build Tool), SQL and Python required;
Experience writing clean, computationally efficient code involving ETL processes and data manipulation via dbt, SQL, and Python.
Demonstrated ability to design and build efficient, analytics-ready data models in dbt, transforming raw or unstructured data into well-defined marts.
Comfort with production level IDEs (e.g., Cursor, Visual Studio) and Version Control (e.g., git, specifically GitHub).
Experience using standard Python analysis packages (e.g., Pandas, NumPy).
Experience with Snowflake or other cloud data warehouse.
Experience with Sigma or other modern BI platform.
Experience with Fivetran or similar integration platform for integrating structured, unstructured, or unclear data formats.
Experience with Airflow or other orchestration platform.
Experience with leveraging LLMs for data transformation or analysis; MLOps preferred.
Experience with Data lakes and/or Iceberg table format preferred.
Experience with Custom data application development using Python or similar language (i.e. Streamlit dashboards, Slackbots) preferred.
Strong sense of ownership, intellectual curiosity, and the ability to think creatively and critically in a dynamic, fast-paced, and ambiguous environment.
Demonstrated ability to provide technical leadership, influence cross-functional partners, and mentor other team members.
Excellent communication skills and comfort translating technical topics for non-technical audiences.
Benefits
Health care coverage - Affirm covers all premiums for all levels of coverage for you and your dependents
Flexible Spending Wallets - generous stipends for spending on Technology, Food, various Lifestyle needs, and family forming expenses
Time off - competitive vacation and holiday schedules allowing you to take time off to rest and recharge
ESPP - An employee stock purchase plan enabling you to buy shares of Affirm at a discount
Data Scientist developing machine - learning models for The Athletic’s sports media platform. Optimizing subscriptions, workflows, experiments, and personalized article recommendations.
Data Scientist at Desjardins, a financial services cooperative, developing advanced analytics, machine learning and AI models. Advising stakeholders and supporting data - driven business decisions.
Data Scientist building IFRS 9, behavioural, and predictive credit - risk models for Financeit’s Canadian point - of - sale financing platform. Automating analytics and translating borrower data into actionable risk insights.
Scientifique de données principal optimisant acquisition, fidélisation et monétisation chez Shakepay, plateforme canadienne de services financiers Bitcoin. Pilotage de l'expérimentation, de l'analyse statistique et des décisions de croissance.
Senior Data Scientist developing machine learning and LLM solutions for Qventus, transforming healthcare operations. Building production models, experiments, and data pipelines that improve patient outcomes.
Data Scientist developing statistical and machine learning algorithms to detect bots and fraud. Supporting HUMAN Security’s platform that protects enterprises and internet platforms from cybercrime.
Data Manager leading clinical - trial database, validation, reconciliation, and lock activities for ClinChoice, a global full - service CRO. Hybrid permanent role in Mississauga, Ontario.
Data Scientist developing and maintaining credit risk models for Desjardins, a financial cooperative. Advising teams on risk quantification, Basel/IFRS standards, and credit decisions.
Senior Data Scientist optimizing bidding, pacing, targeting, and budgets for Instacart’s grocery delivery and advertising marketplace. Driving experimentation and production algorithms that improve advertiser outcomes and platform revenue.