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.
We do this by delivering valuable intelligence on customers, suppliers and potential buyers to corporates, public sector organisations and SMEs globally.
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.
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.