Job title: Senior Data Modeler
Job type: Contract
Emp type: Full-time
Pay interval: Daily
Pay rate from: GBP £400.00
Pay rate to: GBP £400.00
Job published: 28/04/2021
Job ID: 32231
Contact name: Dr Sanjeev Mehta
Contact email:

Job Description

Job Title- Senior Data Modeler

Client-Global Consulting Firm

Rate: £400 per day (Outside IR35)

Duration-6 months (Extendable)

Location: Surrey-Remote only till pandemic

Job Description:

Total Experience: 8 – 10 years


  • Significant proven experience in applying rigorous data management principles and industry standard development approach to model complex and high-volume data assets to build, maintain conceptual, logical, and physical data models
  • Demonstrable experience using data modeling tools - e.g., ErWin , SQLDBM
  • Evaluate existing data models and physical databases for variances and discrepancies
  • Experience with managing meta data for data models
  • Demonstrable experience in developing, publishing, and maintaining all documentation for data models
  • Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
  • Create entity-relationship diagrams for relational systems and dimensional diagrams for the existing and proposed Data Warehouse, Data Marts, and data cubes
  • Define ownership, obtain approvals, and communicate data models to Technology teams. Ensure consistent enterprise view and usage of data assets across the global functions and standards
  • Provide architectural expertise in Data warehouse construction and engineering, data source identification, engineering, and migration on latest DB technologies – Snowflake
  • Provide feedback to Business Intelligence project and management team to improve data acquisition (structured and unstructured), warehousing methodologies and tools
  • Experience in Agile development processes
  • Ability to independently learn new technologies and data related approaches
  • Effective writing and presentation skills
  • Excellent problem solving skills, should possess a consulting mindset
  • Cross industry experience is preferred

Technical Skills

  • Data Modeling concepts (Advanced Level)
  • ErWin, Snowflake, DB/MS SQLServer
  • Modeling experience across large volume based (Tb/Petabytes) environments
  • Over-All understanding of Database space (Databases, Data Warehouses, Reporting, Analytics)
  • Open to learn new technologies in-line with organizational needs / direction
  • Experience with the technologies in the Hadoop ecosystem like Hadoop, HDFS, Spark, and Hive is a plus
  • Experience in working with modern cloud data platforms in AWS (preferred)
  • Well versed with Data Modeling platforms like Erwin, ER STUDIO etc.
  • Strong skills in Entity Relationship Modeling (ERWin modeling software preferred)
  • Good knowledge about Database Designing / Administration, Advanced Data Modeling for Star Schema design
  • Good understanding of Normalized / Denormalized / Star / Snowflake design concepts
  • SQL query development for investigation and analysis
  • Experience with Data Profiling Tools and BI tools like MicroStrategy will be plus