Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop data warehouse solutions for dynamic BI dashboards and insightful reports.
- Company: Join a forward-thinking company driving digital transformation in data management.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Why this job: Be at the forefront of data innovation and make a real impact on business intelligence.
- Qualifications: Degree in Computer Science or equivalent experience; passion for data warehousing required.
- Other info: Fast-paced environment with a focus on collaboration and continuous learning.
The predicted salary is between 45000 - 55000 £ per year.
AMS is seeking a data-focused professional to join as a Data Warehouse Developer to support a digital transformation initiative. This role drives design, development, and implementation of our data warehouse solution to enable dynamic BI dashboards and insightful reports for stakeholders.
Responsibilities
- Collaborate with cross-functional teams and stakeholders to gather and translate requirements into effective technical solutions.
- Data Warehouse Design & Architecture - Design, develop, and implement secure, robust, and scalable data warehouse solutions and integrations by defining and executing the overall architecture, including schema design and storage structures.
- ETL/ELT Development - Build and maintain robust data extraction, transformation, and loading processes from multiple source systems.
- Data Modelling & Integration - Create and optimise dimensional models for analytics and reporting and integrate data sources into a unified, governed and secure repository.
- BI Development - Provide clean, analytics-ready datasets for BI tools by writing complex database queries, stored procedures, and functions that robustly support analytics and reporting needs.
- Data Governance - Ensure that data remains accurate, secure, compliant, and accessible to permitted users.
- Provide technical support for company forecasting.
- Performance Tuning & Maintenance - Conduct regular data health checks, capacity planning and monitoring performance & tuning for the warehouse & BI environments.
- Perform technical troubleshooting, root cause analysis, and consultation to ensure the smooth running of applications used within the AMS Group of companies, responding to technical problems in a timely manner.
- Work with external suppliers to resolve technical issues when required.
- Be an advocate for best practices with data.
- Ensure scalability, performance, and compliance with organisational standards.
- Create and update any relevant documentation associated with system changes.
- Proactively seek out areas for improvement and make recommendations to enhance BI capabilities and user experience.
Qualifications
- Degree in Computer Science, IT, or equivalent hands-on experience.
- Open mind and willingness to learn new technologies and support other systems and applications used within the AMS Group of companies.
- Passion for Data Warehousing.
- Experience with Data Warehousing Tools (Snowflake, Redshift, Databricks, Big Query, Fabric).
- Solid experience working with SQL-based databases (MS SQL and/or Oracle).
- Advanced SQL and/or PL/SQL skills.
- Experience working with data governance and data quality.
- Proven capability designing and maintaining ETL / ELT processes.
- Strong analytical and problem-solving mindset with attention to detail.
- Strong communication skills to effectively collaborate with technical and non-technical teams, and strong enough to say no to requests when necessary.
- A critical thinker, with ability to think both detail- and big-picture oriented and a 'can do' attitude.
- Strong experience with BI reporting technologies (Qlik Sense, Power BI, or Tableau).
- Ability to manage multiple priorities in a fast-paced environment.
- Python.
- Understanding of Firewalls and IT Security.
Nice to Have Skills
- Language Skills, especially French and German.
- Data Science Skills; R, statistical analyses.
Data Warehouse Architect in England employer: Advanced Medical Solutions
Contact Detail:
Advanced Medical Solutions Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Architect in England
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the data warehousing game. You never know who might have a lead on your dream job!
✨Show Off Your Skills
Don’t just tell them you’re great at SQL or ETL processes—show them! Create a portfolio of projects or case studies that highlight your skills. This can really set you apart from the crowd when you’re chatting with potential employers.
✨Ace the Interview
Prepare for those interviews by practising common questions and scenarios related to data warehousing. Think about how you’d tackle real-world problems and be ready to discuss your thought process. Confidence is key!
✨Apply Through Our Website
We’ve got some fantastic opportunities waiting for you! Make sure to apply through our website to get the best chance at landing that Data Warehouse Architect role. We’re excited to see what you bring to the table!
We think you need these skills to ace Data Warehouse Architect in England
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Warehouse Architect role. Highlight your experience with data warehousing tools and SQL databases, as well as any relevant projects that showcase your skills in ETL/ELT development.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data warehousing and how your background aligns with our needs. Don’t forget to mention your willingness to learn new technologies!
Showcase Your Problem-Solving Skills: In your application, give examples of how you've tackled complex data challenges in the past. We love candidates who can think critically and come up with innovative solutions, so don’t hold back!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team!
How to prepare for a job interview at Advanced Medical Solutions
✨Know Your Data Warehousing Tools
Make sure you’re familiar with the specific data warehousing tools mentioned in the job description, like Snowflake or Redshift. Brush up on your SQL skills and be ready to discuss how you've used these tools in past projects.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data challenges in previous roles. Be ready to explain your thought process and the steps you took to resolve issues, especially around ETL/ELT processes.
✨Communicate Effectively
Since this role involves collaboration with both technical and non-technical teams, practice explaining technical concepts in simple terms. This will demonstrate your strong communication skills and ability to bridge gaps between different stakeholders.
✨Be Ready for Technical Questions
Expect to face technical questions related to data governance, performance tuning, and BI reporting technologies. Prepare by reviewing common scenarios and best practices, so you can confidently discuss how you would handle various situations.