Lead Assistant Manager EXL/LAM/**

Job DescriptionEXL (NASDAQ:EXLS) is a leading operations management and analytics company that helps businesses enhance growth and profitability in the face of relentless competition and continuous disruption. Using our proprietary, award-winning Business EXLerator Framework™, which integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation and logistics industries. Headquartered in New York, New York, EXL has more than 24, professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia and South Africa.EXL Analytics provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting-edge analytics techniques, and a consultative approach. Leveraging proprietary methodology and best-of-breed technology, EXL Analytics takes an industry-specific approach to transform our clients’ decision-making and embed analytics more deeply into their business processes. Our global footprint of nearly 2, data scientists and analysts assists client organizations with complex risk minimization methods, advanced marketing, pricing and CRM strategies, internal cost analysis, and cost and resource optimization within the organization. EXL Analytics serves the insurance, healthcare, banking, capital markets, utilities, retail and e-commerce, travel, transportation, and logistics industries.Please visit for more information about EXL Analytics.Role and Responsibilities Overview:Develop and implement a comprehensive quality assurance strategy for data engineering projects, ensuring that data quality standards are met throughout the data pipeline.Collaborate with cross-functional teams to define test plans and strategies for validating data pipelines, ETL processes, and transformations using PySpark, Databricks, and SQL.Design and execute tests using SQL queries and data profiling techniques to validate the accuracy, completeness, and integrity of data stored in various data repositories, including data lakes and databases.Adhere to formal QA processes, ensuring that the Systems Implementation (SI) team is using industry-accepted best Practices. Ensure data accuracy in both SQL and the Data Lakehouse platform. Use detailed and effective written communication skills to document the features tested and bugs found.Conduct performance testing of data processing jobs and workflows to identify bottlenecks, optimize code, and improve overall system performance using PySpark performance tuning techniques.Act as a key point of contact for all QA aspects of releases, providing test services and coordinating QA resources internally and externally in SQL, PySpark/Python, Databricks Delta, and Delta Live Tables.Identify the critical defects and work with BI and Data Engineering teams to mitigate them; define and enforce the acceptance criteria for testing, which inherently determines the approval for code promotions to higher environments.Candidate ProfileBachelor’s/Master's degree in computer science/engineering, operations research, or related data and analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to applyProficiency in Data Engineering, Data Management (ETL) solutions with capabilities with HIVE (preferred)In-depth understanding of PySpark, Python, SQL, and Databricks Delta and Delta Live Tables with Unity Catalog (preferred)Insurance Industry knowledge preferred.QA best practices and methodologies to design, implement, and automate processes.Knowledge on SQL & PySpark (Mandatory)Experience extracting and manipulating data from relational databases with advanced SQL, HIVE, Python/PySpark.Proficiency in design and test bed creation to support various test cases and accounts for variety and volume of test data.Test strategy development experience and demonstrate knowledge in the key areas of managing timelines and dependencies across multiple tests in an agile environment.The entire software development life cycle and test cycles (unit, Regression, Functional, Systems, stress& scale, smoke and sanity)Strong knowledge of design principles, color proposition, and typography.5-10 years experience in data engineering, preferably in data lake/data Lakehouse design-based platformsOutstanding written and verbal communication skillsAble to work in a fast-paced, continuously evolving environment and ready to take uphill challenges.Able to understand cross-cultural differences and can work with clients across the globe.Self-motivated, works well independently and with others.Using metrics-driven approach and closed-loop feedback to improve software deliverables and improve the predictability and reliability of releases.What we offer:EXL Analytics offers an exciting, fast-paced, and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world-class analytics consultants.You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth Analytics requires different skill sets at different levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques.We provide guidance/ coaching to every employee through our mentoring program, in which every junior-level employee is assigned a senior-level professional as an advisor.Sky is the limit for our team members. The unique experiences gathered at EXL Analytics set the stage for further growth and development in our company and beyond.