Senior Data Modeler - Surrey - £400pd (Outside IR35)

Job type:
on-site
Start date:
ASAP
Duration:
6 months
From:
Third Nexus
Location:
Surrey
Published at:
05/04/2021
Country:
flag_no United Kingdom
Project ID:
2105004

Warning
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Senior Data Modeler

Surrey - Remote only till pandemic

Rate: £400 per day (Outside IR35)

6 months+

Job Description:

Qualifications:

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 modelling tools - eg, 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 modelling 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