Loading open roles
GreenTree Advisory Services Pvt. Ltd.
Core Analytic - Python & SQL
GreenTree Advisory Services Pvt. Ltd. · posted 7 months ago
Mumbaina
About the role
Job Description
Role: Core Analytic - Python & SQL
Work Location: Ithink, Thane
Experience: 3+ years
Role Type: Individual Contributor
Shift Timing: 1:30 PM – 10:30 PM
Roles and Responsibilities
- Review and interpret loss run data and claim-related placement data to assess data availability for analytical reporting.
- Identify data gaps or inconsistencies and engage with relevant stakeholders to obtain clarification or additional information required for reporting.
- Cleanse raw data in accordance with defined standard operating procedures.
- Automate data processing and reporting workflows using Python programming and Server Integration Services.
- Standardized datasets to enable flexible analysis and reporting across multiple dimensions.
- Develop standard and customized analytical models using Microsoft Power Business Intelligence.
- Apply advanced Microsoft Excel functionality, including slicers, nested formulas, and macros, to generate dynamic charts and reports aligned to policy years, including automated output where required.
- Design automated standard and customized templates to reduce manual effort, minimize errors, and improve turnaround times.
Skills
- Experience in developing dashboards using data visualization tools, including Microsoft Power Business Intelligence.
- Experience using advanced Microsoft Excel functionality, including complex formulas, macros, and Visual Basic for Applications.
- Working experience with Python programming & Structured Query Language for data processing and automation.
- Bachelor’s degree in commerce, Science, or Technology, or progress toward Chartered Insurance Institute certification, which is considered an advantage.
- Demonstrates clear and effective verbal and written communication.
- Proficiency in reviewing, interpreting, and comprehending detailed information accurately.
- Analytical approach to problem identification and solution development.
- Experience collaborating effectively within team environments while meeting defined quality standards and delivery timelines.