Analytics Lead, Full Stack
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 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 BI Lead 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, 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 Python
- Comfort 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 & dashboards
- Workato, Fivetran, or similar integration platforms
- Agile methodologies
- Finance and accounting data and processes
- NetSuite or similar ERP tool
- Custom data application development using Python or similar language
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 Affirm's Global Candidate Privacy Notice and hereby freely and unambiguously give informed consent to the collection, processing, use, and storage of your personal information as described therein.
Apply for this job
*
indicates a required field