Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and maintain a data warehouse, ensuring high-quality data for business insights.
- Company: Creditsafe empowers businesses with accessible data intelligence since 1997, revolutionising decision-making.
- Benefits: Enjoy a competitive salary, hybrid work, 25 days leave, healthcare, and career growth opportunities.
- Why this job: Join a dynamic team, work with cutting-edge technology, and make a real impact on business decisions.
- Qualifications: Strong knowledge of data warehousing, ETL processes, and proficiency in SQL Server required.
- Other info: Flexible working model with a supportive company culture that values diversity.
The predicted salary is between 36000 - 60000 £ per year.
Join our Cardiff Bay team as a Data Warehouse Engineer within the Cardiff office. You are expected, if successful, to work 50% of the week in the office.
WHO ARE WE?
Privately owned and independently minded, Creditsafe operates with the singular vision of powering business decisions. We do this by delivering valuable intelligence on customers, suppliers and potential buyers to corporates, public sector organisations and SMEs globally.
Our journey began in 1997 in Oslo, Norway, with a revolutionary dream to make business information accessible to all. Twenty-five years later, we’ve not only realised this dream, changed the market for the better, made data intelligence accessible to all businesses big and small but most importantly, opened up new avenues of data intelligence for businesses with machine learning, AI and connected data.
From risk management through to opportunity identification, our industry-leading solutions power decisions for companies by turning their data into actionable insights that help them become stronger, grow faster and thrive.
THE TEAM
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.
JOB PROFILE
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. Experience with Dynamics 365 CE & F&O is highly desirable.
KEY DUTIES AND RESPONSIBILITIES
- 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.
- Collaborate with business stakeholders to define key business metrics and reporting needs.
- Ensure data quality, consistency, and performance across the warehouse.
- Work with Azure Data Services (Synapse, Data Factory, Data Lake, SQL DB, etc.) to build scalable solutions.
- Implement data governance, security, and best practices for the warehouse.
- Develop and maintain documentation on data models, processes, and business rules.
SKILLS AND QUALIFICATIONS
- Data Warehousing: Strong knowledge of the Kimball methodology (star schema, fact & dimension tables). Experience in designing and implementing data models for analytical reporting.
- ETL/ELT & Data Integration: Hands-on experience with ETL tools (e.g., 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. Experience with Dataverse, OData, or direct integrations with Dynamics 365 APIs.
- Soft Skills: Strong problem-solving and analytical thinking. Ability to communicate technical concepts to business users. Self-motivated and capable of working both independently and in a team.
Preferred Qualifications:
- 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.
BENEFITS
- 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.
- Plus more that can be found on the benefits section on the Careers page.
Creditsafe is an equal opportunities employer that values diversity. Please contact Creditsafe if there is any support you need with your application.
Data Engineer (Warehouse) (Cardiff) employer: Creditsafe
Contact Detail:
Creditsafe Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer (Warehouse) (Cardiff)
✨Tip Number 1
Familiarise yourself with the Kimball methodology, as it's crucial for this role. Understanding how to design fact and dimension tables will give you a significant edge during interviews.
✨Tip Number 2
Brush up on your ETL/ELT skills, particularly with Azure Data Factory. Being able to discuss your experience with data integration tools will demonstrate your hands-on expertise.
✨Tip Number 3
Make sure you can articulate your experience with SQL Server and T-SQL. Highlighting your proficiency in performance tuning for data warehouses will show that you can optimise data processes effectively.
✨Tip Number 4
If you have experience with Microsoft Dynamics 365, be ready to discuss it. Understanding its data structures and how they integrate with data warehouses will set you apart from other candidates.
We think you need these skills to ace Data Engineer (Warehouse) (Cardiff)
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 engineering and how your skills align with Creditsafe's mission. Mention specific projects or experiences that showcase your expertise in the Kimball methodology and Dynamics 365.
Showcase Technical Skills: Clearly outline your technical skills related to SQL Server, T-SQL, and ETL tools like Azure Data Factory. Provide examples of how you've used these skills in previous roles to solve problems or improve processes.
Highlight Soft Skills: Don't forget to mention your soft skills, such as problem-solving and communication abilities. Explain how these skills have helped you collaborate with stakeholders or present complex data insights effectively.
How to prepare for a job interview at Creditsafe
✨Understand the Kimball Methodology
Make sure you have a solid grasp of the Kimball methodology, especially star schemas and fact & dimension tables. Be prepared to discuss how you've applied this in previous projects or how you would approach it in the role.
✨Showcase Your ETL/ELT Experience
Highlight your hands-on experience with ETL tools like Azure Data Factory or SSIS. Be ready to explain specific challenges you've faced in data integration and how you overcame them.
✨Familiarise Yourself with Dynamics 365
If you have experience with Dynamics 365 CE & F&O, make sure to mention it. Discuss how you’ve worked with its data structures and any integrations you've implemented, as this is highly desirable for the role.
✨Prepare for Technical Questions
Expect technical questions related to SQL Server, T-SQL, and performance tuning. Brush up on these topics and be ready to demonstrate your problem-solving skills through practical examples.
