Data Warehouse Developer

Job Title: Data Warehouse Developer

Location: Cardiff,

Department: Business Intelligence Internal Apps

Data Warehouse Developer – Cardiff Bay (Hybrid, 50% in-office)

Join our Cardiff Bay-based team as a Data Warehouse Developer, contributing to the design, development, and support of internal data systems that enable business-wide insights. This hybrid role involves working from our Cardiff office at least 50% of the time.

🌍 About Creditsafe

Privately owned and independently minded, Creditsafe empowers organisations worldwide to make better business decisions. Since our start in Oslo in 1997, we’ve worked to make business information accessible to companies of all sizes—driven by innovation, connected data, and AI-powered insights.

Today, our services help turn complex data into actionable intelligence for risk management, growth, and long-term resilience. We are proud to foster a culture where people can be themselves, thrive professionally, and feel part of a global community.

🤝 The Team

Our team builds and manages the company’s internal Data Warehouse—supporting high-quality business intelligence and reporting across the organisation. We integrate data from Dynamics 365 (CE & F&O) and other sources, optimising pipelines and structures for performance and clarity.

We work with Azure services including Synapse, Data Factory, Data Lake, and SQL DB. Our goal is to turn complex datasets into meaningful, accessible insights using Power BI, while upholding best practices in governance, security, and scalability.

🧭 Your Role

As a Data Warehouse Developer, you will design and maintain data solutions using the Kimball methodology. You will build scalable ETL/ELT pipelines, contribute to reporting strategy, and support data consistency across platforms.

🛠️ Key Responsibilities

Design and implement Kimball-style data models, including fact and dimension tables.
Develop and optimise ETL/ELT pipelines (e.g., Azure Data Factory, SSIS).
Integrate data from sources such as Dynamics 365 (CE & F&O).
Collaborate with stakeholders to define reporting metrics and business needs.
Ensure consistency, accuracy, and performance across data layers.
Apply data governance and security best practices.
Use Azure Data Services to build scalable, reliable pipelines.
Document data models, processes, and business rules clearly.

(Please note this is not an exhaustive list of responsibilities.)

🧠 Skills & Experience

We value skills and experience gained in both traditional and non-traditional ways. You’ll ideally bring:

💡 Technical Skills

Strong understanding of the Kimball methodology and data warehousing best practices.
Experience with SQL Server, T-SQL, and performance tuning for large datasets.
Practical knowledge of Azure Synapse Analytics, Azure SQL DB, and cloud-based platforms.
Hands-on experience with ETL/ELT tools (e.g., Azure Data Factory, SSIS).
Ability to manage data transformations, incremental loads, and data quality.

🔄 Integration Experience

Familiarity with Microsoft Dynamics 365 (CE and F&O), Dataverse, and OData is beneficial.

💬 Communication & Collaboration

Ability to explain technical concepts to non-technical colleagues.
Strong analytical and problem-solving skills.
Comfortable working independently and as part of a team.

🎓 Preferred (but not required)

Bachelor’s degree in computer science, data engineering, or related field—or equivalent experience.
Microsoft Azure or Dynamics 365 certifications.
Experience creating dashboards in Power BI or similar tools.

💬 Accessibility & Adjustments

We are happy to make adjustments at any stage of the recruitment process to support your needs—please let us know what works best for you. This could include:

Extra time or flexibility during interviews
Screen reader-accessible formats
Written rather than verbal communication
Remote options for assessments