Senior Data Engineer

Warwick
21 hours 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 - Azure & Snowflake

Senior Data Engineer (AWS, Airflow, Python)

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 Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

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

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

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

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.