Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design, develop, and maintain our internal Data Warehouse for actionable insights.
- Company: Join a global leader in data intelligence, transforming businesses with innovative solutions.
- Benefits: Enjoy hybrid working, competitive salary, 25 days leave, healthcare, and career progression.
- Why this job: Be part of a dynamic team shaping the future of data-driven decision-making.
- Qualifications: Bachelor's in Computer Science or related field; experience with SQL, ETL processes, and Azure services.
- Other info: Diversity is valued; Microsoft certifications and Power BI experience are a plus.
The predicted salary is between 36000 - 60000 £ per year.
Join our Cardiff Bay team as a Data Warehouse Developer within the Cardiff office. You are expected, if successful, to work 50% of the week in the office. We deliver valuable intelligence on customers, suppliers, and potential buyers to corporates, public sector organisations, and SMEs globally. Our team is responsible for designing, developing, and maintaining the company's internal Data Warehouse, ensuring high-quality, structured data for business intelligence and reporting.
We integrate data from Dynamics 365 (CE & F&O) and other sources, building efficient data structures to support analytical insights. By developing and optimizing ETL/ELT pipelines, we ensure data accuracy, consistency, and performance across the warehouse. Leveraging Azure Data Services such as Synapse, Data Factory, and SQL Server, we provide scalable solutions that enable stakeholders to make data-driven decisions. We create clear, easy-to-read Power BI dashboards, transforming complex data into visually compelling, actionable insights for business users. We also enforce data governance, security, and best practices, ensuring our warehouse remains a trusted source for enterprise-wide reporting and analytics.
We are seeking a skilled Data Warehouse Developer to design, build, and maintain an internal data warehouse using the Kimball methodology. The ideal candidate will have expertise in creating fact and dimension tables, ETL processes, and ensuring data integrity.
- Design and implement a Kimball-style data warehouse architecture, including fact and dimension tables.
- Develop and optimize ETL/ELT pipelines to integrate data from Dynamics 365 (CE & F&O) and other sources.
- Ensure data quality, consistency, and performance across the warehouse.
- Work with Azure Data Services (Synapse, Data Factory, Data Lake, SQL DB, etc.).
- Implement data governance, security, and best practices for the warehouse.
- Develop and maintain documentation on data models, processes, and business rules.
Data Warehousing:
- Experience in designing and implementing data models for analytical reporting.
ETL/ELT & Data Integration:
- Azure Data Factory, SSIS, or other data integration tools.
- Experience handling incremental data loads, data transformations, and data cleansing.
Databases & Querying:
- Proficiency in SQL Server, T-SQL, and performance tuning for data warehouses.
- Experience working with Azure Synapse Analytics, Azure SQL DB, or similar cloud-based platforms.
Microsoft Dynamics 365 (Desirable):
- Familiarity with Dynamics 365 Customer Engagement (CE) and Finance & Operations (F&O) data structures.
Bachelor's degree in Computer Science, Data Engineering, or related field. Microsoft certifications in Azure or Dynamics 365 are a plus. Experience with Power BI or other visualization tools.
Competitive Salary. Company Laptop supplied. 25 Days Annual Leave (plus bank holidays). Hybrid working model. Healthcare & Company Pension. Cycle to work and Wellbeing Programme. Global Company gatherings and events. E-learning and excellent career progression opportunities. Creditsafe is an equal opportunities employer that values diversity.
Data Warehouse Engineer - Hybrid employer: Creditsafe
Contact Detail:
Creditsafe Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Engineer - Hybrid
✨Tip Number 1
Familiarise yourself with the Kimball methodology, as it's a key requirement for this role. Understanding how to design fact and dimension tables will give you a significant edge during discussions with our team.
✨Tip Number 2
Brush up on your skills with Azure Data Services, particularly Synapse and Data Factory. Being able to demonstrate your experience with these tools will show us that you're ready to hit the ground running.
✨Tip Number 3
Prepare to discuss your experience with ETL/ELT processes in detail. We want to hear about specific projects where you've optimised data pipelines and ensured data quality, so think of examples to share.
✨Tip Number 4
If you have experience with Microsoft Dynamics 365, make sure to highlight it. Familiarity with its data structures can set you apart from other candidates and align you closely with our needs.
We think you need these skills to ace Data Warehouse Engineer - Hybrid
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data warehousing, ETL processes, and Azure Data Services. Use keywords from the job description to demonstrate your fit for the role.
Craft a Compelling Cover Letter: In your cover letter, explain why you are passionate about data warehousing and how your skills align with the company's mission. Mention specific projects or experiences that showcase your expertise in designing and implementing data models.
Showcase Technical Skills: Clearly outline your proficiency in SQL Server, T-SQL, and any experience with Azure Synapse Analytics or Dynamics 365. Providing examples of past projects where you optimised ETL/ELT pipelines can strengthen your application.
Highlight Soft Skills: Don't forget to mention soft skills such as teamwork, communication, and problem-solving. These are crucial for collaborating with stakeholders and ensuring data governance within the team.
How to prepare for a job interview at Creditsafe
✨Know Your Data Warehousing Basics
Make sure you brush up on the fundamentals of data warehousing, especially the Kimball methodology. Be prepared to discuss how you would design fact and dimension tables, as well as your experience with ETL processes.
✨Familiarise Yourself with Azure Services
Since the role involves working with Azure Data Services, it’s crucial to understand tools like Synapse, Data Factory, and SQL Server. Be ready to share specific examples of how you've used these technologies in past projects.
✨Showcase Your SQL Skills
Proficiency in SQL Server and T-SQL is key for this position. Prepare to demonstrate your ability to write complex queries and discuss any performance tuning techniques you've employed in previous roles.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving skills in data integration and governance. Think about challenges you've faced in previous roles and how you overcame them, particularly regarding data quality and consistency.
