Senior SQL Software Engineer

Our client is the largest specialist in geotechnical contracting globally.

Their diverse techniques, whether used individually or in combination, address various challenges across the construction industry. This includes industrial, commercial, and residential developments, as well as critical infrastructure projects like dams, tunnels, transportation, and water treatment facilities, alongside initiatives to tackle environmental issues.

The global expertise and extensive experience provide access to innovative solutions led by the brightest minds in the industry.

With approximately 10,000 employees and operations spanning five continents, we bring the resources, skill, and stability needed to respond swiftly, execute projects effectively, and maintain a strong focus on safety.

This project focuses on building and implementing dimensional data models for an enterprise data platform.

The SQL Developer will work on developing and optimising the Gold layer of the data platform, using SQL transformations, data integration processes, and dimensional models designed by the Data Modeler.

The goal is to deliver reliable, reusable, and high-performance data structures that support business intelligence and reporting.

You will work closely with the Data Modeler, other developers, and business stakeholders in an international team.

The Data Modeler will lead the design, while the SQL Developers will focus on implementation, optimisation, and data quality.

• Interview process that respects people and their time
• Professional and open IT community
• Internal meet-ups and resources for knowledge sharing
• Time for recovery and relaxation
• Bright online and offline events
• Opportunity to become part of our internal volunteer community

• Develop, optimise, and maintain complex T-SQL queries, stored procedures, and SQL transformations.
• Implement dimensional data models, including fact and dimension tables, based on the Data Modeler's designs.
• Build and optimise the curated Gold layer within a Medallion Architecture.
• Develop and maintain ETL/ELT processes, including incremental loading, change data capture, and data transformations.
• Translate source-to-target mappings into reliable SQL implementations.
• Optimise query performance and data processing across large datasets.
• Implement data quality checks, reconciliation, and automated testing.
• Work with Azure DevOps, Git, and CI/CD pipelines.
• Collaborate with the Data Modeler to identify and resolve data and performance issues.
• Maintain technical documentation and support Agile delivery.

• Strong T-SQL development skills, including complex queries, query optimisation, and performance tuning.
• Good understanding of Kimball dimensional modelling (star schemas, fact and dimension tables, surrogate keys, slowly changing dimensions).
• Experience with Data Warehousing, Lakehouse architecture, and Medallion Architecture (Bronze, Silver, Gold).
• Hands-on experience implementing dimensional data models.
• Experience with SQL-based ETL/ELT processes, incremental loading, change data capture, and data transformations.
• Experience with Azure DevOps, Git, and CI/CD pipelines.
• Knowledge of Delta/Parquet-based data structures.
• Experience with data quality validation, reconciliation, and testing.
• Ability to work independently, communicate effectively, and collaborate in Agile teams.

Nice to have:

• Microsoft Fabric (Lakehouse, Warehouse, SQL analytics endpoint, OneLake).
• Azure Data Factory, Fabric Data Factory, and Azure SQL Database.
• Spark SQL and PySpark.
• Experience integrating data from Microsoft Dynamics 365 or similar ERP systems.
• Understanding of Power BI semantic models and Direct Lake.