Data Modeller

We are seeking a skilled and experienced data modeller to design develop and maintain conceptual logical and physical data models that support our business intelligence analytics and application development needs The data modeller will work closely with business stakeholders data architects data engineers and analysts to ensure data structures are optimized for performance consistency and scalability Key responsibilities include designing and maintaining conceptual logical and physical data models to meet business and technical requirements collaborating with stakeholders to translate business requirements into data solutions developing entity relationship diagrams data dictionaries and metadata documentation ensuring data models are aligned with enterprise architecture standards and follow best practices for naming versioning and governance working with data engineers to optimize ETL and ELT pipelines for data integration and transformation supporting data product design initiatives collaborating with BI and reporting teams to ensure models meet analytics and performance requirements and identifying and resolving data related issues by analyzing data discrepancies and improving quality Qualifications include proven experience as a data modeller data architect or related role strong knowledge of data modelling methodologies such as third normal form dimensional modelling data products star and snowflake schemas hands on experience with data modelling tools such as ER Studio or Erwin proficiency in SQL and experience with relational databases such as Oracle PostgreSQL and MySQL as well as NoSQL databases familiarity with ETL and ELT tools and data integration practices understanding of data mesh and data product methodologies experience with cloud data platforms such as Snowflake and AWS Redshift is highly desirable and knowledge of data governance metadata management and master data management principles Strong analytical problem solving and communication skills are also required