Senior Data Modeller

Job Description

As a Senior Data Modeller
, you will play a key role in designing, developing and maintaining enterprise data models that enable analytics, reporting, AI, machine learning and business intelligence initiatives. You will translate complex business requirements into scalable, high-quality data solutions, ensuring data is structured, governed and optimised for performance across the organisation.

London, United Kingdom (Hybrid working)

Permanent

• Translate business requirements into scalable data models that support long-term business and technology objectives.
• Design, develop and maintain conceptual, logical and physical data models using industry best practices to ensure data quality, consistency and minimal redundancy.
• Partner with application development, architecture and business teams to define data strategies, data flows and source-to-target mappings.
• Develop and maintain metadata, data dictionaries and documentation to support enterprise data governance.
• Optimise and enhance existing data models to support new business initiatives and improve performance.
• Define and promote data modelling standards, naming conventions and best practices across projects.
• Identify opportunities to reuse existing data models and data assets to improve efficiency and consistency.
• Perform reverse engineering of existing databases and SQL scripts to produce accurate data models and documentation.
• Assess logical and physical data models for quality, integrity, performance and alignment with business requirements.
• Validate business data entities and ensure data models accurately reflect business processes and information requirements.
• Analyse data integration challenges and recommend scalable, efficient solutions across multiple systems.
• Provide technical guidance to Business Analysts, Developers, Engineers and Solution Architects on data modelling, database design and integration approaches.
• Review application and database designs, recommending improvements to enhance scalability, maintainability and performance.
• Contribute to the development and implementation of enterprise data architecture, including data movement strategies, technology direction and governance frameworks.
• Ensure all data architecture deliverables comply with enterprise standards, policies and best practices.
• Collaborate closely with project managers, business stakeholders, technical teams and clients to provide expert guidance on all aspects of data architecture, modelling and data management throughout the project lifecycle.

• 7-10 Years industry implementation experience with one or more data modelling tools such as Erwin, ERStudio, Power Designer etc.
• Minimum of 8 years of data architecture, data modelling or similar experience
• 5-7 years of management experience required
• 5-7 years consulting experience preferred
• Experience working with dimensionally modelled data
• Bachelor’s degree or equivalent experience, Master’s Degree Preferred
• Understanding of cloud (Azure, AWS, GCP, Snowflake preferred) and on premises architectures
• Experience in data analysis and profiling
• Strong data warehousing and OLTP systems from an integration perspective
• Strong understanding of data integration best practices and concepts
• Strong SQL skills required scripting preferred
• Strong Knowledge of all phases of the system development life cycle
• Experience with major database and big data platforms (e.g. RDS, Aurora, Redshift, Data bricks, MySQL, Oracle, PostgresSQL, Hadoop, Snowflake, etc.)
• Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)
• Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data.

• Extensive experience in enterprise data modelling, including conceptual, logical and physical data models.
• Strong understanding of data architecture principles, data governance and enterprise data management best practices.
• Experience translating business requirements into scalable data models and technical design documentation.
• Proven experience analysing business processes and designing data…