Job Title-Data Modeller (SQL)

Client-Global Consulting Firm

Day Rate-£375-£400 (Outside IR35)

Duration-6 months (extendable)

Location-London (Hybrid, 2 days in the office)

 

We are seeking a Senior Hands-on Data Modeler/Data Architect with 10+ years of experience in SQL-based data modeling to design and implement robust data solutions. The ideal candidate will have a banking or financial services background, ensuring data models align with industry best practices, regulatory requirements, and business needs.

• 10+ years of hands-on experience in data modeling, database architecture, or data engineering.

• Expertise in SQL, including query optimization, indexing, partitioning, and stored procedures.

• Deep understanding of relational and dimensional data modeling (normalization, denormalization, star/snowflake schema).

• Proficiency with data modeling tools such as Erwin, ER/Studio, or equivalent.

• Strong knowledge of banking and financial data structures, regulatory frameworks, and reporting standards.

• Experience in data governance, metadata management, and data lineage tracking.

• Familiarity with cloud data platforms (AWS Redshift, Azure Synapse, Google BigQuery, Snowflake).

• Experience with ETL/ELT design, data integration, and data warehousing best practices.

• Experience with risk and compliance data models (Basel III, IFRS 9/17, AML, BCBS 239).

• Knowledge of Data Vault modeling and modern data warehouse/lakehouse architectures.

• Certifications in data modeling, cloud databases, or data governance (CDMP, AWS/Azure certifications) are a plus.