Data Warehouse Engineer

JR United Kingdom; Newport; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading company in data intelligence is seeking a Data Warehouse Developer to join their Cardiff Bay team. The successful candidate will leverage their expertise in data warehousing to design, build, and maintain an internal data warehouse using the Kimball methodology. Candidates will also utilize Azure Data Services to create scalable solutions and optimize ETL processes, enabling data-driven decision-making for stakeholders. The role offers flexibility, requiring 50% of the work to be completed in the office.

Benefits

Company Laptop supplied

Cycle to work and Wellbeing Programme

Global Company gatherings and events

E-learning and excellent career progression opportunities

Qualifications

• Expertise in the Kimball methodology and data models for analytics.
• Hands-on experience with ETL tools, particularly Azure Data Factory.
• Proficiency in SQL Server and performance tuning in data warehouses.

Responsibilities

• Design and implement a data warehouse architecture using Kimball methodology.
• Develop and optimize ETL/ELT pipelines for data integration.
• Collaborate with stakeholders to define reporting metrics.

Skills

SQL Server

ETL processes

Data Warehousing

Logic & Analytical Thinking

Education

Bachelor's degree in Computer Science

Tools

Azure Data Factory

Power BI

Job description

Social network you want to login/join with:

Join our Cardiff Bay team, as an 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 in 1997, 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.

**Please note that the responsibilities listed above are not exhaustive.

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.
• 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

• Company Laptop supplied.
• 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, https://careers.creditsafe.com/gb.

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