Data Engineer

The role

The Data Engineering Specialist works within a lakehouse platform stack to build and maintain ingestion pipelines. This person will develop Silver-layer cleansing logic and model Gold-layer datasets in dbt for internal and external consumption.

What you will do

• Collaborate with cross-functional teams to gather data requirements.
• Design, develop, and maintain scalable data pipelines to process and integrate data from various sources.
• Optimize data pipelines for performance, cost efficiency, and data quality.
• Design and implement data models and schemas that meet business requirements.
• Develop and maintain logical and physical data models to support data warehousing and reporting.
• Ensure data consistency and integrity across different data storage systems.
• Design, develop, and maintain ETL processes to extract, transform, and load data from multiple sources.
• Monitor data integration processes, troubleshoot, and resolve any issues that may arise.
• Collaborate with data source owners to ensure the availability and quality of the data.
• Implement data quality controls and validation processes to ensure data accuracy and reliability.

Required qualifications

• Bachelor's degree in computer science, Engineering, or a related field.
• 5-10+ in data engineering, data warehousing, and ETL processes.
• Proficiency in programming languages such as Python and SQL
• Experience with AWS data services, particularly S3, Glue, and Athena
• Hands-on experience with dbt (data build tool) for data transformation and modeling
• Knowledge of data lakehouse patterns and medallion architecture (bronze/silver/gold layers)
• Experience with Infrastructure as Code (IaC) tools, specifically Terraform
• Experience with relational and NoSQL databases
• Understanding of AI and machine learning concepts, with the ability to prepare and structure data to support AI-driven products
• Fluent in English and French, both verbally and written

About the company

SOVRA is a public procurement platform trusted by more than 7,000 government agencies and over 1 million suppliers across North America. The company builds technology to help governments operate more efficiently and transparently.