Analytics Lead

Affirm is reinventing credit to make it more honest and friendly, giving consumers the flexibility to buy now and pay later without any hidden fees or compounding interest.

We are in search of an action-oriented and analytically inclined data professional to join the Strategic Finance organization. Strategic Finance is responsible for driving company strategy, empowering executive decision-making, and guiding the company toward achieving its goals. This impactful position is part of the Corporate FP&A / Reporting sub-team. We consolidate the P&L, deliver management reporting to executives, and are responsible for transforming our planning & forecasting processes with new tools, automations and capabilities.

This role is primarily suited for candidates with strong BI skills, particularly with experience in the design and creation of ETLs and SQL-based relational database structures. The ideal candidate will not only have superb technical skills but also strong interpersonal skills and the ability to take a leading role in driving our data and reporting capabilities to the next level.

What You'll Do

• Design and deliver relational and non-relational database models, data pipelines, reporting and visualization solutions by supporting all phases of the analytics development life cycle (ADLC), including requirements gathering, design, development, testing and deployment
• Recognize and adopt best practices in data warehousing, reporting, and analysis: data integrity, test design, analysis, validation, and documentation
• Own and document data pipelines and data lineage
• Identify and troubleshoot data-related and reporting production issues
• Identify and drive reporting automation, improvement opportunities and new capabilities / tools
• Be on the lookout for technology best practices and advocate for them
• Help finance analysts build highly complex queries; be a data access optimization guru
• Be an advocate for data governance, security, privacy, quality and retention

What We Look For

• Strong sense of ownership, intellectual curiosity and an ability to think creatively and critically and thrive in a fast-paced, dynamic, and often ambiguous work environment
• 5+ years of experience with database design, architecture and modeling techniques in cloud data warehouses (i.e. Snowflake) and data engineering using ETL tools (i.e. DataBricks)
• Expert-level working knowledge of SQL and Python required; including:
  • Experience writing clean, computationally efficient code involving ETL processes and data manipulation via SQL and Python
  • Experience using standard Python analysis packages (e.g., SciPy, NumPy, Pandas)
  • Comfort with production level IDEs (e.g., PyCharm, Visual Studio), interactive IDEs (e.g., Databricks, Jupyter), and Version Control (e.g., git, specifically GitHub)
• Experience with the following preferred:
  • dbt or similar data transformation tools
  • Looker or similar BI tools
  • Agile methodologies
  • Finance and accounting data and processes
  • Anaplan or similar EPM tool
  • Excel modeling experience

Compensation & Benefits

Base Pay Grade - M

Equity Grade - Poland 3

Employees new to Affirm typically come in at the start of the pay range. Affirm focuses on providing a simple and transparent pay structure which is based on a variety of factors, including location, experience and job-related skills.

Base pay is part of a total compensation package that may include monthly stipends for health, wellness and tech spending, and benefits (including 100% subsidized medical coverage, dental and vision for you and your dependents). In addition, the employees may be eligible for equity rewards offered by Affirm Holdings, Inc. (parent company).

POL base pay range per year: 285,000 zł - 385,000 zł

Additional benefits include:

• Type of employment: Contract of Employment
• Flexible Spending Wallets for tech, food and lifestyle
• Away Days - wellness days to take off work and recharge
• Learning & Development programs
• Parental leave
• Employee Resource & Community Groups

Location - Remote Poland

The majority of our roles can be located anywhere in Poland.

**This job description is not a contractual document, and is not intended to have binding force.**

#LI-Remote

Affirm is proud to be a remote-first company! The majority of our roles are remote and you can work almost anywhere within the country of employment. Affirmers in proximal roles have the flexibility to work remotely, but will occasionally be required to work out of their assigned Affirm office. A limited number of roles remain office-based due to the nature of their job responsibilities.

We’re extremely proud to offer competitive benefits that are anchored to our core value of people come first. Some key highlights of our benefits package include:

• 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

We believe It’s On Us to provide an inclusive interview experience for all, including people with disabilities. We are happy to provide reasonable accommodations to candidates in need of individualized support during the hiring process.

[For U.S. positions that could be performed in Los Angeles or San Francisco] Pursuant to the San Francisco Fair Chance Ordinance and Los Angeles Fair Chance Initiative for Hiring Ordinance, Affirm will consider for employment qualified applicants with arrest and conviction records.

By clicking "Submit Application," you acknowledge that you have read the Affirm Employment Privacy Policy for applicants within the United States, the EU Employee Notice Regarding Use of Personal Data (Poland) for applicants applying from Poland, the EU Employee Notice Regarding Use of Personal Data (Spain) for applicants applying from Spain, or the Affirm U.K. Limited Employee Notice Regarding Use of Personal Data for applicants applying from the United Kingdom, and hereby freely and unambiguously give informed consent to the collection, processing, use, and storage of your personal information as described therein.