Assistant Manager - Data Analyst

Job Description – Data Analyst (Thane)

A. Position Overview
Position Title: Data Analyst
Department: Compliance
Level/Band: Sr. Executive / Assistant Manager

B. Organizational Relationships
Reports To: Manager – Compliance
Supervises: NA

C. Job Dimensions
Geographic Area Covered: NA
Stakeholders Internal: IT, Operations
External: NA

D. Key Result Areas
1. Development of control reports and automation in ACL
• Develop, maintain, and automate exception reports, control reports, and compliance monitoring reports using ACL Analytics.
• Build and automate reports for monitoring red flags, KRIs, and KPIs.
• Design and optimize data queries.
• Ensure reports are accurate, efficient, scalable, and aligned with business requirements.
• Continuously enhance reporting capabilities.
• Maintain detailed documentation.

2. Data Analytics and Outlier Detection
• Analyze large and complex datasets to identify anomalies, trends, exceptions, and compliance concerns.
• Perform data profiling and investigative analytics.
• Develop outlier reports.
• Provide actionable insights and recommendations.
• Support periodic and ad-hoc compliance reviews.

3. Data Extraction and Query Development
• Build complex SQL and ACL queries.
• Work closely with Technology and Data Management teams.
• Develop data extraction processes and reports.
• Ensure completeness, accuracy, and integrity of extracted data.
• Troubleshoot data-related issues.
• Provide analytical support to Compliance and Investigation teams.
• Collaborate with stakeholders.

4. Projects / Assignments
• Lead or participate in projects involving data analysis, compliance monitoring, and reporting automation.
• Develop innovative analytical solutions.
• Deliver ad-hoc reports, dashboards, and analysis.
• Identify opportunities to improve reporting efficiency.

E. Skills Required
Technical:
• Good working knowledge of ACL.
• Good working knowledge of SQL queries.
• Experience supporting business teams in data extraction.
• Understanding of outliers, red flags, and fraud indicators.

F. Incumbent Characteristics
Qualification: Post-graduate (IT)
Experience: 3-7 years in data analysis / SQL / ACL
Desired: Prior experience in insurance industry.