This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking a highly skilled Senior Data Engineer for an extensive 35-month contract to lead the design and evolution of enterprise-level data architectures. In this role, you will be responsible for modeling, developing, and maintaining a robust Enterprise Data Warehouse (EDW), data lakes, and data marts. You will play a critical role in building analytics-ready datasets and business intelligence solutions that drive data-informed decision-making for a major transit organization.
Job Responsibility
Design, develop, and document Azure Data Factory (ADF) and SSIS packages to integrate complex data from multiple source systems
Build and maintain Databricks notebooks and jobs using Python (PySpark) and SQL for both batch and streaming workloads
Implement curated, analytics-ready datasets following the Medallion Architecture (Bronze, Silver, Gold layers) and Delta Lake best practices
Develop complex T-SQL, stored procedures, views, triggers, and indexes to optimize performance within Azure Synapse and SQL Server environments
Conduct advanced data analysis to provide meaningful, data-driven insights to business stakeholders
Develop high-quality Power BI reports and dashboards to visualize key performance indicators and operational metrics
Assist in the data modeling of the data warehouse/data lake solutions to ensure scalability and alignment with business requirements
Design and implement rigorous data quality and cleansing processes to ensure the integrity of the enterprise data assets
Manage the end-to-end development lifecycle using Azure DevOps pipelines to ensure reliable and automated deployments
Convert business requirements into detailed technical specifications, provide accurate time estimates, and conduct knowledge transfer sessions for the team
Requirements
5+ years of dedicated experience in Data Engineering or Database Development for enterprise-scale solutions
Hands-on expertise with Azure Synapse (SQL DW), Azure Data Factory, Azure Databricks, and SQL Server 2016+
Proficient in SQL and Python (specifically PySpark for big data processing)
Proven experience implementing CI/CD pipelines using Azure DevOps
Demonstrated experience developing reports in Power BI
University degree in Computer Science or an equivalent combination of education and experience
Expert understanding of DW/BI implementations, data lake design, and data stewardship techniques
What we offer
Unmatched Stability: A 35-month contract provides rare long-term stability and the opportunity to lead a project from foundational design to mature operation
Enterprise Scale: Work on a massive transit data ecosystem, solving complex data problems that impact millions of users
Modern Cloud Stack: Deepen your expertise in the full Azure data suite, including Delta Lake, PySpark, and Synapse
Strategic Role: Move beyond simple coding to help model the enterprise data strategy and deliver actionable business intelligence