Data Engineer

Job Summary

As a Data Engineer at Consertus, you will design, build, and maintain scalable data solutions that support analytics, reporting, and integration across client engagements. You will develop robust data pipelines, data models, and backend systems that transform raw data into reliable datasets for business use.

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

Must haves

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a 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

Nice to haves

• 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)
• Experience with version control systems such as Git

What the company offers

• Work with a global team of more than 1,000 professionals worldwide
• Flexible work arrangements and the ability to work independently
• Opportunity to work on large-scale capital programs across sectors including aviation, transportation, transit, water, healthcare, energy, education, government, commercial, life sciences, and technology

We refresh listings regularly, but some roles close early on the source platform.