Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform complex data into insights and build robust data pipelines.
- Company: Join Core-Asset Consulting, a leader in financial services recruitment.
- Benefits: Enjoy a competitive salary and a comprehensive benefits package.
- Why this job: Be part of an innovative team driving strategic business decisions with data.
- Qualifications: Proficiency in T-SQL, Spark, Azure, and strong analytical skills required.
- Other info: Open to all applicants; commitment to diversity and inclusion.
The predicted salary is between 28800 - 48000 £ per year.
Core-Asset Consulting is delighted to be partnering with a highly respected financial service firm to recruit a Data Engineer for a permanent position based in Newcastle. This is a fantastic opportunity to join an organisation with a clear commitment to innovation and insight-led decision-making.
As a Data Engineer, you will play a critical role in transforming complex operational data into meaningful insights. Working across analytics, data science, and development teams, you will design and implement robust data pipelines, optimise data models, and ensure high-quality, reliable outputs that drive strategic business decisions.
Essential Skills/Experience:
- Strong proficiency in T-SQL and experience developing complex queries and procedures.
- Expertise in Spark and PySpark for scalable data processing.
- Solid understanding of OLTP and OLAP architectures and data modelling principles.
- Experience with Microsoft Azure, including Fabric, Azure Data Factory, Data Lake, Data Warehouse, and Blob Storage.
- Sound knowledge of ETL/ELT best practices.
- Strong analytical and problem-solving skills with a focus on data accuracy and reliability.
- Excellent collaboration and communication skills, with the ability to translate business requirements into technical solutions.
- Comfortable working in dynamic environments and committed to continuous improvement.
Core Responsibilities:
- Translate complex transactional data into optimised analytical models (facts and dimensions) to support reporting and insights.
- Design, build, and enhance data pipelines within Microsoft Fabric to improve performance, scalability, and data quality.
- Engineer new integrations from internal and external data sources using best-practice ETL/ELT methodologies.
- Monitor and optimise SQL-based workflows to ensure accuracy and efficiency in daily data processing.
- Lead efforts to migrate legacy reporting datasets to modern platforms, ensuring minimal disruption.
- Collaborate with analytics teams to develop custom data models and engineered datasets tailored to business requirements.
- Partner with data science colleagues to create summary and aggregated datasets for advanced analytics and predictive modelling.
- Respond efficiently to ad hoc data requests, ensuring outputs are timely, accurate, and aligned to stakeholder needs.
Benefits:
- A highly competitive salary
- Wider Benefits package
Core-Asset Consulting is an equal opportunities recruiter and we welcome applications from everyone irrespective of age, disability, gender, gender identity or expression, race, colour, ethnic or national origin, sexual orientation, religion or belief, marital/civil partner status or pregnancy.
To apply for this vacancy applicants must be eligible to work in the UK in accordance with the Immigration, Asylum and Nationality Act 2006.
Data Engineer employer: Core-Asset Consulting
Contact Detail:
Core-Asset Consulting Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, such as T-SQL, Spark, and Microsoft Azure. Having hands-on experience or projects showcasing these skills can set you apart during the interview process.
✨Tip Number 2
Prepare to discuss your previous experiences with data pipelines and ETL/ELT methodologies. Be ready to provide examples of how you've optimised data models or improved data quality in past roles, as this will demonstrate your practical knowledge.
✨Tip Number 3
Showcase your collaboration skills by preparing examples of how you've worked with analytics or data science teams in the past. Highlighting your ability to translate business requirements into technical solutions will resonate well with the hiring team.
✨Tip Number 4
Research the company’s commitment to innovation and insight-led decision-making. Being able to articulate how your skills align with their goals and values during the interview can significantly enhance your chances of landing the job.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with T-SQL, Spark, and Azure. Use specific examples to demonstrate your skills in data modelling and ETL/ELT best practices.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your background aligns with their commitment to innovation and insight-led decision-making.
Showcase Relevant Projects: If you have worked on projects involving data pipelines or analytics, include these in your application. Describe your role and the impact of your work on business decisions.
Highlight Soft Skills: Don’t forget to mention your collaboration and communication skills. Provide examples of how you've successfully translated business requirements into technical solutions in previous roles.
How to prepare for a job interview at Core-Asset Consulting
✨Showcase Your Technical Skills
Be prepared to discuss your proficiency in T-SQL, Spark, and PySpark. Bring examples of complex queries you've developed or data pipelines you've designed, as this will demonstrate your hands-on experience and technical expertise.
✨Understand Data Modelling Principles
Familiarise yourself with OLTP and OLAP architectures, as well as data modelling principles. Be ready to explain how you would translate complex transactional data into optimised analytical models, which is a key responsibility of the role.
✨Emphasise Collaboration Skills
Since the role involves working closely with analytics and data science teams, highlight your collaboration and communication skills. Prepare examples of how you've successfully translated business requirements into technical solutions in previous roles.
✨Demonstrate Problem-Solving Abilities
Prepare to discuss specific challenges you've faced in data processing and how you resolved them. This will showcase your analytical skills and your commitment to ensuring data accuracy and reliability, which are crucial for the position.
