Description
Data Modeller
London (remote initially)
3 months+
£400pd - £450pd Outside IR35
My client, a global consulting firm, are looking to recruit a Data Modeller for an Outside IR35 contract role for an initial 3 months period. The role will be working remotely initially.
Significant proven experience (10+ years) 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, Snowflake
Evaluate existing data models and physical databases for variances and discrepancies
Experience with managing meta data for data models
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
Cross industry experience is preferred, Quick service restaurant/Retail will be preferred
Datamodelling experience across large volume based (Tb/Petabytes) environments
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)
Strong skills in Entity Relationship Modeling (ERWin modelling software preferred)
Good knowledge about Database Designing/Administration, Advanced Data Modeling for Star Schema design
SQL query development for investigation and analysis
Experience with Data Profiling Tools and BI tools like MicroStrategy will be plus