About the job
Ready to apply for roles like this?
Unlock the company name and direct application link. Subscribers get instant access to fresh jobs across Dubai, Abu Dhabi and Riyadh, many with visa support.
Unlock employer & apply directly
We are looking for an experienced Data Architect to design and govern enterprise data architecture, analytical data models, data governance, and data migration solutions. This role will focus on building scalable and secure data solutions using SQL Server, SSIS, Power BI, and Python, while defining data models, integration patterns, migration strategies, data quality standards, and governance frameworks.
Key Responsibilities
- Own enterprise data architecture, principles, standards, patterns, and roadmaps.
- Design data aggregation, analytics, and reporting architectures using Microsoft SQL Server.
- Define conceptual, logical, and physical data models across multiple business and operational domains.
- Design ETL and data ingestion solutions using SSIS, database connections, APIs, and file-based integrations.
- Define Power BI semantic models, reporting architecture, dashboards, and role-based access.
- Support advanced analytics and predictive modelling using Python and scikit-learn.
- Define and govern enterprise data migration strategies and architecture.
- Develop source-to-target mappings, transformation rules, migration waves, mock migration cycles, reconciliation, cutover, and validation approaches.
- Define data cleansing, validation, reconciliation, and migration quality controls.
- Support Dynamics 365 data migration using Data Management Framework (DMF), standard data entities, and approved Excel/CSV loading patterns.
- Define data quality, classification, retention, access, privacy, security, and audit requirements.
- Produce High-Level Design (HLD), Technical Design Documents (TDD), data models, data flows, migration strategies, and architecture documentation.
- Review data engineering, data modelling, BI, analytics, and migration designs for architecture compliance.
- Collaborate with application, integration, infrastructure, security, BI, and engineering teams.
- Support data migration testing, reconciliation, cutover readiness, and operational handover.
- Identify and manage data-related architecture risks, assumptions, dependencies, and technical exceptions.
- Provide technical guidance on data architecture, analytics, and migration decisions.
- Mentor data engineers, data modellers, BI developers, and migration specialists.
Technical Requirements
- Strong experience in enterprise Data Architecture and Data Modelling.
- Strong knowledge of conceptual, logical, and physical data modelling.
- Strong Microsoft SQL Server architecture and database design experience.
- Strong experience with SSIS for ETL, transformation, ingestion, and data loading.
- Experience designing enterprise data aggregation and analytics solutions.
- Strong experience with Power BI architecture, semantic models, dashboards, reporting, role-based security, and performance optimisation.
- Experience with data migration architecture covering discovery, mapping, transformation, cleansing, reconciliation, mock migrations, cutover, and validation.
- Experience with Dynamics 365 data migration using DMF, standard data entities, and file-based loading.
- Working knowledge of Python and scikit-learn for structured analytics and predictive modelling.
- Strong understanding of data governance, data quality, metadata, classification, retention, privacy, security, and access controls.
- Experience defining source-to-target mappings and data transformation rules.
- Experience with data reconciliation, validation, migration testing, and cutover.
- Experience producing HLDs, TDDs, data models, data-flow diagrams, and architecture documentation.
- Strong understanding of security-by-design and privacy-by-design principles.
Qualifications
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, Engineering, or a related field.
- 6+ years of relevant Data Architecture, Data Engineering, or Data Management experience.
- At least 2+ years of experience in a Data Architect or similar architecture role.
- Proven experience designing multi-system enterprise data solutions and data migration architectures.
- Strong knowledge of data modelling, SQL Server, ETL, BI/reporting, analytics, and data migration.
- Experience supporting enterprise data and analytics solutions across full implementation lifecycles.
- TOGAF, CDMP, Microsoft Data Platform, Azure Data, or Power BI certifications are an advantage.
- Experience working within large-scale digital or enterprise transformation initiatives is preferred.
- Strong stakeholder communication and technical documentation skills.
- Strong analytical, problem-solving, and architecture decision-making skills.
- Ability to work effectively across multidisciplinary technical teams.
Key Skills
- Data Architecture
- Data Modelling
- SQL Server
- SSIS
- ETL
- Power BI
- Semantic Models
- Data Migration
- Data Governance
- Data Quality
- Data Security
- Data Privacy
- Dynamics 365
- DMF
- Source-to-Target Mapping
- Data Reconciliation
- Python
- scikit-learn
- Predictive Analytics
- HLD
- TDD
- Data Analytics
- Data Integration
- Data Warehousing
- BI
- Data Transformation
