2 of 2 Permanent Dimensional Modelling Jobs in Central London

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

experience with DBT, building and maintaining modular, scalable data models that follow best practices Previous experience working on Data Quality engagements Strong understanding of dimensional modelling Strong understanding of Data Quality and how it is measured Desireable: Experience writing complex validation logic using tools like Great Expectations ...