Data Architect

Overview

We are looking for an experienced and highly capable Data Architect to join our team onsite in the Kingdom region. This role is ideal for someone with 7+ years of hands‑on experience in data platform architecture, pipeline development, and infrastructure automation across cloud and on‑premise environments. The ideal candidate will be passionate about building scalable and reliable data platforms using modern technologies such as SQL Server, SSIS, IBM App Connect API, OCI Cloud services, micro‑services architecture, Erwin, and more.

They will define and maintain enterprise data architecture, establish data standards and governance, and design scalable, secure, and high‑performance data platforms using SQL Server, Microsoft technologies, Oracle cloud‑native services, App Connect APIs, and microservices.

• Design, develop and maintain conceptual, logical, and physical data models for data blueprints.
• Implement and enforce data modeling standards to ensure consistency and accuracy across data stores and platforms.
• Design Master & Reference Data Management strategies.
• Implement metadata management and end‑to‑end data lineage.
• Act as solution architecture review and design authority.
• Design cloud & hybrid data architecture and migration strategies.
• Design and implement robust, scalable, and secure data platform solutions using Snowflake, SQL Server, and cloud‑native services.
• Collaborate with stakeholders to translate business and analytics needs into efficient data platform architecture.
• Define and implement data storage, access, and lifecycle management strategies across structured and semi‑structured data.
• Design and implement enterprise‑grade data pipelines utilizing Microsoft SSIS and proprietary integration platforms, ensuring scalability, reliability, maintainability, and operational excellence.
• Orchestrate and monitor data workflows, ensuring data reliability and availability.
• Implement fault‑tolerant, modular pipelines with robust logging and alerting mechanisms.
• Tune performance of data workflows, SQL queries, and cloud services.
• Leverage indexing, partitioning, caching, and pipeline optimizations to ensure platform efficiency.
• Define enterprise performance benchmarks, service level objectives (SLOs), and key performance indicators (KPIs) for data platforms, databases, and integration services.
• Lead performance assessments and capacity planning initiatives to ensure scalability, reliability, and optimal resource utilization.
• Establish performance testing methodologies for ETL pipelines, APIs, databases, and analytical workloads using industry best practices.
• Analyze workload patterns and implement optimization strategies including indexing, partitioning, query tuning, caching, and resource governance.
• Develop performance baselines and proactively identify bottlenecks through continuous monitoring, trend analysis, and predictive capacity planning.
• Collaborate with engineering teams to optimize platform performance while balancing scalability, operational costs, and business requirements.
• Design, implement, and govern high availability (HA) and disaster recovery (DR) architectures to ensure business continuity and platform resilience.
• Define enterprise standards for database replication, clustering, failover mechanisms, backup, and recovery strategies across cloud and on‑premises environments.
• Evaluate and optimize SQL Server Always On Availability Groups, replication technologies, and cloud‑native HA solutions to meet RTO and RPO.
• Establish resilience testing frameworks by conducting periodic failover, disaster recovery, and business continuity exercises to validate platform readiness.
• Collaborate with infrastructure and operations teams to continuously improve system availability, reliability, and fault tolerance.
• Implement role‑based access control, encryption, and data masking in compliance with data governance standards.
• Partner with security teams to ensure the platform aligns with enterprise compliance and audit requirements.
• Define and enforce data governance aligned with DAMA‑DMBOK, NDMO, SDAIA, and PDPL.
• Set up and maintain real‑time monitoring using tools such as Prometheus,…