Lead Assistant Manager
EXL
ERP
Assistant Manager
EXL
full-time
Posted on:
Location Type: Hybrid
Location: Noida • 🇮🇳 India
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
ETLNumpyPandasPythonSQL
About the role
- Analyze and interpret complex data to inform business decisions, identify trends, and optimize business processes.
- 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.
Requirements
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPythondata analysisdata validationdata cleansingstatistical analysisdata modelingdata warehousingETLdata extraction
Soft skills
analytical skillsproblem-solving skillsattention to detailcommunication skills