Senior Data Engineer

Please read the JD Carefully

Job Title:

Senior Data Engineer / SSIS Engineer

Language: Arabic & Non Arabic
Location: Riyadh
Industry: Govt. Sector Org.
Experience: 7+ Years

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.

• 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.

• 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.

• 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.