Analytics Engineer, People Data

Affirm; Prince Edward Island; Remote; CAD 109,000 - 159,000; Full time

Job summary

A fintech company is seeking an Analytics Engineer, People Data, to enhance data integration and reporting capabilities. This position requires expertise in SQL and Python, focusing on developing ETL pipelines and ensuring data quality. The ideal candidate will have a strong analytical background and the ability to collaborate with cross-functional teams to deliver impactful data products.

Benefits

Health care coverage

Flexible Spending Wallets

Competitive vacation and holiday schedules

Qualifications

• 3+ years of experience working with dbt, SQL, and Python.
• Experience building efficient data models and ETL pipelines.
• Strong technical skills combined with interpersonal skills.

Responsibilities

• Design and deliver database models and reporting solutions.
• Develop and maintain robust ETL pipelines for HR data.
• Ensure data quality and reliability across all data assets.

Skills

dbt (Data Build Tool)

SQL

Python

Data governance

Data pipeline development

Tools

Snowflake

Airflow

Fivetran

Job description

Affirm Queens, Prince Edward Island, Canada

Join or sign in to find your next job

Join to apply for the Analytics Engineer, People Data role at Affirm

Affirm Queens, Prince Edward Island, Canada

2 days ago Be among the first 25 applicants

Join to apply for the Analytics Engineer, People Data role at Affirm

Get AI-powered advice on this job and more exclusive features.

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 Analytics Engineer to join the People Analytics organization and significantly expand our data integration, transformation, and reporting capabilities. People Analytics is responsible for the infrastructure, business logic, and deliverables for data across the People space; including talent acquisition, total rewards, feedback & development, and employee data. This position will be instrumental in architecting and building robust data infrastructure and tools, significantly enhancing our team’s ability to deliver high-value data products across the business.

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. You'll have the opportunity to make a significant impact by building robust data infrastructure and tools that empower our People Analytics organization and cross-functional partners across the business. Join our team and be part of Affirm's mission to reinvent credit!

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
• Develop and maintain robust ETL/ELT pipelines for various HR data sources (e.g., Workday, Greenhouse Recruiting)
• Architect and implement scalable data models optimized for performance and analytical querying
• Ensure data quality, integrity, and reliability across all data assets
• Collaborate with People Analytics team members to understand data requirements and translate them into technical solutions
• Manage and optimize cloud data warehouse infrastructure (e.g., Snowflake)
• Leverage AI and LLMs to, for example, automate data quality checks, enhance metadata management, and extract deeper insights from unstructured HR data
• Be on the lookout for technology best practices and advocate for them
• Be an advocate for data governance, security, privacy, quality and retention
  
  

What We Look For

• 3+ years and expertise with dbt (Data Build Tool), SQL and Python required; including:
• Experience writing clean, computationally efficient code involving ETL processes and data manipulation via dbt, SQL, and Python
• Building efficient and concise data models in dbt to transform unstructured source data into analytics-ready denormalized 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 the following required:
• Snowflake or other cloud data warehouse
• Sigma or other modern BI platform
• Fivetran or similar integration platform for integrating structured, unstructured, or unclear data formats
• Airflow or other orchestration platform
• Experience with the following preferred:
• Leveraging LLMs for data transformation or analysis; MLOps
• Data lakes and/or Iceberg table format
• Custom data application development using Python or similar language (i.e. Streamlit dashboards, Slackbots)
• 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
  

Base Pay Grade - K

Equity Grade - 4

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).

CAN base pay range per year: $109,000 - $159,000

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.

Benefits

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Affirm by 2x

Sign in to set job alerts for “Data Engineer” roles.

Charlottetown, Prince Edward Island, Canada 3 months ago

Charlottetown, Prince Edward Island, Canada 4 months ago

Software Engineer I (Consumer Servicing)

Queens, Prince Edward Island, Canada 2 days ago

Senior Software Engineer, Backend (CI/CD)

Queens, Prince Edward Island, Canada 3 days ago

Software Engineer II, Backend (Consumer Authentication)

Queens, Prince Edward Island, Canada 6 days ago

Software Engineer II, Backend (Identity Foundation)

Queens, Prince Edward Island, Canada 1 day ago

Senior Software Engineer (Identity Decisioning)

Queens, Prince Edward Island, Canada 2 weeks ago

Senior Software Engineer (Online Storage)

Queens, Prince Edward Island, Canada 3 days ago

Senior Software Engineer (Capacity and Cloud Economics Engineering)

Queens, Prince Edward Island, Canada 6 days ago

Queens, Prince Edward Island, Canada 2 weeks ago

Queens, Prince Edward Island, Canada 2 weeks ago

Principal Software Engineer, Infrastructure Platform Engineering

Queens, Prince Edward Island, Canada 2 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.