Data Engineer
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Consertus is seeking a Data Engineer to design, build, and maintain scalable data solutions for client engagements. The role involves developing robust data pipelines, ETL processes, and data models using SQL, Python, and cloud platforms.
Key Skills for This Role
Responsibilities
- Design, develop, and maintain scalable data pipelines and ETL processes to ingest, transform, and load 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
- Produce clear technical documentation including data mappings, data models, and pipeline designs
Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field
- 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
- Experience working 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
Full Job Posting
About Us
- Consertus is a global capital program management and advisory firm with over 1,000 professionals worldwide.
- Services span digital, advisory, and delivery across sectors including aviation, transportation, energy, and healthcare.
About this Role
- As a Data Engineer, you will design, build, and maintain scalable data solutions for analytics, reporting, and integration.
- You will work as part of a consulting team to develop robust data pipelines, data models, and backend systems.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and ETL processes.
- Develop and optimize complex SQL queries, stored procedures, and database objects.
- Design and implement data models including relational, dimensional, and analytical schemas.
- Lead the design and evolution of data warehouse architectures.
- Build and maintain data integration solutions using APIs, flat files, and other mechanisms.
- Develop backend data processing and automation solutions using Python.
- Ensure data quality, integrity, and consistency through validation and monitoring.
- Collaborate with stakeholders to gather requirements and translate them into technical solutions.
- Optimize and troubleshoot data systems and pipelines.
- Produce clear technical documentation including data mappings and pipeline designs.
Qualifications/Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
- 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.
- Experience working 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.
Additional Requirements / Skills
- Experience with ETL tools such as SSIS, Azure Data Factory, or similar.
- Familiarity with cloud data platforms (Azure, AWS, or GCP).
- Experience working with APIs and handling semi structured data (JSON, XML).
- Exposure to data orchestration tools (e.g., Airflow, Prefect).
- Experience with version control systems such as Git.
- Familiarity with BI/reporting tools (e.g., Power BI, Tableau) is a plus.
- Ability to manage multiple priorities in a fast paced consulting environment.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Consertus
Data Engineer
Riyadh, KSA
Design and maintain scalable data solutions, develop ETL processes, optimize SQL queries, and ensure data quality in a client-facing environment.
Power BI Developer
Riyadh, KSA
Consertus is looking for a Power BI Developer to design, develop, and maintain business intelligence solutions for client engagements. The role involves building Power BI semantic models, dashboards, and reports, as well
Power BI Developer
الرياض, KSA
Consertus is looking for a Power BI Developer to join a consulting team delivering data and analytics solutions. You will design, develop, and maintain BI solutions, including dashboards and reports, using Power BI, DAX,
Data Engineer
Riyadh, KSA
Consertus is seeking a Data Engineer to design, build, and maintain scalable data solutions for client engagements. You will develop ETL processes, optimize SQL queries, and implement data models. Requires 5+ years of da