Data Engineering Architect – Azure (ADF / SQL / Cloud Data Platform)

TESTQ Technologies Limited
Stratford-upon-Avon
11 hours ago
Create job alert

Job Type: Permanent


Work Mode: Hybrid (2 Days from office)



  • Architect and design end-to-end Azure data engineering solutions (batch + near real-time) aligned to enterprise standards.
  • Define target state architecture for data ingestion, transformation, orchestration, and serving layers.
  • Lead architectural decisions around scalability, resiliency, performance, security, governance, and cost optimization.
  • Design, develop, test, and deploy Azure Data Factory pipelines following best practices (modular design, parameterization, reusability, CI/CD readiness).
  • Build robust ingestion and orchestration workflows using:

    • Mapping Data Flows / Wrangling Data Flows (where applicable)


  • Implement operational excellence: logging, alerting, retry patterns, failure handling, and idempotent design.

SQL Development & Optimization

  • Develop and optimize SQL queries and stored procedures to support ADF pipeline operations and downstream transformations.
  • Conduct query plan analysis and performance tuning (indexes, partitioning strategies, statistics, query rewrites).
  • Establish SQL coding standards and reusable patterns for transformation logic.

Troubleshooting & Analytical Problem Solving

  • Apply a strong analytical mindset to diagnose and resolve complex data integration issues across ingestion, transformation, orchestration, and storage layers.
  • Perform root cause analysis (RCA) for pipeline failures, performance degradation, data quality issues, and environment instability.
  • Design proactive monitoring dashboards and alerts for pipeline SLAs and data freshness.
  • Define and enforce best practices for:

    • CI/CD for ADF (Azure DevOps / Git-based workflows)
    • Infrastructure-as-Code (ARM/Bicep/Terraform—preferred)
    • Version control, code review, release management


  • Implement data governance patterns: metadata management, lineage, auditing, encryption, RBAC, key management, PII controls.
  • Collaborate with security/compliance teams to ensure enterprise adherence.

Leadership & Stakeholder Management

  • Act as a technical leader for data engineering squads; mentor and guide engineers on design patterns and implementation.
  • Translate business requirements into technical architecture and delivery plans.
  • Work closely with Product Owners, Data Analysts, Data Scientists, and Platform teams to ensure alignment.

Required Skills & Qualifications
Must-Have (Strong)

  • 12–16 years of overall IT experience with significant data engineering & architecture exposure.
  • Strong Azure Cloud Data Engineering and associated services architecture knowledge.
  • Deep hands-on experience with:

    • SQL – advanced querying, stored procedures, performance tuning


  • Strong troubleshooting skills for complex multi-system data issues.
  • Strong understanding of data architecture concepts:

    • Data lakes/lakehouse/warehouse, dimensional modeling, ELT/ETL patterns



Azure Ecosystem (Preferred / Good to Have)

  • Azure data services experience in one or more:
  • Monitoring & observability:
  • Security & identity:
  • CI/CD practices for data pipelines; Git branching strategies and release governance.

Behavioral / Soft Skills

  • Excellent analytical thinking and structured problem-solving.
  • Strong communication and stakeholder management skills.
  • Ownership mindset, ability to drive standards and influence cross-team adoption.
  • Proven mentoring/coaching ability.

Education

  • Bachelor’s/Master’s degree in Computer Science, Information Systems, or related field (or equivalent experience).

Nice-to-Have Certifications

  • Microsoft Certified: Azure Data Engineer Associate
  • Microsoft Certified: Azure Solutions Architect Expert

What Success Looks Like (Outcome Focus)

  • Highly reliable ADF pipelines with strong observability, error handling, and SLA adherence.
  • Measurable improvements in SQL performance and pipeline execution time.
  • Standardized architecture patterns adopted across teams.
  • Reduced incident rates through proactive monitoring and strong RCA discipline.

---


#J-18808-Ljbffr

Related Jobs

View all jobs

Data Engineering Architect - Azure

Azure Data Engineering Architect — End-to-End Platform

Data Engineering Architect

Data Engineering Manager Azure AI Finance Brighton

Data Engineering Manager Azure AI Finance Tunbridge Wells Kent

Secure Data Engineer | Azure & Databricks Architect

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.

New Machine Learning Employers to Watch in 2026: UK and Global Companies Driving ML Innovation

Machine learning (ML) has transitioned from a specialised field into a core business capability. In 2026, organisations across healthcare, finance, robotics, autonomous systems, natural language processing, and analytics are expanding their machine learning teams to build scalable intelligent products and services. For professionals exploring opportunities on www.MachineLearningJobs.co.uk , understanding the companies that are scaling, winning investment, or securing high‑impact contracts is crucial. This article highlights the new and high‑growth machine learning employers to watch in 2026, focusing on UK innovators, international firms with significant UK presence, and global platforms investing in machine learning talent locally.

How Many Machine Learning Tools Do You Need to Know to Get a Machine Learning Job?

Machine learning is one of the most exciting and rapidly growing areas of tech. But for job seekers it can also feel like a maze of tools, frameworks and platforms. One job advert wants TensorFlow and Keras. Another mentions PyTorch, scikit-learn and Spark. A third lists Mlflow, Docker, Kubernetes and more. With so many names out there, it’s easy to fall into the trap of thinking you must learn everything just to be competitive. Here’s the honest truth most machine learning hiring managers won’t say out loud: 👉 They don’t hire you because you know every tool. They hire you because you can solve real problems with the tools you know. Tools are important — no doubt — but context, judgement and outcomes matter far more. So how many machine learning tools do you actually need to know to get a job? For most job seekers, the real number is far smaller than you think — and more logically grouped. This guide breaks down exactly what employers expect, which tools are core, which are role-specific, and how to structure your learning for real career results.

What Hiring Managers Look for First in Machine Learning Job Applications (UK Guide)

Whether you’re applying for machine learning engineer, applied scientist, research scientist, ML Ops or data scientist roles, hiring managers scan applications quickly — often making decisions before they’ve read beyond the top third of your CV. In the competitive UK market, it’s not enough to list skills. You must send clear signals of relevance, delivery, impact, reasoning and readiness for production — and do it within the first few lines of your CV or portfolio. This guide walks you through exactly what hiring managers look for first in machine learning applications, how they evaluate CVs and portfolios, and what you can do to improve your chances of getting shortlisted at every stage — from your CV and LinkedIn profile to your cover letter and project portfolio.