Skip to content
1. Base DataViews & DataMart Architecture
- Owner: Senior Data Engineer
- Responsibilities:
- Manage data architecture and base tables.
- Optimise database performance and partitioning.
- Design and maintain data pipelines to ensure proper flow to the warehouse.
2. CRM and Transactional Data
- Owner: Head of Reporting (in partnership with Senior Data Engineer)
- Responsibilities:
- Manage CRM data and ensure consistent capture.
- Collaborate with Data Engineer to align CRM insights with downstream systems.
3. Data Security and Governance
- Owner: Data Governance Manager
- Responsibilities:
- Implement data security policies and ensure compliance.
- Manage role-based access controls (RBAC) and data lineage.
- Maintain data quality standards and governance compliance.
4. Signposting of Insights
- Owner: Head of Reporting
- Responsibilities:
- Communicate insights effectively to the business.
- Collaborate on dashboards and reporting, ensuring clarity and usability.
5. Metadata and Data Lineage
- Owner: Data Governance Manager (with Senior Data Engineer’s support)
- Responsibilities:
- Maintain clear metadata and data lineage for transparency.
- Ensure understanding of data sources and transformations across teams.
6. Master Data Management (MDM)
- Owner: Data Governance Manager
- Responsibilities:
- Ensure a “single source of truth” for master data (e.g., customer records).
- Eliminate duplicate records and manage entity consistency across systems.
7. ETL/ELT and Data Integration Processes
- Owner: Senior Data Engineer
- Responsibilities:
- Manage and optimise ETL/ELT processes for data ingestion from various sources.
- Ensure efficient data integration with governance and security compliance.
8. Analytics and Data Modelling
- Owner: Senior Data Engineer (in collaboration with analysts/data scientists)
- Responsibilities:
- Develop advanced analytics models and data modelling structures (e.g., star schemas).
- Ensure insights align with governance standards.
9. Data Lifecycle Management & Archiving
- Owner: Data Governance Manager (in collaboration with IT)
- Responsibilities:
- Define and implement data retention, archiving, and deletion policies.
- Ensure lifecycle management is compliant and does not compromise access.
10. Data Quality and Stewardship
- Owner: Data Governance Manager (with support from data stewards)
- Responsibilities:
- Assign data stewards to ensure quality at the source.
- Implement data quality checks and monitoring.
11. Real-Time Data Processing & Streaming
- Owner: Senior Data Engineer
- Responsibilities:
- Set up real-time data processing for immediate insights where necessary.
- Implement streaming data pipelines and integrate them with batch data.
12. Data Visualisation and User Experience (UX)
- Owner: Head of Reporting
- Responsibilities:
- Develop intuitive and user-friendly dashboards and reports.
- Continuously improve visualisation tools based on business feedback.
13. Data Governance Metrics & KPIs
- Owner: Data Governance Manager
- Responsibilities:
- Define KPIs for data governance (e.g., data quality scorecards, compliance).
- Monitor and report on governance metrics regularly to ensure alignment.
14. Business User Training and Data Literacy
- Owner: Senior Data Engineer (in partnership with Data Governance Manager & Head of Reporting)
- Responsibilities:
- Develop data literacy programmes and self-service analytics tools.
- Provide ongoing training on data access, interpretation, and usage.