EXL

B2_Automation

EXL  •  Gurugram, IN (Onsite)  •  5 months ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description

We are seeking a Risk Analytics / Loss Forecasting Analyst with strong Python, Excel, and SQL skills to support the automation and modernization of consumer credit loss forecasting processes The role focuses on transitioning existing Excel and Excel macro–based forecasting models into scalable, auditable SQL and Python script–based workflows, while ensuring accuracy, governance, and business continuity.

Key Responsibilities

  • Analyze existing Excel and VBA-based loss forecasting models and document underlying business logic and assumptions
  • Translate Excel formulas, macros, and manual processes into Python-based scripts and workflows
  • Develop automated pipelines for data ingestion, transformation, and forecast generation
  • Perform loss forecasting, back-testing, and sensitivity analysis on consumer credit portfolios
  • Use SQL to extract, validate, and reconcile data from databases and data warehouses
  • Ensure Python outputs reconcile with legacy Excel forecasts and meet defined tolerance thresholds
  • Build reusable, modular, and well-documented Python code for ongoing production use
  • Support scenario analysis and stress testing through parameterized Python models
  • Collaborate with risk, finance, and business stakeholders to validate assumptions and outputs
  • Maintain version control, documentation, and audit trails for models and forecasts

Required Skills & Qualifications

  • 2–4 years of experience in banking analytics, loss forecasting, or credit risk modeling
  • Strong proficiency in Python (pandas, NumPy, basic modeling/statistical libraries)
  • Advanced Excel skills, including experience with complex formulas and macros (VBA)
  • Solid SQL skills for querying and validating large datasets
  • Hands-on experience with loss forecasting methodologies (roll rates, vintage analysis, PD/LGD, or loss rate forecasting)
  • Strong analytical skills with attention to detail and data quality

Preferred / Nice-to-Have Skills

  • Experience working in banking, credit cards, unsecured lending, or BNPL portfolios
  • Familiarity with automation frameworks, schedulers, or workflow tools
  • Experience validating or migrating legacy models to modern analytics platforms

Key Responsibilities

  • Analyze existing Excel and VBA-based loss forecasting models and document underlying business logic and assumptions
  • Translate Excel formulas, macros, and manual processes into Python-based scripts and workflows
  • Develop automated pipelines for data ingestion, transformation, and forecast generation
  • Perform loss forecasting, back-testing, and sensitivity analysis on consumer credit portfolios
  • Use SQL to extract, validate, and reconcile data from databases and data warehouses
  • Ensure Python outputs reconcile with legacy Excel forecasts and meet defined tolerance thresholds
  • Build reusable, modular, and well-documented Python code for ongoing production use
  • Support scenario analysis and stress testing through parameterized Python models
  • Collaborate with risk, finance, and business stakeholders to validate assumptions and outputs
  • Maintain version control, documentation, and audit trails for models and forecasts

Required Skills & Qualifications

  • 2–4 years of experience in banking analytics, loss forecasting, or credit risk modeling
  • Strong proficiency in Python (pandas, NumPy, basic modeling/statistical libraries)
  • Advanced Excel skills, including experience with complex formulas and macros (VBA)
  • Solid SQL skills for querying and validating large datasets
  • Hands-on experience with loss forecasting methodologies (roll rates, vintage analysis, PD/LGD, or loss rate forecasting)
  • Strong analytical skills with attention to detail and data quality
EXL

About EXL

Choosing a digital partner is about more than capabilities — it’s about collaboration and character.

Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments.

At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations.

Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale.

Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact.

We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition.

At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward.

For more information, visit www.exlservice.com.

Industry
Consulting & Advisory
Company Size
10,000+ employees
Headquarters
New York, NY
Year Founded
Unknown
Website
exlservice.com
Social Media