Data Warehouse Engineer

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.

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.

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.

Creditsafe is an equal opportunities employer that values diversity. Please contact Creditsafe if there is any support you need with your application.