Data Engineer

BBI; Riyadh; On-site; SAR 299,962 - 374,953; Full time

Job summary

A leading technology firm in Riyadh is seeking an ETL Developer to design and develop solutions for loading Data Warehouses and Data Marts. This role involves implementing data quality processes, managing support for interfaces, and participating in agile ceremonies. The ideal candidate has a strong background in SQL, data warehousing, and experience with performance monitoring tools. This position offers opportunities for growth and contributions to impactful projects.

Qualifications

• Experience in designing and developing ETL solutions.
• Proficient in SQL and data modeling.
• Ability to implement data quality processes.

Responsibilities

• Design and develop ETL solutions for data loading.
• Conduct quality control with testing.
• Monitor systems to ensure optimal application performance.

Skills

ETL development

Data Warehousing

SQL

Data Quality Assurance

Agile Methodologies

Tools

Performance Monitoring Tools

Job description

Job Description:

• Design and develop ETL solutions for loading Data Warehouses and Data Marts.
• Develop mappings for complex business logic, transformations, and aggregations for various data marts and tables.
• Implement data quality processes, including translation, analysis, standardization, and enrichment for real-time and batch modes.
• Perform source-to-target and logical-to-physical data mapping, including third normal form to dimensional models.
• Design and create database tables based on project requirements.
• Generate DDL and SQL for physical models and views for DBA implementation.
• Troubleshoot and resolve data consistency and quality issues.
• Support testing and QA efforts on data-related projects.
• Conduct quality control with both automated and manual testing.
• Create and update project documentation for ongoing support.
• Manage support and maintenance of assigned interfaces and applications.
• Review and troubleshoot production jobs and resolve issues.
• Monitor systems to ensure optimal application performance.
• Use performance monitoring tools to resolve root cause issues.
• Handle escalated project issues and ensure timely resolution.
• Provide regular project status updates to ensure visibility.
• Participate in agile ceremonies like stand-ups, backlog grooming, retrospectives, and demos.