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. Affirm, Inc. proudly includes Affirm, PayBright, and Returnly.
As a Senior Analytics Engineer, you will design and implement data models that will be the core foundation for our analytics data warehouse. You will build and maintain scalable data processing pipelines using tools and technologies such as SQL, Python, data build tool, Prefect etc. This is a cross-functional role in which you will work closely with engineers, analysts and data scientists to collect, transform, store and serve data across the company.
What you'll do
- Create and own the data models in our analytics environment comprised of Snowflake, Looker and data build tool (dbt).
- Manage our ELT pipelines that feed reporting & analytics systems used by analysts, data scientists and product managers.
- Apply software engineering best practices to our data environment, e.g. testing and version control.
- Work with architects and technology leads to ensure a reliable, scalable, and robust architecture for our data environment.
- Collaborate with product development teams to ensure application design that accommodates reporting and analytics requirements.
- Support product analysts and data scientists with automation, tooling, data pipelines and engineering expertise.
What we look for
- 4+ years of relevant software engineering experience, with a focus on data.
- Experience with cloud data warehouse solutions such as Snowflake or Redshift.
- Strong software development experience, preferably in Python.
- Fluent in SQL and experience with relational and dimensional data modeling.
- Familiar with best practices around data quality, documentation and governance.
- Experience with distributed computing frameworks, like Spark or Hive.
- Proficiency with Kimball design principles, familiarity with Data Mesh a big plus.
- Experience building and optimizing data processing pipelines, architectures and data sets.
- Experience with orchestration services like AirFlow, Prefect or Luigi.
- Strong familiarity with *nix environment including bash, command-line tools and Docker.
- Prior experience with CI/CD pipelines and tools (Buildkite, CircleCI, Jenkins) a big plus.
- Experience with systems monitoring and alerting tools (Prometheus, Grafana) a big plus.
- Excellent planning and time management skills, being able to provide deliverables on time; ability to anticipate and resolve project roadblocks.
- Strong communication skills, confidently representing your expertise to peers and stakeholders across the organization.
- Self-motivated, working independently, intrinsic learner.
- Command of the English language, both written and spoken.
- Degree in Computer Science, Engineering, or a related technical field.
Location - Remote Spain
Affirm is proud to be a remote-first company! The majority of our roles are remote and can be located anywhere in the U.S. and Canada (with the exception of the U.S. Territories, Quebec, Yukon, Nunavut, and the Northwest Territories) unless the job indicates a different global location. We are currently building operations in Spain, Poland, and Australia. Employees in remote roles have the option of working remotely or from an Affirm office in their country of hire, and may occasionally travel to an Affirm office or elsewhere for required meetings or team-building events. Our offices in Chicago, New York, Pittsburgh, Salt Lake City, San Francisco and Toronto will remain operational and accessible for anyone to use on a voluntary basis, subject to local COVID-19 guidelines.
All full-time jobs at Affirm (excluding interns and apprentices) are tied to a transparent grade-based pay range taking location into account.
At Affirm, People Come First is one of our core values, and that’s why diversity and inclusion are vital to our priorities as an equal opportunity employer. You can read about our D&I program here and our progress thus far in our 2021 DEI Report.
We also 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.