Pipe is building cutting edge embedded financial solutions to help small businesses and software companies build something bigger. We’re a remote-first team of problem solvers who build and ship at high velocity. We’re customer obsessed and leave our egos at the door. If this sounds fun, join us!
Role
We are hiring a Senior Analytics Engineer to join our Risk team. This role will focus heavily on data modeling to support our risk business analysts, who are responsible for using dashboards to regularly analyze and report on credit risk and underwriting to the business. You will design and develop data models using SQLMesh to support risk business analysts, create reports, construct dashboards, evaluate key metrics, and perform ad hoc analysis using SQL or Python. You will collaborate closely with the Data Science and Data Engineering teams to ensure our data infrastructure is as self-service as possible.
Currently our data stack is mostly comprised of:
- Data Analytics: Preset, Hex
- Data Warehouse: Google BigQuery
- Data Modeling: SQLMesh
- MLOps: Chalk, Metaflow
We do not expect you to have experience with all of these tools. Experience with similar tools like Tableau, Amazon Redshift, or dbt are good indicators that you’d be comfortable with our stack.
Pipe is a remote company with hubs in SF, Atlanta, and New York. We have large scale challenges to tackle in multiple areas, and we invest heavily in the developer experience. We believe great engineers are capable of learning new things, and you will receive mentorship and guidance as needed.
Responsibilities
- Collecting and integrating data from various sources such as credit bureaus, banks, payment systems, and internal financial systems.
- Designing and developing efficient data pipelines that move and process credit-related data from various sources into BigQuery.
- Working closely with credit analysts and data scientists to provide the necessary data for evaluating credit risk, creating credit scores, and assessing financial trends.
- Automating data processing tasks and improving the efficiency of data pipelines, reducing manual effort and time required for data preparation.
- Collaborating with data engineering and software engineering teams to understand and implement best practices for data modeling.
Qualifications
We are looking for data analysts with this kind of background:
- 3-5+ years of experience writing well-structured, performant SQL and advanced Python
- 3+ years of experience in database schema design and data modeling
- 3+ years of experience building data models and data pipelines on top of large datasets
- Track record of following data modeling standards and best practices
- Proficiency in common engineering tools such as Git, Jira, Unix-based operating systems, etc.
- Experience with common data visualization tools such as Tableau, Superset, or Looker
- Passionate about extracting and communicating insights to support the business
- Prefer familiarity with concepts such as decision models, features, portfolio performance
- Experience in an agile team and collaborating asynchronously
- Curious and eager to learn
Compensation and Benefits
We believe in taking care of our employees. We want you to feel like an owner and that will be reflected in your salary, equity, and benefits. You’ll receive:
- The best equipment to help you do your job: computers, monitors, desks, chairs, headphones, speakers, webcams, keyboards, mice, etc.
- Flexible vacation and work hours. We believe in a healthy work-life balance (really!)
- Excellent health, dental, and vision insurance.
- Generous parental leave for anyone who is growing their family, regardless of gender.
- Great colleagues! We value a culture of authenticity, humility, and excellence. We want you to make a mark on our culture.
Pipe is an equal opportunity employer: we do not discriminate. Diversity and inclusion are important to us, and we hope they are to you, too.
The annual US base salary range for this role is $113,000 - $155,000. This salary range may be inclusive of several career levels at Pipe and will be narrowed during the interview process based on a number of factors, including the candidate’s experience, qualifications, and location.
Top Skills
Similar Jobs
What you need to know about the Charlotte Tech Scene
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus