Risk Analytics Intern: Data Viz, Automation & AI Tools

Required Skills

• Advanced Microsoft Excel:
  Pivot Tables, Conditional Formatting, Advanced Functions, Power Pivot, VBA & Macros
• SQL:
  Query Writing and Data Extraction
• Power Query (Excel/Power BI)
• Microsoft Power BI:
  Data Modeling, Dashboards, and Visualization
• Version Control:
  Git, Git Hub
• R Programming
• Machine Learning & AI Tools:
  ChatGPT, Claude, Microsoft Copilot

The internship aims to provide students with practical experience in risk data analysis and reporting within a professional environment. Interns will support data analysis, dashboard development, process automation, and reporting while contributing to data accuracy, operational efficiency, and informed decision-making.

• Data Analysis & Reporting:
  Support risk data analysis and reporting using advanced MS Excel (Pivot Tables, functions, conditional logic, Power Pivot) and Power Query.
• Automation & Data Handling:
  Assist in process automation and data extraction using VBA/macros and SQL queries to enhance efficiency and data integrity.
• Visualization & Programming:
  Contribute to risk dashboards and analytics using Power BI, with additional support from Python and/or R for quantitative analysis.
• Digital & AI Enablement:
  Leverage AI tools such as ChatGPT, Claude, and Copilot to improve analytical insights and streamline reporting processes.