Data Engineer

About the role

Consertus is seeking a Data Engineer to design, build, and maintain scalable data solutions that support analytics, reporting, and integration across client engagements. You will work within a consulting team to transform raw data into reliable, high‑quality datasets for business use.

Key responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes to ingest, transform, and load data from multiple sources.
• Develop and optimise complex SQL queries, stored procedures, and database objects for high‑performance data processing.
• Design and implement relational, dimensional (star/snowflake), and analytical data models.
• Lead the evolution of data‑warehouse architectures, including staging layers, data marts, and enterprise data models.
• Build data integration solutions using APIs, flat files, and other exchange mechanisms.
• Develop backend data processing and automation solutions using Python.
• Ensure data quality, integrity, and consistency through validation, monitoring, and testing.
• Collaborate with stakeholders to gather requirements and translate them into scalable technical solutions.
• Produce clear technical documentation, including data mappings, models, and pipeline designs.

Required profile

• Strong technical expertise in data engineering and ability to work independently.
• Experience designing scalable data solutions in a fast‑paced, client‑facing environment.
• Proven ability to deliver high‑quality deliverables on time.

Required skills

• Python
• SQL
• ETL processes
• Data modeling (relational and dimensional)
• Data warehousing
• API integration