Job Title & Location

Data Processing & Systems Support Specialist

London, Westgate (Hybrid)

About the Role

We are seeking a proactive and detail-oriented Data Processing & Systems Support Specialist to join our team. This role is a hybrid position, combining data processing, system support, and troubleshooting, with a focus on preparing clean, accurate datasets for analysis by other partners. The successful candidate will also be responsible for supporting various administrative tasks and activities to ensure smooth operation of our data systems and processes.

In this role, you will ensure data is processed, formatted, and organized correctly, and ready for downstream analysis. You will also assist with administrative functions that support the team's daily operations and contribute to overall system efficiency.

Key Responsibilities

Data Processing & Preparation:

• Use advanced Excel functions (e.g., Pivot Tables, IF formulas, VLOOKUP, and data formatting) to process, clean, and structure data for analysis.
• Ensure data consistency and accuracy, organizing datasets in formats that are easy for other teams to work with.
• Prepare and validate large datasets for analysis, ensuring the data is properly cleaned and ready for consumption by analysts.

System Support & Troubleshooting:

• Monitor and troubleshoot data systems, resolving issues related to data flow, system performance, and data availability.
• Work closely with internal teams to diagnose and resolve technical issues promptly, ensuring data is available when needed.

Database Management:

• Maintain and manage databases, ensuring data is stored in a structured, accessible, and secure manner.
• Optimize queries and database performance to ensure efficient data retrieval and storage.
• Oversee the data management processes to ensure data integrity and availability for analysis.

SQL & Stored Procedures:

• Write and optimize complex SQL queries to extract and manipulate data for reporting and analysis.
• Understand and manage stored procedures, ensuring proper execution and integration with data processing systems.
• Troubleshoot and support batch processes to ensure smooth, error-free data processing.

Administrative Support:

• Assist with various administrative tasks, including maintaining documentation, tracking data system issues, and managing internal records.
• Support day-to-day operations by helping coordinate tasks, reporting, and follow-up activities.
• Maintain records of system issues, process improvements, and data-related changes for audit and reporting purposes.
• Assist with the preparation of internal reports or presentations as required.

Required Skills & Qualifications

• Strong proficiency in Microsoft Excel, including advanced functions such as Pivot Tables, IF formulas, Lookups, and data formatting.
• Proficient in SQL, with the ability to write and optimize complex queries to manage and extract data.
• Understanding of stored procedures and their role in managing and processing data.
• Solid knowledge of database management practices and ensuring efficient data storage and access.
• Experience with batch processing and troubleshooting related issues.
• Ability to prepare, clean, and organize data for analysis, ensuring data readiness and consistency.
• Strong administrative and organizational skills, with the ability to manage multiple tasks and maintain detailed records.
• Strong problem-solving skills and data accuracy.

Preferred Skills

• Experience with ETL (Extract, Transform, Load) processes or tools.
• Familiarity with data warehousing concepts and tools.
• Knowledge of programming languages (e.g., Python, R) for data manipulation is a plus.
• Experience in system administration or network troubleshooting is a plus.

Personal Attributes

• Strong analytical approach with the ability to structure and prepare data for others to analyze.
• Superb communication skills, with the ability to collaborate with both technical and non-technical teams.
• Proactive, hard-working, and able to take ownership of tasks and responsibilities.
• Organized and able to manage multiple priorities while maintaining attention to detail.
• A great teammate who is comfortable working with multi-functional teams to ensure smooth data and system operations.

What you’ll get from us

• 25 days annual leave (excl. bank holidays), plus your birthday off!
• Flexible benefits across health, wealth and lifestyle
• Extensive training and excellent scope for career development
• A collaborative and supportive work environment!

#LI-HP1 #LI-Hybrid