Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop data warehouses to support analytics and reporting.
- Company: Join a forward-thinking tech company with a collaborative culture.
- Benefits: Enjoy 25 days holiday, medical insurance, and a share scheme.
- Why this job: Make an impact by optimising data solutions and driving business insights.
- Qualifications: Experience in data warehousing, SQL, and Power BI is essential.
- Other info: Remote work with opportunities for professional growth and learning.
The predicted salary is between 28800 - 48000 £ per year.
This range is provided by assimil8. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range
BI & Data Warehouse Developer. (Remote, UK)
Location: Remote UK – Rare site work required. (Birmingham / Northwest preferred)
Start: As soon as possible
Reports to: Head of Consulting
What you\\\’ll do
As a BI & Data Warehouse Developer you will:
- Design, develop, and maintain data warehouses and/or data lakes to support business intelligence, analytics, and reporting.
- Build scalable ETL / ELT pipelines, data models, and data integration solutions pulling from various sources (e.g. transactional databases, APIs, flat files, etc.).
- Create well-designed, performant BI dashboards, reports, and visualisations that deliver insight for internal stakeholders and/or clients.
- Ensure data quality, consistency, accuracy, and adherence to best practices (data governance, metadata, lineage, etc.).
- Optimise data storage and query performance within the data warehouse / lake environment.
- Liaise with business stakeholders to understand requirements, clarify reporting needs, translate those into technical specifications.
- Monitor and troubleshoot data pipeline issues, ensuring reliability and timeliness of data delivery.
- Stay up to date with relevant technologies, tools, and best practices; suggest improvements and optimisation.
- Communication skills essential for: Project updates, Technical solution discussions, working with all levels of business internal and external, technical and non-technical.
The ideal candidate
You should have:
- UK Based Full Time person needed. Permanent Role.
- Must have data warehouse experience and background for multiple client development projects.
- Significant experience (typically 5 years) in building data warehouses / data lakes; experience with SQL, Azure Data Lake, AWS Lake, or similar for end to end development, migration projects, management and maintenance.
- Must have Power BI report authoring experience across a number of business disciplines and development projects.
- Skill range with Power BI Desktop and Server covering reporting, visualisation, DAX, sandboxing, publishing / sharing / performance tuning. Power Apps a bonus.
- Must have strong communication and presentation skills.
- End to End understanding from project analysis through to project delivery and support.
- Hands-on experience with ETL/ELT tools & techniques (e.g. Azure SQL, Data Factory, AWS Glue, SQL Server Integration Services, Databricks, or similar).
- Attention to detail and data accuracy.
- Good SQL skills, including query optimisation, writing complex joins, aggregations
- Working knowledge of data modeling: star/snowflake schemas, slowly changing dimensions, etc.
- Experience with data governance, version control, metadata, documentation, testing.
- Comfortable working in a remote setup, managing time effectively, writing clear documentation and communicating with stakeholders virtually.
- Curious mindset, with a willingness to learn new tools and grow with changing technology.
- Team-player attitude: collaborative, constructive feedback, ownership of work.
Bonus (but not required):
- AI exposure, experience
- Knowledge of Python, R, or other scripting languages for data processing.
- Familiarity with DevOps / CI/CD practices for data projects.
- Experience with cloud platforms (Azure, AWS, GCP) in operational / production settings.
- Exposure to big data technologies (e.g. Spark, Databricks, Hadoop).
What we offer (Perks & Benefits)
- 25 days paid holiday per year (plus bank holidays)
- Medical insurance
- Company share scheme – opportunity to share in the success of the business
- Opportunity for professional growth, training, and continuous learning
- Collaborative, supportive culture with regular feedback and open communication
Seniority level
- Mid-Senior level
Employment type
- Full-time
Job function
- Information Technology
- Industries: Data Infrastructure and Analytics, IT System Custom Software Development, and IT Services and IT Consulting
Referrals increase your chances of interviewing at assimil8 by 2x
Get notified about new Data Warehouse Engineer jobs in United Kingdom.
Data Engineer, On-Prem, SSIS, etc, Home Based, to £ 60000
Manchester, England, United Kingdom 3 weeks ago
London, England, United Kingdom 7 months ago
Python Engineer (Data) – AI – £90,000 – Remote (UK)
London, England, United Kingdom 1 day ago
London, England, United Kingdom 2 months ago
Edinburgh, Scotland, United Kingdom 7 months ago
London, England, United Kingdom 1 week ago
Greater London, England, United Kingdom 3 weeks ago
York, England, United Kingdom 2 months ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
BI & Data Warehouse Developer employer: assimil8
Contact Detail:
assimil8 Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI & Data Warehouse Developer
✨Tip Number 1
Network like a pro! Reach out to your connections in the BI and data space. Attend meetups or webinars, and don’t be shy about asking for introductions. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best BI dashboards and data models. This is your chance to shine and demonstrate what you can bring to the table. Make sure to include links to any projects you've worked on!
✨Tip Number 3
Prepare for interviews by brushing up on your technical skills. Be ready to discuss your experience with SQL, ETL processes, and data governance. Practise explaining complex concepts in simple terms – communication is key!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive and engaged. So, get that application in and let’s get the ball rolling!
We think you need these skills to ace BI & Data Warehouse Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the BI & Data Warehouse Developer role. Highlight your relevant experience with data warehouses, ETL processes, and Power BI. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data and how your background makes you a great fit for our team. Keep it concise but impactful – we love a good story!
Show Off Your Projects: If you've worked on any cool data projects, don’t hesitate to mention them! Whether it's a data lake you built or a dashboard that wowed stakeholders, we want to hear about it. Real-world examples can really make your application stand out.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us you're keen and ready to join our awesome team at StudySmarter!
How to prepare for a job interview at assimil8
✨Know Your Tech Inside Out
Make sure you brush up on your knowledge of data warehousing, ETL/ELT tools, and SQL. Be ready to discuss your experience with Azure Data Lake, AWS Lake, and Power BI in detail. Prepare examples of past projects where you’ve built data models or optimised query performance.
✨Showcase Your Communication Skills
Since this role involves liaising with both technical and non-technical stakeholders, practice explaining complex concepts in simple terms. Think of scenarios where you’ve successfully communicated project updates or clarified requirements, and be ready to share those during the interview.
✨Demonstrate Your Problem-Solving Ability
Prepare to discuss how you've monitored and troubleshot data pipeline issues in the past. Have a couple of specific examples ready that highlight your analytical skills and attention to detail, especially when it comes to ensuring data quality and accuracy.
✨Stay Curious and Open to Learning
The tech landscape is always changing, so show your enthusiasm for learning new tools and technologies. Mention any recent courses or certifications you’ve completed, and be prepared to discuss how you keep up with industry trends and best practices.