Data Engineer - Senior Consultant in Newcastle upon Tyne

Data Engineer - Senior Consultant in Newcastle upon Tyne

Newcastle upon Tyne Full-Time 61000 - 70000 £ / year (est.) Remote
O

At a Glance

  • Tasks: Build scalable data platforms and tackle complex engineering challenges with modern technologies.
  • Company: Join Opencast, a forward-thinking tech company focused on impactful data solutions.
  • Benefits: Enjoy a competitive salary, generous holiday, and professional development opportunities.
  • Other info: Collaborative environment with opportunities for mentoring and community building.
  • Why this job: Shape the future of data engineering while making a real difference for clients.
  • Qualifications: Experience in Microsoft Fabric, Azure, and robust data engineering practices required.

The predicted salary is between 61000 - 70000 £ per year.

Ready to build data platforms, not just pipelines? At Opencast, we believe great data engineering is about more than moving and transforming data. It's about creating reliable, scalable foundations that help organisations make better decisions and deliver better services. You’ll tackle complex engineering challenges across integration, migration, modelling and platform design, working with Microsoft Fabric, Azure and modern data technologies. We value engineering craft, thoughtful problem-solving and building solutions that are simple, robust and built to last.

Our data engineering capability is growing, and you'll help guide its direction through mentoring, recruitment and technical leadership, as well as your client work. If you want to shape both the solutions and capability around them, this could be the role for you.

Opencast data engineers help organisations transform how they manage, use and learn from data. The work ranges from building modern lakehouse and warehouse platforms in Microsoft Fabric to modernising legacy environments, migrating complex workloads and improving the quality, governance and reliability of critical data services. This role offers the opportunity to work across the full data lifecycle, combining platform design, engineering, integration and optimisation. Expect to work with structured, semi-structured and unstructured data, building batch and near real-time data pipelines that underpin critical business and public services. You'll collaborate with architects, analysts, software engineers and client teams to solve complex challenges and influence technical direction.

This role involves weekly on-site work, and you’ll be required to travel regularly to client locations across the UK. We’re looking for people who value in-person collaboration, enjoy building strong relationships, and are passionate about delivering solutions that make a real difference for our clients. Due to the nature of this role, you must either hold active Security Check (SC) clearance or be eligible and willing to undergo the clearance process. SC clearance is granted in line with UK Government security vetting requirements. Typically, applicants must have UK citizenship and have lived continuously in the UK for at least the past five years, with no single absence exceeding 28 consecutive days. Nationality and immigration status may also be considered as part of the vetting process. We are unable to progress applications from candidates who do not meet these requirements. If you are unsure whether you meet the eligibility criteria, we encourage you to review the guidance or discuss this with us before applying. We are recruiting for multiple positions, with opportunities available immediately and in the coming months. If you are interested in joining Opencast, we encourage you to apply.

We're looking for engineers who enjoy solving complex technical problems and care about building solutions that are robust, scalable and built to last. Experience in the following areas is important:

  • Microsoft Fabric and Azure data services, including lakehouse, warehouse, notebooks and pipeline capabilities.
  • Building enterprise-scale data platforms, lakehouses and data warehouses.
  • Data modelling and dimensional modelling techniques such as Kimball.
  • ETL/ELT development and large-scale data integration.
  • PySpark, Spark SQL and modern transformation techniques.
  • Advanced SQL and relational databases including SQL Server, PostgreSQL and Oracle.
  • Integrating structured, semi-structured and unstructured data sources.
  • Migration and modernisation of legacy platforms such as Oracle, SQL Server/SSIS or Synapse.
  • Power BI semantic models, curated datasets and supporting analytics platforms.
  • Data quality, governance, metadata management and lineage.
  • Data security, classification and access control approaches.
  • Automated testing, validation, reconciliation testing and performance optimisation.
  • DataOps, CI/CD and version control practices.
  • Agile delivery environments.

Our clients look to us for more than technical delivery. Success in this role comes from being able to navigate ambiguity, solve difficult problems and help clients make confident technical decisions. The strongest consultants combine technical expertise with curiosity, pragmatism and a collaborative mindset. You'll thrive in this role if you enjoy:

  • Solving complex engineering challenges and exploring different approaches to finding the right solution.
  • Influencing technical direction through expertise, evidence and constructive challenge.
  • Working closely with technical and non-technical stakeholders to understand underlying problems rather than simply implement requirements.
  • Balancing engineering quality, governance, security and reliability with business outcomes.
  • Sharing knowledge, mentoring others and helping raise engineering standards.
  • Building trusted relationships with clients and acting as a technical advisor.
  • Keeping pace with emerging technologies and evaluating new approaches where they can add value.
  • Contributing to a growing engineering capability while remaining close to delivery and technology.

Salary: £61,000 - £70,000 per annum.

A competitive package including a 7% employer pension contribution, share options, and a discretionary bonus. You’ll also benefit from 25 days’ holiday and access to 3 annual “life happens” days to support unexpected situations. We provide wellbeing support, ongoing professional development, volunteering opportunities, and the chance to be part of a genuinely supportive team.

This role requires regular on-site attendance at our HQ, hub offices, and client sites, as well as the ability to work from home. Applicants must be able to travel to offices and client sites across the UK as part of their normal working arrangements, as travel is essential for fulfilling the responsibilities of the role.

We welcome candidates from all identities, attributes, ways of thinking and backgrounds to thrive in a career at Opencast. Our aim is for the diversity of our people to be reflected in the solutions we deliver, to help create a fairer society for all.

Interviews will be conducted via Microsoft Teams. We’re happy to make adjustments to support your needs.

Data Engineer - Senior Consultant in Newcastle upon Tyne employer: Opencast

As a growing tech consultancy, we pride ourselves on fostering a collaborative and inclusive work culture that empowers our employees to thrive. With a competitive benefits package, including generous holiday allowances and professional development opportunities, we ensure our team members are supported both personally and professionally. Working at our HQ offers the unique advantage of being at the heart of innovation, where you can directly contribute to impactful solutions for the public sector while building meaningful relationships with clients and partners.

O

Contact Details:

Opencast Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Data Engineer - Senior Consultant in Newcastle upon Tyne

✨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 Opencast!

✨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 Data Engineer - Senior Consultant at Opencast.

✨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 Opencast.

✨Apply Directly through Our Website

When you find a suitable opening like Data Engineer - Senior Consultant at Opencast, 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 Data Engineer - Senior Consultant in Newcastle upon Tyne

Communication Skills
Problem-Solving Skills
SQL
Python
API Integration
Data Engineering
Data Quality Assurance

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 Opencast, 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 Opencast. 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 Opencast

✨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 Opencast!

✨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.