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