Data Modeller DBA (CONTRACTOR)

Senior Data Modeller (Databricks) – 12 Month project - Contractor Overview The role encompasses designing and maintaining data models for transactional and analytical data stores, administering operational databases, and supporting advanced analytical workloads across cloud platforms.

Overview

The role encompasses designing and maintaining data models for transactional and analytical data stores, administering operational databases, and supporting advanced analytical workloads across cloud platforms.

We need someone with Databricks & Data Modelling experience.

Key Responsibilities

• Develop new data models or update existing ones.
• Administer relational databases such as Oracle, PostgreSQL, SQL Server, or MySQL to maximise reliability, performance, and data resilience.
• Manage NoSQL Databases and Databricks Delta Lake models for analytical workloads.
• Execute performance-tuning activities at the database, pipeline, and data-model levels, including indexing, partitioning, caching, and compute scaling.
• Oversee security and compliance standards, such as IAM roles, encryption policies, auditing, and implementation of least-privilege access protocols.
• Assist with backup and disaster recovery planning to ensure business continuity within cloud environments.

• Technologies & Tools

  • Databricks / Delta Lake / Spark / NoSQL
  • Data Modelling: ER/Studio, ERwin, or open-source tools
  • Scripting: SQL, Bash, Python

  Required Skills

  • Experience managing Databricks accounts and collaborating internally to advance best practices.
  • Proven ability to optimise data models.
  • Proficiency with ERD modelling tools (e.g., ER/Studio, Lucidchart, draw.io, or similar).
  • Skilled in designing and maintaining OLAP, NoSQL, and Data-Warehouse/Data-Lake architectures.
  • Strong understanding of common OLTP and OLAP modelling techniques, including Star, Snowflake, and Dimensional models.
  • Extensive technical Data Modelling & Databricks environments.