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 environment 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 new 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.