Data Modeler (SC Cleared)

We are seeking an experienced Data Modeler to join our team. The ideal candidate will have expertise in both Logical and Physical Data Modelling and a strong understanding of Microsoft Dynamics and PostgreSQL . This role is critical to designing, optimizing, and maintaining data models to support high-performance querying and seamless integration between Dynamics and PostgreSQL. Key Responsibilities: Develop logical data models that represent the structure of data, ensuring alignment with business processes and data flow. Translate logical models into physical PostgreSQL schemas , designing tables, relationships, and attributes that reduce redundancy and enhance data integrity. Collaborate on the creation of a Logical Data Model (LDM) , ensuring reusability of the existing data model as part of the solution. ETL Processes : Work on extracting, transforming, and loading data from Microsoft Dynamics into PostgreSQL efficiently. Utilize PostgreSQL-specific features like JSONB, array types, CTEs, and window functions to handle complex data structures. Query Optimization : Improve query performance through indexing, partitioning, and choosing appropriate data types. Ensure that the data model supports high data volumes and high-performance querying, especially for reporting and analysis purposes. Understand business needs to model relevant entities, considering data changes over time and relationships impacted by business rules. Required Qualifications: Must hold SC clearance . Proven experience in logical and physical data modelling , especially with Microsoft Dynamics and PostgreSQL . Proficiency in SQL and experience with PostgreSQL features such as JSONB and array types. Strong knowledge of ETL processes and experience integrating Microsoft Dynamics data with PostgreSQL. Experience in query optimization , indexing, and performance tuning in large data environments. Familiarity with PostgreSQL data types and schema design to support dynamic, complex data structures. Location & Work Environment: This role is based in Canary Wharf, London , with the flexibility of working 3 days in the office . Contract Terms: Initial contract duration is 6 months , with a possibility of extension based on project needs. If you’re a Data Modeler with a passion for creating optimized and scalable data models, we’d love to hear from you Please submit your CV to be considered for this opportunity.