Lead Data Analyst

Job Description

POSITION SUMMARY: We are looking for an experienced Data Analyst with strong SQL skills to join our Data Management team. This role will work with cross-functional teams to understand their data needs, profile data, analyze large datasets, find patterns, create test scenarios, and help improve business performance. JOB FUNCTION AND RESPONSIBILITIES: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Examples below: Write and optimize complex SQL queries to extract, manipulate, and analyze data from relational databases (SQL server, Oracle, MySQL). Coordinate with Business and tech members of the team to generate and visualize key metrics. Troubleshoot and debug existing SSIS packages to improve performance and reliability. Performance tune SQL queries and views. Conduct exploratory data analysis to identify trends, anomalies, and opportunities. Data flow automation with stored procs, views, and Python/R scripting. Work closely with onshore and offshore data team resources. Collaborate with business and sales teams to understand their data and automation needs. Create and maintain comprehensive documentation for all data definitions, sources, and test plans. QUALIFICATION: To perform this job successfully, an individual must have the following education and/or experience: Bachelor s Degree is needed. 5+ years of experience as a Data Analyst, Business Analyst, or SQL. Expert knowledge of SQL is a must (Joins, subqueries, CTEs, query optimization). Pythion or R for data analysis is a plus. Experience with AWS services is a plus. Strong analytical and problem-solving skills with attention to detail. Should be fluent in speaking English and be able to communicate well with business stakeholders. Experience in Agile Project Management methodology is a plus. WORK SCHEDULE OR TRAVEL REQUIREMENTS: General work schedule (for shift roles). Around 3 hours of overlap between onshore and offshore work hours is expected. 1:30 PM IST to 10:30 PM IST.