KEY RESPONSIBILITIES

• Provide 3rd-level support for data-related issues and help troubleshoot client problems where required

• Perform root cause analysis on production data issues and resolve them accordingly

• Carry out data support services including:

• Maintaining, improving, and optimizing ETL pipelines across a range of technologies
• Identifying and logging bugs relating to data processing
• Review views, stored procedures, statements, and user-defined functions of varying complexity in SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and T-SQL. Identifying problems and recommending solutions.
• Identifying data-related issues and resolving and documenting the fixes appropriately
• Adhere to all documentation, repository management, and quality standards laid out by the data support team. Ensuring code is maintained, optimized, efficient, and concise.
• Maintain the support backlog, including updating all tickets to the documented standard.
• Work with other departments to ensure existing applications and issues are being resolved in a timely and acceptable manner based on priority.

Key Requirements

•1-3 years experience with exposure to SQL Server in the context of data engineering and data support.

•Complete or near complete Bachelor’s Degree or Qualification in Computer Science, Information Technology, with a focus on data engineering or other acceptable certification in data engineering and SQL Server

Technologies

•Microsoft SQL Server - T-SQL

•Business Intelligence - SQL Server Analysis Services (SSAS)

•SQL Server Integration Services (SSIS)

•Power BI

•Git

Skills

•Solve problems with an inquisitive and innovative mind, take on new challenges, staying abreast of new and emerging technologies, Strong communication skills - written and verbal

•Ability to communicate complex solutions to other colleagues and highly motivated and proactive