At a Glance
- Tasks: Manage and optimise the central data warehouse while developing SQL queries and Power BI dashboards.
- Company: Join a well-established organisation in Newark, known for its collaborative and technically strong environment.
- Benefits: Enjoy a competitive salary and the chance to shape data strategy from day one.
- Why this job: This role offers hands-on experience with diverse ERP systems and impactful data insights.
- Qualifications: Strong SQL skills, experience with Power BI, and familiarity with ERP systems are essential.
- Other info: Ideal for those ready to take ownership and influence reporting strategies.
The predicted salary is between 35000 - 38000 £ per year.
A well-established organisation in the Newark area is seeking a Data Warehouse Engineer to take ownership of its centralised data platform. With a current team member transitioning out at the end of July, this role is ideal for someone confident in SQL, data warehousing, and Power BI, who can hit the ground running in a collaborative, technically strong environment.
You will join a close-knit data team and work alongside a colleague focused on reporting to deliver meaningful insights and maintain a robust, scalable data infrastructure. This position offers exposure to a wide range of ERP systems and an opportunity to shape the business's approach to data and reporting.
Key Responsibilities:- Manage and maintain the central data warehouse across multiple ERP platforms
- Develop and optimise SQL queries to support reporting and data access
- Build and maintain Power BI dashboards and visualisations
- Collaborate with internal teams to understand reporting needs and translate them into data solutions
- Ensure consistency, accuracy, and performance across data pipelines and warehouse models
- Document and maintain clear data flows, models, and reporting logic
- Strong experience with SQL (writing queries from scratch)
- Proven ability to manage and optimise data warehouse environments
- Hands-on experience with Power BI and related tools (e.g. DAX, Power Query)
- Familiarity with ERP systems and large-scale, varied data sources
- Some background in reporting and BI delivery
- Excellent communication and problem-solving skills
This is a great opportunity for someone looking to take real ownership in a technically strong team, with the ability to directly influence reporting and data strategy from day one.
Data Warehouse engineer employer: SF Recruitment (Tech)
Contact Detail:
SF Recruitment (Tech) Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse engineer
✨Tip Number 1
Familiarise yourself with the specific ERP systems mentioned in the job description. Understanding how these systems interact with data warehousing will give you an edge during interviews and show your proactive approach.
✨Tip Number 2
Brush up on your SQL skills, especially writing queries from scratch. Consider working on sample projects or contributing to open-source data projects to demonstrate your capabilities and confidence in SQL.
✨Tip Number 3
Gain hands-on experience with Power BI by creating your own dashboards. This practical knowledge will not only enhance your skills but also provide you with concrete examples to discuss during your interview.
✨Tip Number 4
Prepare to discuss your problem-solving skills and how you've collaborated with teams in the past. Think of specific examples where you translated reporting needs into data solutions, as this aligns closely with the role's responsibilities.
We think you need these skills to ace Data Warehouse engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL, data warehousing, and Power BI. Use specific examples of projects or tasks where you've successfully managed data environments or created dashboards.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your skills align with the key responsibilities listed in the job description, particularly your ability to manage data warehouses and collaborate with teams.
Showcase Relevant Projects: If you have worked on relevant projects, consider including a portfolio or a brief description of these projects in your application. Highlight any specific achievements related to SQL queries, Power BI dashboards, or data reporting.
Proofread Your Application: Before submitting, carefully proofread your application materials. Check for any spelling or grammatical errors, and ensure that all information is clear and concise. A polished application reflects your attention to detail.
How to prepare for a job interview at SF Recruitment (Tech)
✨Showcase Your SQL Skills
Be prepared to discuss your experience with SQL in detail. You might be asked to write queries on the spot, so brush up on your skills and think about specific examples where you've optimised queries or solved complex data problems.
✨Demonstrate Power BI Proficiency
Since Power BI is a key part of the role, be ready to talk about your experience with it. Bring examples of dashboards you've created and be prepared to explain your thought process behind the visualisations and how they met reporting needs.
✨Understand the Business Context
Research the company and its industry to understand their data needs. This will help you tailor your answers to show how your skills can directly benefit their operations and reporting strategies.
✨Prepare for Collaboration Questions
As this role involves working closely with internal teams, think of examples that highlight your teamwork and communication skills. Be ready to discuss how you've collaborated on projects and resolved conflicts in a team setting.