Job Description

:
Role Description
This is a full-time hybrid role for Data Analyst with SQL and Python skills at EXL in Noida Candidate will be responsible for analyzing and interpreting complex data to inform business decisions, identify trends, and optimize business processes. The ideal candidate will have a strong background in SQL, data analysis, and with excellent communication and problem-solving skills.
Key Responsibilities

• Write complex SQL queries to extract, manipulate, and analyze large datasets from various databases and data warehouses.
• Analyze data to identify trends, patterns, and correlations, and provide insights to stakeholders.
• Ensure data quality and integrity by developing and implementing data validation and data cleansing processes.
• Collaborate with data engineers to ensure data pipelines are properly designed and implemented.
• Collect, process, and perform statistical analysis on large datasets to identify trends and patterns using Python.
• Communicate complex data insights to non-technical stakeholders through clear and concise reports and presentations.
• Optimize SQL queries for performance, using techniques such as indexing, and query rewriting.
• Troubleshoot SQL-related issues, such as query errors, performance bottlenecks, and data inconsistencies.
• Develop and maintain SQL scripts to automate data extraction, data transformation, and data loading processes.

• 3+ years of experience in data analysis, with a focus on SQL and database management.
• Proficiency in SQL, including complex queries, joins, and subqueries.
• Familiarity with data modeling, data warehousing, and ETL processes.
• Proficiency in Python programming language, including experience with popular libraries such as Pandas, NumPy,
• Strong understanding of data governance and data quality principles.
• Strong analytical and problem-solving skills, with the ability to break down complex problems into manageable components.
• Excellent analytical and problem-solving skills.
• Strong attention to detail and accuracy.
• Effective communication skills to present findings to non-technical stakeholders.