Senior Data Engineer

Warwick
2 days ago
Create job alert

Role: Senior Data Engineer

Background:

Leveraging data analytics to provide insights and recommendations to drive strategic decision-making collaborating with cross-functional teams, including Finance, Accounting, Operations, HR, and others to deliver accurate and timely financial reporting, dashboards, analytics, and data-driven insights.

Key Accountabilities

A Senior Data Engineer (Production Support) will be responsible for monitoring, maintaining, and supporting ETL processes, data pipelines, and data warehouse environments. The ideal candidate should have strong troubleshooting skills, hands-on experience with ETL tools, and the ability to quickly resolve production issues to ensure data availability, accuracy, and reliability.

  • Monitor and support daily ETL processes, data pipelines, and batch jobs to ensure timely and accurate data delivery.
  • Troubleshoot and resolve production issues, job failures, and performance bottlenecks across ETL and data warehouse systems.
  • Work Closely with Data platform team to resolve data load issues.
  • Perform root cause analysis of recurring issues and implement permanent fixes.
  • Collaborate with development teams to transition projects smoothly into production and ensure operational readiness.
  • Implement and maintain monitoring, alerting, and logging solutions for proactive issue detection.
  • Ensure data quality, consistency, and availability through ongoing validation and health checks.
  • Apply best practices for production support, including incident management, change management, and problem management.
  • Work closely with business users, data analysts, and other stakeholders to resolve data-related queries.
  • Document runbooks, support procedures, and knowledge base articles to streamline production operations.
  • Continuously optimize processes for reliability, performance, and scalability in production environments.
  • Ensure compliance with data security, access controls, and audit requirements in production systems.

    Day-to-Day Tasks - Senior Data Engineer (Production Support)

    Production Support:

  • Check system dashboards, logs, and alerts for failures or anomalies.
  • Verify data quality and integrity checks (row counts, duplicates, missing data, schema changes).
  • Review ETL/ELT job runs, data pipeline executions, and batch processes.
  • Validate data loads into staging, warehouse, and downstream systems for critical tables.
  • Monitor real-time and scheduled jobs to ensure SLAs are met.
  • Investigate and resolve production issues (job failures, data inconsistencies, performance delays).
  • Collaborate with business users to resolve data access or reporting issues.
  • Coordinate with development/engineering teams for fixes, hot patches, or re-runs of failed jobs.
  • Track and document incidents, resolutions, and preventive measures in ticketing systems (e.g., ServiceNow, Jira).
  • Participate in daily/weekly operations meetings to report status and highlight issues.
  • Handover critical ongoing issues to on-call/offshore support (if applicable).

    Minor Works/ Maintenance:

  • Enhance Existing models with addition of fields as per the requirements.
  • Help with Deployments and initial loads during Go-live.
  • Perform root cause analysis for recurring or high-severity incidents.

    Proactive/Preventive Work:

  • Fine-tune ETL workflows and SQL queries to improve performance.
  • Implement monitoring scripts and automation to reduce manual intervention.
  • Restructure the Load plans to improve effeciency.
  • Review security and access controls to ensure compliance.
  • Update documentation (runbooks, troubleshooting guides, SOPs) for operational continuity.

    Skills and Capability requirements:

  • 6+ years of experience with ETL, data pipelines, and data warehouse production environments.
  • Strong expertise in troubleshooting ETL/ELT processes using tools such as Matillion, Informatica, ODI, or SSIS.
  • Experience in cloud-based data platforms like Snowflake.
  • Proven ability to analyze job failures, perform root cause analysis, and implement permanent fixes.
  • Hands-on experience with monitoring, alerting, and logging tools.
  • Familiarity with incidents, problem, and change management processes in ITIL-based environments.
  • Strong SQL programming and debugging skills with relational and cloud databases.
  • Experience with traditional and non-traditional forms of analytical data design (Kimbal, Inmon etc)
  • Excellent communication skills to interact with business users, analysts, and cross-functional technical teams.

    Nice to Have
  • Domain knowledge in the area of finance data is preferred.
  • Experience with SAP Systems and Databases
  • Knowledge of data visualization tools, such as PowerBI or Tableau

Related Jobs

View all jobs

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How Many Data Engineering Tools Do You Need to Know to Get a Data Engineering Job?

If you’re aiming for a career in data engineering, it can feel like you’re staring at a never-ending list of tools and technologies — SQL, Python, Spark, Kafka, Airflow, dbt, Snowflake, Redshift, Terraform, Kubernetes, and the list goes on. Scroll job boards and LinkedIn, and it’s easy to conclude that unless you have experience with every modern tool in the data stack, you won’t even get a callback. Here’s the honest truth most data engineering hiring managers will quietly agree with: 👉 They don’t hire you because you know every tool — they hire you because you can solve real data problems with the tools you know. Tools matter. But only in service of outcomes. Jobs are won by candidates who know why a technology is used, when to use it, and how to explain their decisions. So how many data engineering tools do you actually need to know to get a job? For most job seekers, the answer is far fewer than you think — but you do need them in the right combination and order. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable and employable rather than overwhelmed.

What Hiring Managers Look for First in Data Engineering Job Applications (UK Guide)

If you’re applying for data engineering jobs in the UK, the first thing to understand is this: Hiring managers don’t read every word of your CV. They scan it. They look for signals of relevance, credibility, delivery and collaboration — and if they don’t see the right signals quickly, your application may never get a second look. In data engineering, hiring managers are especially focused on whether you can build and operate reliable, scalable data systems, handle real-world data challenges and work effectively with analytics, BI, data science and engineering teams. This guide breaks down exactly what they look at first in your application — and how to shape your CV, portfolio and cover letter so you stand out.

The Skills Gap in Data Engineering Jobs: What Universities Aren’t Teaching

Data engineering has quietly become one of the most critical roles in the modern technology stack. While data science and AI often receive the spotlight, data engineers are the professionals who design, build and maintain the systems that make data usable at scale. Across the UK, demand for data engineers continues to rise. Organisations in finance, retail, healthcare, government, media and technology all report difficulty hiring candidates with the right skills. Salaries remain strong, and experienced professionals are in short supply. Yet despite this demand, many graduates with degrees in computer science, data science or related disciplines struggle to secure data engineering roles. The reason is not academic ability. It is a persistent skills gap between university education and real-world data engineering work. This article explores that gap in depth: what universities teach well, what they consistently miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data engineering.