Senior Risk Analytics consultant

In this role, you will:

• Lead or participate in moderately complex initiatives, and delivering insight and decision strategies within analytics and reporting, and contribute to large-scale planning related to Risk Analytics
• Review and analyze moderately complex data aggregation, forecasting, reporting, and programming models
• Be responsible for process production, data reconciliation, and model documentation in alignment with policy governance
• Resolve data, production, business modeling, and lead team to meet Risk Analytics deliverables while leveraging solid understanding of risk reporting policies, modeling strategies, procedures, regulatory requests, and compliance requirements
• Collaborate and consult with peers, experienced managers, compliance, and technology to resolve modeling, forecasting, and production issues, and achieve analytic and reporting goals
• Lead projects, teams, and mentor less experienced staff
• Partner with cross enterprise risk analysts in development of common modeling strategies

• Develop and optimize SQL queries to create datasets for dashboards, including writing complex queries with multiple joins, sub-queries, and analytical functions.
• Utilize Python for data processing and automation, leveraging libraries such as Pandas, NumPy, and Matplotlib, along with advanced concepts like tkinter, exception handling, and multiprocessing.
• Apply Excel skills for data analysis and reporting, using basic formulas (mandatory) and intermediate/advanced functions (preferred).
• Understand and work with data warehouse concepts, including data sources, staging, and reporting layers.
• Manage and maintain existing codebase efficiently, ensuring proper version control and change tracking.
• Identify opportunities for process improvements, standardization, and automation to enhance operational efficiency.
• Demonstrate familiarity with Market Risk domain terminologies, including basic knowledge of derivative products, asset classes, and regulatory requirements.

Required Qualifications:

• 4+ years of Risk Analytics experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

Desired Qualifications:

• Should have experience with loading data using Python from various sources (SQL Server,DataLakes Flat Files, csv)
• Should have sound SQL server knowledge.
• Experience in writing optimized complex SQL query using multiple joins, analytical functions, sub-query.
• Strong Python development experience
• Hands on experience on libraries Pandas, Numpy, pyQT,csv
• Prior experience in automation of manual processes using Python
• Good understanding of handling large volumes of data efficiently using Python