Apply Recruitment
Senior Data Architect
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Architect (Interim) – Remote – 6 Months (UK-Based) – Strong BI Background
About the Role
This interim Data Architect role is critical to design an end-to-end Data & BI solution for an M&A (mergers & acquisitions) carve-out programme, involving integration across multiple organisations with diverse ERP systems—primarily Microsoft Dynamics and SAP.
The final organisation is committed to a Microsoft-focused (Dynamics) platform, requiring seamless transition and consolidation.
Key Responsibilities
Data & BI Solution Design
References three distinct organisations, overseeing:
-
Data Sources
- ERP systems (Dynamics, SAP)
- Legacy systems
- External sources
-
Data Flows & Integrations
- Define architecture, patterns, and governance
- Ensure consistency across fragmented systems
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
- Data Model
- Develop logical and physical data models
- Align with enterprise BI strategy & roadmap
Data Architecture & Modelling
- Define data structures (facts, dimensions, hierarchies)
- Establish a single source of truth for:
- Master data
- Golden datasets
- Ensure cross-system consistency (e.g., ERP alignment)
Data Integration & ETL/ELT
- Design reliable ETL/ELT pipelines
- Govern integration patterns via:
- APIs
- Flat files
- Staging layers
- Optimise data ingestion and transformation
Reporting & Analytics Design
- Build reporting architecture:
- Power BI dashboards
- Data marts
- Define KPIs & business metrics, tailored to:
- Business processes (sales, finance, operations)
- Technical oversight (interfaces, errors, integration health)
- Prioritise:
- Scalability
- Performance
- Business alignment
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Data Governance, Quality & Security
- Define data standards and validation rules
- Implement reconciliation logic
- Ensure:
- Governance (ownership, stewardship)
- Security (access controls, GDPR compliance)
- Data accuracy
Documentation & Handover to Business-as-Usual (BAU)
- Develop a data dictionary
- Train support teams
- Transfer ownership of operational reporting post-wrap
Emphasis on: M&A carve-outs, Microsoft Dynamics-first alignment, end-to-end BI governance. (Critical interim role.)
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location