Analytics Lead, Full Stack (Accounting)

Tech Stack

ETL
SQL
IDE
SNOWFLAKE
PYTHON

Job Description

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 Financial Systems organization.

Financial Systems is responsible for the data and reporting for the Accounting team, as well as our third party accounting applications.

We are embarking on an initiative to establish a single-source-of-truth of financial information, leveraging dbt & Snowflake, in order to facilitate BI & process automation throughout the org.This role is primarily suited for candidates with strong data 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 DoDesign 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 deploymentRecognize and adopt best practices in data warehousing, reporting, and analysis: data integrity, test design, analysis, validation, and documentationOwn and document data pipelines and data lineageIdentify and troubleshoot data-related and reporting production issuesIdentify and drive reporting automation, improvement opportunities and new capabilities / toolsBe on the lookout for technology best practices and advocate for themHelp BI Lead build highly complex queries; be a data access optimization guruBe an advocate for data governance, security, privacy, quality and retentionWhat We Look ForStrong sense of ownership, intellectual curiosity and an ability to think creatively and critically and thrive in a fast-paced, dynamic, and often ambiguous work environment5+ 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, Fivetran)Expert-level working knowledge of dbt, SQL and Python required; including:Experience writing clean, computationally efficient code involving ETL processes and data manipulation via dbt, SQL, and PythonComfort with production level IDEs (e.g., Visual Studio), interactive IDEs (e.g., Databricks), and Version Control (e.g., git, specifically GitHub)Experience using standard Python analysis packages (e.g., SciPy, NumPy, Pandas)Experience with the following preferred:Snowflake databases & dashboardsWorkato, Fivetran, or similar integration platformsAgile methodologiesFinance and accounting data and processesNetSuite or similar ERP toolCustom data application development using Python or similar languageCompensation & BenefitsBase Pay Grade - MEquity Grade - Poland 3Employees 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 EmploymentFlexible Spending Wallets for tech, food and lifestyleAway Days - wellness days to take off work and rechargeLearning & Development programsParental leaveEmployee Resource & Community GroupsLocation - Remote PolandThe 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.