Risk Reporting Analyst

Introduction

This role is specifically designed to migrate legacy, Excel-heavy residual value models and portfolio trackers into modern, automated data pipelines and business intelligence tools. The ideal candidate will combine asset risk knowledge with strong data engineering skills to eliminate manual spreadsheets, accelerate reporting speeds, and improve portfolio risk insights.

Required Skills & Qualifications

• Education: Bachelor’s degree in Data Analytics, Computer Science, Finance, Statistics, or a quantitative field.
• Experience: 3 years of experience in financial risk analysis, asset management, or data analytics, with a proven track record of migrating systems away from Excel.
• Technical Mastery: Advanced SQL, SAS and Python (Pandas, NumPy)
• BI Tools: Expert-level Tableau.
• Domain Knowledge: Understanding of automotive leasing structures, residual value risk, used car market dynamics, vehicle remarketing channels (customer, auctions, dealer), and vehicle segmentation.
• Prior work experience at client or in client's Industry
• Applicants must be able to work directly for Artech on W2

Preferred Skills & Qualifications

• Advanced Client Excel to understand and dismantle existing models.
• Excellent communication skills to guide non-technical teams through technological transitions.

Day-to-Day Responsibilities

• Evaluate Existing Risk Reporting: Conduct a thorough evaluation of existing processes by developing clear process maps with inputs/ dependencies, outputs, constraints etc.
• Automated Data Pipelines: Partner with IT to design, build, and maintain robust ETL (Extract, Transform, Load) pipelines to ingest data/ metrics directly into a centralized data warehouse. Centralize internal lease data with external third-party market valuation APIs (e.g., J.D. Power, Black Book, Manheim).
• Dashboard Development: Replace manual spreadsheet reports with dynamic, interactive, and self-service dashboards using Tableau.
• Risk Reporting & Monitoring: Conduct necessary testing to ensure smooth transition between reporting platforms.
• Documentation & Governance: Map out legacy spreadsheet logic and draft comprehensive documentation for the newly automated systems to ensure data governance compliance.
• Stakeholder Training: Upskill team members on how to interpret, navigate, and utilize the new BI reporting tools.

For immediate consideration please click APPLY to begin the screening process with Alex.