Lead Data Analyst

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.