Senior SQL Developer / Data Modeller

Senior SQL Developer / Data Modeller

Posted Today by dcoded. | B Corp ™ pending

Apply
£80 Per hour
Outside
Remote
London Area, United Kingdom
Apply
Agile Methodology Amazon Web Services (AWS) Balancing (Ledger/Billing) Datamodel Data Modeling Data Profiling Data Quality Data Structures Data Warehousing Design Elements And Principles Erwin (Data Modeling Software) Finance PostgreSQL Profiling (Computer Programming) Slowly Changing Dimensions Snowflake (Data Warehouse) SQL (Programming Language) Stakeholder Management System Context Diagram Usability Workflows

Summary: The Senior SQL / Data Modeller will lead the design and implementation of data models for global Finance and HR domains, ensuring data quality and consistency. This role involves collaboration with various teams and stakeholders to translate requirements into effective data structures. The position requires expert-level SQL skills and a strong background in data warehousing and analytics engineering. Occasional travel to a client site near Heathrow is expected, while the role is primarily remote.

Key Responsibilities:

  • Lead the design and implementation of robust SQL data models, focusing on dimensional and semantic modelling.
  • Build and maintain slowly changing dimensions (Type 1, 2, etc.) to enable accurate historical reporting.
  • Conduct data profiling and transformation to improve data reliability and usability across the global platform.
  • Collaborate with Data Architects and Engineers to integrate models within Snowflake, Oracle, and AWS environments.
  • Partner with business stakeholders to translate requirements into scalable, high-performing data structures.
  • Document and maintain business rules, data quality checks, and transformation logic.
  • Provide clear guidance on data best practices and drive adoption across Finance and HR teams.

Key Skills:

  • Expert-level SQL skills - able to design, optimise, and troubleshoot complex queries at scale.
  • Proven experience with data modelling and dimensional design, including SCD implementation.
  • Proficiency in ERWIN, Sparx EA, or similar data modelling tools.
  • Strong background in data warehousing and analytics engineering using platforms such as Snowflake, Oracle, or PostgreSQL.
  • Familiarity with AWS, Power BI/Tableau, and modern ELT/ETL workflows.
  • Ability to document and communicate data flows, CRUD matrices, and data lineage clearly.
  • Comfortable working in Agile (Scrum/Kanban) environments, balancing speed with rigour.

Salary (Rate): £80.00/hr

City: London Area

Country: United Kingdom

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

Senior SQL / Data Modeller – Analytics, Global Data Platform (Remote – Occasional Travel to Heathrow)

We’re looking for an experienced SQL / Data Modeller to take the lead in shaping how data is modelled, structured, and delivered across global Finance and HR domains. This is a decision-making role where you’ll own data design principles, ensure quality and consistency, and support multiple teams as the go-to data expert.

Location: Remote (occasional travel to client site near Heathrow)

£500-£550pd Outside IR35 6months engagement

What You’ll Do

  • Lead the design and implementation of robust SQL data models, focusing on dimensional and semantic modelling
  • Build and maintain slowly changing dimensions (Type 1, 2, etc.) to enable accurate historical reporting
  • Conduct data profiling and transformation to improve data reliability and usability across the global platform
  • Collaborate with Data Architects and Engineers to integrate models within Snowflake, Oracle, and AWS environments
  • Partner with business stakeholders to translate requirements into scalable, high-performing data structures
  • Document and maintain business rules, data quality checks, and transformation logic
  • Provide clear guidance on data best practices and drive adoption across Finance and HR teams

What You’ll Bring

  • Be a Senior / Lead on the project – making key decisions
  • Expert-level SQL skills - able to design, optimise, and troubleshoot complex queries at scale
  • Proven experience with data modelling and dimensional design, including SCD implementation
  • Proficiency in ERWIN, Sparx EA, or similar data modelling tools
  • Strong background in data warehousing and analytics engineering using platforms such as Snowflake, Oracle, or PostgreSQL
  • Familiarity with AWS, Power BI/Tableau, and modern ELT/ETL workflows
  • Ability to document and communicate data flows, CRUD matrices, and data lineage clearly
  • Comfortable working in Agile (Scrum/Kanban) environments, balancing speed with rigour
Apply
Similar Jobs
Loading data...