1970755-Assistant Manager

Position: Data Analyst Location: Gurgaon Timings: 12:00 PM to 10:00 PM Role Overview: Doing independent research, analyze, and present data as assigned Expected to work in close collaboration with the EXL team and clients on Commercial insurance actuarial projects for US/UK markets Should be able to understand risk and underwriting , plicate rating methodology Develop and use collaborative relationship to facilitate the accomplishment of working goals Working experience in P&C insurance domain for US insurance markets is a must Excellent written and verbal communication skills Facilitate data requirements while working with actuaries Have excellent SQL skills to extract data for scheduled processes and adhoc requests Automate manual processes and ETL pipelines using Python Utilise/help migrate existing SAS processes from SAS to SAS Viya Key Responsibilities: Collaborate with actuaries to understand their data and reporting needs related to premium, loss, and exporsure analysis. Build and optimize complex SQL queries to extract, join, and aggregate large datasets from multiple relational sources. Develop and automate data pipelines in Python for ETL ,data wrangling , and wexploratory analytics. Use SAS for legacy processes, statistical outputs, and ad hoc data manipulation as required by actuarial models/processes Validate data outputs for accuracy and consistency, troubleshoot discrepancies, and ensure data quality before delivery Create documentation of data logc, process flows, and metadata over confluence and SharePoint to ensure transparency and knowledge sharing. Contribute to continuous improvement by recommending process automation or optimization opportunities in existing workflows Support Dashboarding or visualization needs(optional) using tools like Powe BI. Work in an agile or iterative environment with clear communication or progress, blockers and timelines. Required Skillset: SQL(Expert Level) : Complex Joins, subqueries, window functions, CTEs, query Optimization and performance tuning, working with large tables in cloud/on-premise environments( Teradata, SQL Server, or equivalent) Python( intermediate to expert): Data wrangling using pandas, NumPy, Script automation and API Consumption, Familiarity with Visual Studio, Jupyter and modular Python Scripting SAS(Intermediate): Reading/ writing from/to datasets, connecting with external sources, macros, PROC SQL Knowledge of AWS is preferred Experience with commercial insurance Understanding of actuarial concepts such as loss triangles, reserving, and pricing Exposure to Git, JIRA, Confluence Proficiency in Excel, VBA Macros(Preferred) Candidate Profile: Bachelor's/Master's degree in engineering, economics, mathematics, actuarial sciences, or similar technical degree. Master's in business or financial management is also suitable Affiliation to IAI or IFOA, with at least 3 actuarial exams 3-8 years' experience in data analytics in insurance or financial service industry with good understanding of actuarial concepts - pricing, reserving, and/or valuation Demonstrated ability to work with actuarial or statistical teams in delivering high-quality data and insights Strong problem solving attitude and comfort with ambiguity in requirements Strong ability to learn technical and business knowledge Outstanding written and verbal communication skills Excellent time and work management skills Able to work in fast pace continuously evolving environment and ready to take up uphill challenges Is able to understand cross cultural differences and can work with clients across the globeEXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration - and we've been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers. We function as one team to make your goals our goals, whether that's unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible. Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It's our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients. Find out for yourself why clients, employees, and analysts think we're some of the best in the business. Contact us to see how we can help you achieve your goals.