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.