Job Description

:Job Title: Service Delivery EngineerJob SummaryEXL is looking for a Service Delivery Engineer within the Cloud Data Warehouse Managed Services team. The job is a hybrid role offering a wide variety of opportunities and will suit someone who can adapt quickly and rise to the challenge of a small, fast-growing software organisation in one of the largest industries in the world.Leadership not only in the conventional sense, but also within a team, we expect people to be leaders. Candidate should elicit leadership qualities such as innovation, critical thinking, optimism, positivity, communication, time management, collaboration, problem-solving, acting independently, knowledge sharing and being approachable.ResponsibilitiesThe candidate should be STRONG IN:

• Technical responsibility for maintaining the client Cloud Data Warehouses including data updates, bugs and data fixes
• Oversee the smooth and efficient execution of production data loading pipelines,
• Monitor and troubleshoot data pipeline issues, ensuring timely resolution and minimal disruption to data workflows,
• Prioritizing support incidents/requests based on priority/severity
• Optimise and tune existing data infrastructure for performance, reliability, and scalability,
• Implement data governance and security measures to ensure the integrity and confidentiality of sensitive information,
• Develop and maintain comprehensive documentation,
• Ensure data lake readiness and health check, and support reporting & cost optimization (FinOps),
• ETL processes, architecture & working experience in ETL tools such as Azure Data Factory (ADF) and Databricks,
• Databricks cluster administration, monitoring and troubleshooting,
• Working experience with SQL and Python code
• Development of enhancements to existing client data warehouses such as addition of new data sources,
• Potential to get involved with performance tuning, design or architecture of new solutions with Data Warehouse Architects,
• Data warehouse working experience of concepts and development using SQL on single (SQL Server, Oracle or Similar) and parallel platforms (Azure SQL Data Warehouse Synapse or Snowflake),
• Understanding of Spark or Hadoop or Hive (incl. derivatives like pySpark (preferred), SparkScala or SparkSQL)
• Code Management & working experience in GIT Hub, Azure DevOps or similar
• Expertise in implementing DevOps practices such as infrastructure as code, continuous integration and automated deployment.
• Technical concepts, analytical and problem-solving skills, with ability to confidently interact with client\xe2\x80\x99s Technical Lead/Manager,
• Communication (read & write in English), Collaboration & Presentation skills & working experience as team player,

• Application supports:
• On-call rotation
• Receiving and acknowledging tickets
• Incident triaging and priority assessment
• Assignment of incidents
• Incident resolution
• Application monitoring and preventive maintenance
• Weekly status and SLA reporting
• Incident and problem management:
• Analyse, troubleshoot and resolve complex production application defects
• Identify root cause and devise and implement permanent solutions to recurring defects
• Build and maintain application monitoring, optimisation and utilisation
• Devise or modify programs to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results.
• Monitor production ADF jobs and Databricks environments

EXL Service