Data Modeller | On-site role | W2 Contract.

We are looking for an experienced DataModellerto design develop and maintain enterprisedatamodels that support business intelligence analytics reporting and operational applications. The role involves translating business requirements into conceptual logical and physicaldatamodels while ensuringdataquality consistency scalability and governance.

TheDataModeller will work closely with Business Analysts Data Engineers Solution ArchitectsDatabase Administrators and business stakeholders to create robust and scalabledataarchitectures.

Key Responsibilities:

• Strong understanding of Conceptual Logical and PhysicalData Modelling.
• Strong knowledge of RelationalDataModelling and ER Modelling.
• Experience with DimensionalDataModelling.
• Good understanding of normalization and denormalization techniques.
• Experience designing Star and Snowflake schemas.
• Understanding of slowly changing dimensions (SCD) fact tables dimension tables and surrogate keys.

• Strong SQL skills.
• Good knowledge of relationaldatabases such as:
  • PostgreSQL
  • Oracle
  • SQL Server
  • MySQL
  • Snowflake
• Understanding ofdatabase performance indexing partitioning and query optimization.
• Knowledge ofdatabase constraints and referential integrity.

• Experience withdatawarehouse anddatalake concepts.
• Understanding of ETL/ELT processes anddataintegration.
• Experience with one or more clouddataplatforms such as:
  • AWS
  • Microsoft Azure
  • Google Cloud Platform
• Exposure to platforms such as SnowflakeDatabricks Azure Synapse BigQuery or Amazon Redshift is desirable.

Experience with one or more of the following:

• ErwinDataModeler
• ER/Studio
• SAP Power Designer
• Oracle SQL DeveloperDataModeler
• Sparx Enterprise Architect
• Lucid chart
• Microsoft Visio

• Bachelors or masters degree in computer science Information TechnologyDataManagement or a related field.
• 510 years of experienceindatamodellingdatabase designdata warehousing or related roles.
• Experience working on enterprisedataplatforms and large-scaledataprojects.
• Experience working in Agile/Scrum environments is preferred.