At a Glance
- Tasks: Design and develop scalable data transformations and pipelines for a modern BI environment.
- Company: A growing, data-driven organisation investing in technology and analytics.
- Benefits: Flexible hybrid working, professional development, and a comprehensive benefits package.
- Other info: Join a dynamic team focused on delivering high-quality insights and governance.
- Why this job: Shape a cutting-edge BI function and work with modern data technologies.
- Qualifications: Experience in BI roles, strong SQL skills, and knowledge of Python and Spark.
The predicted salary is between 45000 - 55000 £ per year.
We're partnering with a growing, data-driven organisation that is investing heavily in its technology and analytics capabilities. As part of this journey, they are building out a modern Business Intelligence function to improve reporting accuracy, governance, and insight delivery across the business. This is an excellent opportunity for a Data Engineer who wants to move beyond dashboarding and play a key role in shaping a scalable, enterprise-grade BI environment.
You'll join a newly established BI team with a strong mandate to transform how data is modelled, governed, and consumed. Working across both data modelling and reporting layers, you'll help build robust data foundations that support executive decision-making. This role combines data engineering, data modelling, and reporting delivery - ideal for someone who enjoys working end-to-end within the BI lifecycle.
Key Responsibilities- Design and develop scalable data transformations using modern cloud technologies
- Design, build and optimise scalable data pipelines to ingest, transform and load data from multiple source systems into a centralised data platform
- Build and maintain performant star-schema data models aligned to business definitions
- Develop and enhance dashboards and certified data sources for business stakeholders
- Support governance initiatives including data definitions, documentation, and lineage
- Collaborate with technical and non-technical stakeholders to deliver high-quality insights
- Proven experience in a BI / Data role
- Strong SQL skills and experience working with large datasets
- Hands-on experience with Python and Spark
- Experience designing dimensional models
- Experience with BI tools, Tableau or Power BI
- Understanding of data warehousing concepts
- Strong stakeholder engagement and communication skills
- Opportunity to shape a growing BI function from the ground up
- Exposure to modern data technologies and cloud platforms
- Strong focus on professional development and certifications
- Flexible hybrid working
- Comprehensive benefits package
Data Engineer employer: Jefferson Frank
Join a forward-thinking organisation in Durham that prioritises innovation and professional growth, offering Data Engineers the chance to shape a cutting-edge Business Intelligence function. With a strong emphasis on flexible hybrid working, comprehensive benefits, and access to modern data technologies, this company fosters a collaborative work culture where your contributions directly impact executive decision-making and organisational success.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data engineering projects, especially those involving SQL, Python, and BI tools like Tableau or Power BI. This will give you an edge and demonstrate your hands-on experience.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and soft skills. Be ready to discuss your experience with data modelling and governance initiatives, as well as how you've collaborated with stakeholders in the past.
✨Tip Number 4
Don’t forget to apply through our website! We’re always looking for talented individuals to join our growing BI team. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Engineer role. Highlight your experience with SQL, Python, and any BI tools you've used. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Share your passion for data engineering and how you can contribute to our growing BI function. Be sure to mention specific projects or experiences that relate to the job description.
Showcase Your Technical Skills:Don’t hold back on showcasing your technical skills! Include examples of data transformations you've designed or data pipelines you've built. We love seeing hands-on experience, especially with modern cloud technologies.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at Jefferson Frank
✨Know Your Data Stuff
Make sure you brush up on your SQL skills and be ready to discuss your experience with large datasets. Be prepared to talk about specific projects where you've designed data models or built data pipelines, as this will show your hands-on experience.
✨Showcase Your BI Knowledge
Familiarise yourself with the latest BI tools like Tableau or Power BI. If you've used them in past roles, have examples ready to share. This will demonstrate your ability to deliver high-quality insights and your understanding of the BI lifecycle.
✨Communicate Like a Pro
Since you'll be collaborating with both technical and non-technical stakeholders, practice explaining complex data concepts in simple terms. This will highlight your strong communication skills and your ability to engage effectively with diverse teams.
✨Emphasise Your Adaptability
The role involves working with modern cloud technologies, so be ready to discuss how you've adapted to new tools and environments in the past. Share examples of how you've embraced change and contributed to governance initiatives, as this aligns with the company's focus on building a robust BI function.
