Lead Data Engineer (SC Cleared) in Newcastle

Lead Data Engineer (SC Cleared) in Newcastle

Newcastle Full-Time 58500 - 71500 £ / year (est.) On-site
S

At a Glance

  • Tasks: Lead data migration projects and design robust ETL processes using Azure PostgreSQL.
  • Company: Join a multi-award-winning digital consultancy making a positive impact on UK citizens.
  • Benefits: Inclusive culture, flexible working arrangements, and opportunities for professional growth.
  • Other info: Diversity is key; we welcome applicants from all backgrounds.
  • Why this job: Be at the forefront of data transformation in a dynamic public sector environment.
  • Qualifications: Extensive experience in data migration, ETL, and database design required.

The predicted salary is between 58500 - 71500 £ per year.

  • About
  • Scrumconnect Consulting

Scrumconnect Consulting is a multi-award-winning UK public sector digital consultancy, positively influencing the lives of over forty million UK citizens.

We bring deep expertise in agile delivery, digital transformation, and platform engineering across central government.

With a team of over one hundred and twenty-five professionals — more than forty percent of whom are women — we are committed to building inclusive, diverse teams that reflect the communities we serve.

Role Overview

  • We are looking for
  • Lead Data Engineer to join a dedicated

Data Migration Squad supporting the migration of CRS data and reporting capabilities to a new platform.

The role requires strong specialist expertise in data migration, data modelling, ETL, database design, and Azure Postgre SQL .

You will take technical ownership of designing and delivering the end-to-end data migration capability, ensuring data is migrated accurately, securely, and within critical programme timelines.

This is a senior data engineering and database-focused role and does not require Java or application development expertise.

Key Responsibilities

  • Design and deliver the end-to-end data migration strategy for CRS.
  • Develop and implement

ETL processes to Azure Postgre SQL to support data migration and future operational requirements.

  • Design and maintain logical and physical data models for the target platform.
  • Establish the data migration capability as the new platform becomes available.
  • Define and implement approaches for moving CRS data into staging and production database environments .
  • Develop robust processes for data extraction, transformation and loading.
  • Ensure data quality, validation, reconciliation and governance throughout the migration lifecycle.
  • Support the migration and transformation of data required for

140+ operational reports .

  • Work closely with business and technical stakeholders to understand reporting requirements.
  • Ensure target data structures support both current and future reporting requirements.
  • Provide technical leadership and oversight across data migration and data modelling activities .
  • Identify, assess and mitigate data migration risks.
  • Troubleshoot complex data and database issues during migration.
  • Ensure migration activities are delivered within agreed programme timescales.
  • Establish repeatable and maintainable migration processes for ongoing operational use.

Essential Skills & Experience

  • Extensive experience as a

Senior / Lead Data Engineer with a strong focus on data migration.

  • Proven experience designing and delivering complex data migration solutions .
  • Strong hands-on experience with

ETL development and implementation .

  • Strong experience working with

Azure Postgre SQL .

  • Excellent knowledge of relational databases and SQL .
  • Strong experience in logical and physical data modelling .
  • Experience designing database structures for operational and reporting requirements.
  • Strong understanding of data quality, validation, reconciliation and governance .
  • Experience migrating large or complex datasets between platforms.
  • Experience designing staging and production data environments .
  • Strong understanding of data transformation and mapping.
  • Experience supporting reporting and analytics through well-designed data structures.
  • Ability to provide technical leadership across data migration workstreams.
  • Strong stakeholder management and communication skills.
  • Experience identifying and managing data migration risks and dependencies.
  • Azure / Data Platform Experience
  • Strong experience with relevant

Azure data platform technologies , particularly

  • Azure Postgre SQL
  • Azure Data Factory / ETL tooling
  • Azure Storage / Data Lake
  • Azure database services
  • Azure data integration and migration capabilities
  • Azure monitoring and operational tooling
  • Data Engineering & Database Skills
  • Advanced SQL
  • ETL / ELT
  • Data migration
  • Data modelling
  • Database design
  • Data transformation
  • Data mapping
  • Data validation
  • Data reconciliation
  • Data quality
  • Data governance
  • Performance optimisation
  • Reporting data structures
  • Relational database technologies
  • Reporting Experience
  • The role will support the migration and transformation of data required for

140+ operational reports .

Experience should therefore include

  • Understanding reporting data requirements.
  • Designing data structures to support operational reporting.
  • Data transformation for reporting purposes.
  • Data validation and reconciliation between source and target systems.
  • Supporting reporting teams and business stakeholders.
  • Optimising data structures for reporting performance.
  • Technical Leadership

The successful candidate will be expected to

  • Take ownership of the technical data migration approach.
  • Provide guidance on data modelling and database design.
  • Review migration and ETL solutions.
  • Identify technical risks and dependencies.
  • Work collaboratively with technical architects, developers, reporting teams and business stakeholders.
  • Establish good engineering and data migration practices within the squad.

Desirable Experience

  • Experience working on large-scale government/public-sector data migration programmes.
  • Experience migrating data from legacy platforms.
  • Experience working with

Actian or similar legacy database technologies.

  • Experience with complex operational reporting environments.
  • Experience working in Agile delivery teams.
  • Experience with automated data validation and reconciliation.
  • Azure certifications or relevant data engineering certifications.
  • Ideal Candidate Profile
  • The ideal candidate will be a

Lead/Senior Data Engineer or Database/Data Migration specialist who has hands-on experience taking ownership of complex data migration programmes, particularly where

ETL processes, Azure Postgre SQL, data modelling, data quality and reporting are key components.

Diversity and Inclusion

At Scrumconnect Consulting, we believe that diversity drives innovation.

We are committed to creating an inclusive environment where every individual is respected, valued, and supported.

We welcome applications from candidates of all backgrounds and experiences, and we actively encourage applications from women, people with disabilities, underrepresented communities, and those seeking flexible working arrangements.

Lead Data Engineer (SC Cleared) in Newcastle employer: Scrumconnect Limited

Scrumconnect Consulting is an exceptional employer that fosters a collaborative and innovative work culture in the heart of London. With a strong emphasis on professional growth, employees are encouraged to enhance their skills through continuous learning and participation in Agile practices. The company offers competitive benefits and a dynamic environment where your contributions directly impact cutting-edge AI-driven services.

S

Contact Details:

Scrumconnect Limited Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Lead Data Engineer (SC Cleared) in Newcastle

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Scrumconnect Limited!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Lead Data Engineer (SC Cleared) at Scrumconnect Limited.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Scrumconnect Limited.

✨Apply Directly through Our Website

When you find a suitable opening like Lead Data Engineer (SC Cleared) at Scrumconnect Limited, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Lead Data Engineer (SC Cleared) in Newcastle

Data Migration
Data Modelling
ETL Development
Azure PostgreSQL
Database Design
Data Quality
Data Validation

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at Scrumconnect Limited, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Scrumconnect Limited. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at Scrumconnect Limited

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Scrumconnect Limited!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.