Senior Risk Analytics Engineer

Summary

Join Pipe, a remote-first company building cutting-edge embedded financial solutions, as a Senior Analytics Engineer on our Risk team. This role centers on data modeling using SQLMesh to support risk business analysts in analyzing and reporting on credit risk and underwriting. You will design and develop data models, create reports and dashboards, evaluate key metrics, and perform ad-hoc analysis using SQL or Python. Collaboration with Data Science and Data Engineering teams is crucial to ensure a self-service data infrastructure. Pipe offers a supportive environment with mentorship and guidance, along with competitive compensation and benefits.

Requirements

• 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

Responsibilities

• Collect and integrate data from various sources such as credit bureaus, banks, payment systems, and internal financial systems
• Design and develop efficient data pipelines that move and process credit-related data from various sources into BigQuery
• Work closely with credit analysts and data scientists to provide the necessary data for evaluating credit risk, creating credit scores, and assessing financial trends
• Automate data processing tasks and improve the efficiency of data pipelines, reducing manual effort and time required for data preparation
• Collaborate with data engineering and software engineering teams to understand and implement best practices for data modeling

Preferred Qualifications

• Familiarity with concepts such as decision models, features, portfolio performance
• Experience in an agile team and collaborating asynchronously
• Curious and eager to learn

Benefits

• 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
• Lifetime maximum benefit for family forming and fertility
• Annual US base salary range for this role is $113,000 - $155,000