Source description
About the role
B2_Automation
Trending
Apply Now
Job Info
- Job Identification8004
- Posting Date12/22/2025, 03:14 AM
- Job RoleApplication Development-Business Analyst
- Experience (In Years)3-6
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
Responsibilities
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
Qualifications
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
Required Skills
- Python Programming Language
Similar Jobs
See More Jobs
IMP NoticeLearn more
ACCEPT COOKIESDECLINE OPTIONAL COOKIES
Are You Still With Us?
It seems you've been gone for a while. For security reasons we will end your session automatically in 03:00 unless you would like to continue working.
End SessionContinue Working
Work Summary
This summary is generated by AI Assist. Click inside the summary text box to make changes as necessary.
DiscardAdd Summary
Page B2_Automation - EXL Talent Acquisition Team Careers loaded
More at EXL