Senior Data Modeller (Databricks) 12 Month project - Contractor

This role will focus on designing and optimizing data models for transactional and analytical platforms, supporting Databricks, Delta Lake, Spark, NoSQL, and relational databases-strong experience in data modelling, Databricks environments, OLAP/OLTP design, and modern data lake/warehouse architectures

Senior Data Modeller (Databricks) – 12-Month Project | Contractor

We are seeking a highly experienced Senior Data Modeller with strong Databricks expertise to support a 12-month project focused on modern data architecture, modelling, and platform optimization. This role will play a key part in designing and maintaining data models for both transactional and analytical data stores, while supporting cloud-based analytical workloads and ensuring robust performance, resilience, and compliance.

Overview

The position will focus on designing and evolving data models across operational and analytical environments, administering databases, and enabling high-performing data platforms that support advanced analytics. This is an ideal opportunity for a contractor with strong hands-on experience in Databricks and data modelling within modern cloud ecosystems.

Key responsibilities

• Develop new data models and enhance existing models to support evolving business and analytical needs

• Administer relational databases such as Oracle, PostgreSQL, SQL Server, and MySQL to maximize reliability, performance, and data resilience

• Manage NoSQL databases and Databricks Delta Lake models for analytical workloads

• Carry out performance tuning across databases, pipelines, and data models, including indexing, partitioning, caching, and compute scaling

• Oversee security and compliance standards, including IAM roles, encryption policies, auditing, and least-privilege access protocols

• Support backup and disaster recovery planning to ensure business continuity in cloud environments

• Collaborate internally to strengthen Databricks best practices and data modelling standards

Technologies and tools

• Databricks

• Delta Lake

• Spark

• NoSQL

• Data modelling tools such as ER/Studio, ERwin, Lucidchart, draw.io, or similar

• Scripting in SQL, Bash, and Python

Required skills and experience

• Proven experience managing Databricks environments and working with internal stakeholders to improve platform best practices

• Strong capability in designing, maintaining, and optimizing data models

• Proficiency with ERD and data modelling tools

• Solid experience designing and maintaining OLAP, NoSQL, Data Warehouse, and Data Lake architectures

• Strong understanding of both OLTP and OLAP modelling techniques, including Star, Snowflake, and Dimensional models

• Extensive hands-on technical experience across Data Modelling and Databricks-based environments

Project details

• Role: Senior Data Modeller (Contractor)

• Location: Barcelona, Spain (Hybrid)

• Duration: 12-month contract

• Engagement: Freelance / Independent Consultant