Senior Data Engineer

Please read the JD Carefully

Job Title: Senior Data Engineer / SSIS Engineer:
Department/Section: Data and Analytics Office / Data Engineering

Language : Arabic & Non Arabic

Location: 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 Responsibilities:
1. 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.

2. Semantic Layer Development:

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

3. Data Pipeline Development (ETL/ELT):

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

4. Data Quality & Consistency:

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

5. Collaboration with Stakeholders:

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

6. Documentation & Best Practices:

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

7. Technical Mentorship:

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

uj72dQYmlb