Lead Associate - SQL Developer

Imagine being part of a team that’s not just shaping the future but actively driving it. At Davies , we’re at the forefront of innovation and excellence, blending cutting-edge technology with top-tier professional services. As a vital part of the global Davies Group, we help businesses navigate risk, optimize operations, and spearhead transformation in the insurance and regulated sectors Key Responsibilities We're on the lookout for a full time Data Engineer . As a Data Engineer you will be building and maintaining the foundational data architecture and engineering practices for Davies North America. In addition to creating and maintaining an optimal pipeline architecture, typical duties and responsibilities for a Data Engineer position may include: Assembling large, complex sets of data that meet non-functional and functional business requirements using the medallion architecture. Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes via meta data orchestration. Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using Microsoft technologies. (Azure data factory, Fabric, SQL Server, and PowerBI) Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition. Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues. Working with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues Skills, Knowledge and Expertise Bachelor degree in computer science or related field. Ability to build and optimize data sets, ‘big data’ data pipelines and architectures with ADF. Ability to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions 3-5 years experience managing BI or Data team. Ability to build processes that support data transformation, workload management, data structures, dependency and metadataExcellent written and verbal communication skills, demonstrated through the preparation of reports and presentations for diverse audiences.