Data Engineer

TEKsystems
Warwick Civil Parish, United Kingdom
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Warwick Civil Parish, United Kingdom

Tech stack

JIRA
Cloud Computing
Databases
ETL
Data Warehousing
Software Debugging
Performance Tuning
Power BI
SAP Project System
SQL Databases
SQL Server Integration Services
Tableau
Data Logging
Snowflake
Data Inconsistencies
Data Pipelines
ServiceNow

Job description

Responsible for monitoring, maintaining, and supporting ETL processes, data pipelines, and data warehouse environments. Ensures data accuracy, reliability, and timely delivery by resolving production issues and optimizing system performance. Key Responsibilities

  • Monitor and support daily ETL/ELT jobs, data pipelines, and batch processes.
  • Troubleshoot job failures, performance issues, and data inconsistencies.
  • Perform root cause analysis and implement long-term fixes.
  • Collaborate with data platform, development, and business teams to resolve data load or access issues.
  • Maintain and improve monitoring, alerting, and logging systems.
  • Ensure data quality, availability, and adherence to SLAs.
  • Support incident, change, and problem management processes.
  • Document runbooks, procedures, and troubleshooting guides.
  • Optimize ETL workflows, SQL queries, and data load plans.
  • Ensure compliance with security and audit requirements.

Day-to-Day Activities

  • Review dashboards, logs, alerts, and job statuses.
  • Validate data loads across staging, warehouse, and downstream systems.
  • Investigate and resolve production issues or performance delays.
  • Coordinate fixes, re-runs, and deployments with engineering teams.
  • Manage tickets (ServiceNow/Jira) and provide updates in operations meetings.
  • Support business users with data or reporting issues.
  • Hand over critical issues to on-call or offshore teams when needed.

Maintenance & Proactive Work

  • Enhance existing data models as required.
  • Assist with deployments and go-live support.
  • Automate monitoring tasks and reduce manual interventions.
  • Review access controls and update documentation for operational continuity.

Requirements

  • 6+ years of Experience supporting ETL, data pipelines, and data warehouse environments.
  • Strong troubleshooting skills across ETL tools (Matillion, Informatica, ODI, SSIS).
  • Experience with cloud platforms (Snowflake preferred).
  • Strong SQL debugging and performance tuning skills.
  • Familiarity with ITIL processes (incident/problem/change management).
  • Knowledge of data warehousing methodologies (Kimball, Inmon).
  • Excellent communication and stakeholder interaction skills.

Nice to Have

  • Experience with finance data.
  • Exposure to SAP systems and databases.
  • Knowledge of Power BI or Tableau.

Apply for this position