Job Title: Solution Architect
Experience: 10+ Years (Mandatory)
Location: Riyadh - Onsite
Employment Type: Full-Time
Overview:
We are seeking an experienced and strategic Solution Architect to join our team onsite in the Kingdom region. The ideal candidate will possess 10+ years of experience in Enterprise Solution Architecture, Data Platform Engineering, System Integration, and modern Data Ecosystems across on-premises, cloud, and hybrid environments.
The Solution Architect will be responsible for designing, governing, and optimizing enterprise-wide technology solutions that align with business objectives, architectural standards, and industry best practices. This role requires close collaboration with business stakeholders, product owners, and engineering teams to translate business requirements into scalable, secure, and high-performance solution architectures.
The successful candidate will have deep expertise in Microsoft SQL Server, SSIS, Oracle Database, OCI Cloud, IBM App Connect Enterprise (ACE), microservices architecture, enterprise integration, data modeling, and Enterprise Architecture practices, with hands-on experience using architecture modeling tools such as erwin Data Modeler/Evolve, Bizzdesign, ArchiMate, and related Enterprise Architecture platforms.
Responsibilities:Data Modeling:
- Design, Develop and maintain conceptual, logical, and physical data models for the data blueprints.
- Implement and enforce data modeling standards to ensure consistency and accuracy across the data stores and platforms.
- Design Master & Reference Data Management strategies.
- Implement Metadata Management and end-to-end Data Lineage.
- Act as Solution Architecture Review & 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.
Data Pipeline Development & Orchestration:
- Review the existing enterprise data ecosystem to identify architectural gaps, technical debt, scalability limitations, and opportunities for modernization and continuous improvement.
- Architect end-to-end enterprise solutions by collaborating with business and technical stakeholders to translate business requirements into solution blueprints, feasibility assessments, High-Level Designs (HLDs), and Low-Level Designs (LLDs).
- Develop and maintain enterprise architecture artifacts using industry-standard tools such as Bizzdesign, ArchiMate, erwin Data Modeler/Evolve, and other Enterprise Architecture modeling platforms.
- Lead architecture governance by conducting solution, implementation, and deployment reviews to ensure alignment with enterprise architecture standards, scalability, security, reliability, and operational excellence.
- Serve as the subject matter expert for Microsoft SSIS, designing and developing enterprise-grade ETL solutions utilizing metadata-driven frameworks, CDC/SCD implementations, complex transformations, Script Components, parallel processing, enterprise logging, deployment automation, and performance optimization.
- Define enterprise performance standards, Service Level Objectives (SLOs), and Key Performance Indicators (KPIs) for data platforms, ETL pipelines, databases, APIs, and integration services.
- Lead performance engineering and capacity planning initiatives by establishing performance baselines, conducting workload analysis, identifying bottlenecks, and implementing optimization strategies across ETL pipelines, SQL workloads, cloud services, APIs, and databases.
- Optimize platform performance through query tuning, indexing, partitioning, caching, resource governance, and pipeline optimization while ensuring scalability, reliability, cost efficiency, and optimal resource utilization.
- Establish performance testing methodologies and continuous monitoring frameworks to proactively assess platform health, predict capacity requirements, and ensure sustained operational excellence.
- Collaborate with engineering, infrastructure, and DevOps teams to continuously enhance platform performance, deployment strategies, and solution reliability while balancing business requirements, scalability, and operational costs.
- 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 Recovery Time Objectives (RTO) and Recovery Point Objectives (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.
Governance, Security & Compliance:
- 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, Grafana, and native cloud monitoring tools.
- Provide transparency into data jobs, pipeline statuses, and platform health.
- Partner with data scientists, analysts, and business stakeholders to support self-service analytics and data product development.
- Document architecture, data flow, and technical decisions using industry best practices.
- Continuously monitor and evaluate emerging technologies, trends, and best practices within the data and cloud ecosystem.
- Evaluate new tools and recommend integration to enhance platform scalability, performance, and cost-effectiveness.
- Bachelor’s or Master’s in Computer Science, Information Systems, or a related field.
- 10+ years of experience in data engineering, data platform, or analytics engineering roles.
- Proficient in SQL Server, SSIS, Oracle SSIS, IBM AppConnect APIs, IBM MQ and Elastic Search.
- Strong SQL, Python, and shell scripting capabilities.
- Experience building data transformation pipelines using modern technologies and platforms.
- Familiar with data governance frameworks (e.g., DAMA-DMBOK), security, and data privacy regulations.
- Knowledge of CI/CD practices and Git-based version control.
- Excellent communication and collaboration skills.
- Comfortable leading initiatives and mentoring colleagues and team members.
Skills Required
- 10+ years of experience in data engineering, data platform, or analytics engineering roles.
- Bachelor's or Master's in Computer Science, Information Systems, or related field.
- Proficient in Microsoft SQL Server.
- Proficient in SSIS (Microsoft SSIS).
- Proficient in Oracle Database.
- Proficient in Oracle SSIS.
- Experience with OCI Cloud (Oracle Cloud Infrastructure).
- Experience with Snowflake.
- Experience with IBM App Connect Enterprise (ACE) and IBM AppConnect APIs.
- Experience with IBM MQ.
- Experience with Elastic Search.
- Strong SQL, Python, and shell scripting skills.
- Experience with data modeling tools: erwin Data Modeler/Evolve, Bizzdesign, ArchiMate.
- Experience designing microservices architecture and enterprise integration.
- Knowledge of CI/CD practices and Git-based version control.
- Familiarity with Prometheus and Grafana for monitoring/observability.
- Familiar with data governance frameworks (DAMA-DMBOK), NDMO, SDAIA, and PDPL.
- Experience designing High Availability, Disaster Recovery, and SQL Server Always On solutions.
- Excellent communication skills and experience leading and mentoring teams.
Datamatics Technologies Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Datamatics Technologies and has not been reviewed or approved by Datamatics Technologies.
-
Flexible Benefits — Feedback suggests flexible timings and work-from-home options are available in some roles. This flexibility is highlighted as part of the employment experience across certain postings and materials.
-
Wellbeing & Lifestyle Benefits — Feedback suggests flexibility around time off and remote work supports work-life balance. These elements can help offset leaner cash components for some individuals.
Datamatics Technologies Insights
What We Do
Datamatics Technologies (DMT) was established in Dubai. We specialize in providing onsite and offshore professional services, covering the full spectrum of Data Analytics and Data Science domains. Our experience of working with diverse industry sectors such as Telecoms, Finance, Government and Manufacturing, across multiple regions enables us to engage and deliver for our clients with confidence. We can offer our full portfolio of services through resource augmentation, managed services, both on T&M or fixed price financial arrangements. Through our end-to-end managed services offering we enable our clients to cut down costs, increase profitability and focus on value addition to their core business activities. Our project and delivery management team are certified in Agile, PMI and ITIL to ensure the planning and execution are carried out using industry best practices. We are working with our clients across Middle East and Africa Region.








