Job Title: Senior Data Engineer / SSIS Engineer
Department/Section: Data and Analytics Office / Data Engineering
Language : Arabic & Non ArabicLocation: Riyadh
Industry - Govt.Sector Org.
Experience: 7+ Years
Job Purpose
The Senior Data Engineer / SSIS Engineer is responsible for designing, building, and maintaining scalable data pipelines, ETL processes, and data marts that enable reliable analytics and data-driven decision-making. A key focus of this role is the development and maintenance of a robust semantic layer, ensuring structured, consistent, and business-friendly data access across the organization.
The role involves close collaboration with analytics, data science, and business teams to deliver high-quality data models, feature stores, and industrialized data products while upholding best practices in data engineering, data quality, and documentation.
Key Responsibilities1. Data Modeling
Design, develop, and maintain robust logical and physical data models that support analytical and reporting requirements.
Ensure models are scalable, performant, and aligned with business needs.
Apply industry-standard modeling techniques; experience with Data Vault methodology is a plus.
Design, implement, and maintain a centralized semantic layer to enable consistent and reusable business metrics.
Define and manage ontologies, taxonomies, hierarchies, and business definitions to ensure a common understanding of data across teams.
Enable self-service analytics by simplifying complex data structures for business users.
Develop, optimize, and maintain ETL pipelines, with a strong focus on SSIS, to automate data ingestion, transformation, and loading.
Ensure high reliability, performance, and availability of data pipelines across multiple source systems and data platforms.
Support batch and near–real-time processing where required.
Implement data quality checks and controls throughout the data lifecycle, starting from source systems.
Monitor data accuracy, completeness, and consistency, and proactively resolve data quality issues.
Collaborate with stakeholders to define and enforce data quality standards.
Work closely with data scientists, analysts, BI developers, and business stakeholders to gather requirements and translate them into scalable data solutions.
Support analytical use cases, feature engineering, and reporting needs through well-designed data assets.
Document data models, ETL workflows, semantic layer configurations, and data definitions.
Promote best practices in data engineering, naming conventions, version control, and deployment processes.
Ensure transparency, traceability, and knowledge sharing across teams.
Mentor and guide junior data engineers.
Provide technical leadership in data modeling, SSIS development, and semantic layer design.
Contribute to continuous improvement of data engineering standards and frameworks.
Required Qualifications & Skills
Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
Strong hands-on experience as a Senior Data Engineer or SSIS Engineer.
Advanced expertise in SSIS, SQL, and relational data warehouses.
Strong knowledge of data modeling techniques (star schema, snowflake, dimensional modeling).
Experience designing and maintaining data marts and semantic layers.
Solid understanding of data quality management and ETL best practices.
Strong communication skills and ability to work with both technical and non-technical stakeholders.
Nice to Have
Experience with Data Vault modeling.
Exposure to modern analytics platforms, cloud data services, or feature stores.
Experience supporting self-service BI and analytics use cases.
Top Skills
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.
