Senior Data Engineer – Scalable Pipelines & Analytics

Consertus-Saudi Arabia; Riyadh; On-site; SAR 179,000 - 312,000; Full time

Job summary

Consertus is seeking a Data Engineer to design, build, and maintain scalable data solutions that support analytics and reporting across client engagements. You will develop robust data pipelines, data models, and backend systems transforming raw data into reliable datasets for business use.

In this client-facing role, you will collaborate with cross-functional teams to design data architectures, implement ETL processes, and support modern data platforms.

Qualifications

• 5+ years of experience in data engineering, software development, or related roles
• Advanced expertise in SQL, including complex queries, joins, aggregations, stored procedures, and performance tuning
• Strong experience with database design and schema development
• Hands-on experience with data warehousing concepts, including staging, data marts, and dimensional modeling
• Proficiency in Python for data processing, scripting, and automation
• Exposure to data warehousing concepts, including staging, data marts, and dimensional modelling
• Experience with large, complex datasets across multiple systems
• Strong understanding of data modeling techniques (relational and dimensional)
• Strong analytical and problem-solving skills
• Effective written and verbal communication skills

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes ingesting data from multiple sources
• Develop and optimize complex SQL queries, stored procedures, and database objects for high-performance data processing
• Design and implement data models, including relational, dimensional (star/snowflake), and analytical schemas
• Lead the design and evolution of data warehouse architectures, including staging layers, data marts, and enterprise data models
• Build and maintain data integration solutions using APIs, flat files, and other data exchange mechanisms
• Develop backend data processing and automation solutions using Python
• Ensure data quality, integrity, and consistency through validation, monitoring, and testing processes
• Collaborate with stakeholders to gather requirements and translate them into scalable technical solutions
• Optimize and troubleshoot data systems and pipelines to ensure performance, reliability, and scalability
• Demonstrate ownership of deliverables, ensuring quality, timeliness, and alignment with client expectations
• Produce clear technical documentation including data mappings, data models, and pipeline designs
• Provide guidance on data engineering best practices, including data modelling, pipeline design, and performance optimization
• Contribute to reusable frameworks, standards, and continuous improvement initiatives

Skills

SQL expertise

Data modeling

Python

Data warehousing

Database design

Analytical thinking

Problem solving

Communication

Git / version control

APIs handling

Airflow

Cloud platforms

ETL tools

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering

Tools

SSIS

Azure Data Factory

Airflow

Git

Power BI

Tableau

Job description

Consertus is seeking a Data Engineer to design, build, and maintain scalable data solutions that support analytics and reporting across client engagements. You will develop robust data pipelines, data models, and backend systems transforming raw data into reliable datasets for business use.

In this client-facing role, you will collaborate with cross-functional teams to design data architectures, implement ETL processes, and support modern data platforms.