The Senior SQL Developer will play a critical role in Davies' Business Intelligence function, supporting the design and delivery of analytical datasets, reporting logic, and data structures that power enterprise decision-making. This individual will work closely with BI analysts, operations leadership, and data science teams to translate complex business requirements into performant SQL solutions: from engineering large, feature-rich datasets for machine learning models to building the query logic behind operational KPIs. The role requires someone who thrives in a complex data setting spanning multiple acquired systems of record across insurance lines of business.
Key Responsibilities
Analytical SQL Development & Feature Engineering
Write complex, performant SQL to query, transform, and join data across multiple source systems into analytical datasets, including large-scale feature engineering (100+ features) for fraud detection and machine learning use cases.
Develop and maintain stored procedures, functions, and views that serve as the backbone for Power BI reports,
operational dashboards, and executive reporting.
Translate business requirements into SQL logic: for example, converting defined KPI specifications into reliable, well-documented query structures that operations teams depend on daily.
Reporting & BI Support
Partner with Power BI developers and BI analysts to build and optimize the SQL layer underlying dashboards and semantic models.
Assist with UAT for current reports and reporting structures, validating data accuracy, edge cases, and performance under production conditions.
Support the build-out of new reporting frameworks, including designing query patterns for net-current KPI sets across business units.
Data Integration & Transformation
Work with data from multiple acquired systems with differing schemas, naming conventions, and business logic: normalizing and reconciling data to enable cross-system reporting.
Build and maint