Description
Based in Dublin City Centre. Must be available for face to face interview withing 1-2 days. Logical and Physical Data Architecture Analysis. Microsoft Suite SSIS, SQL Server
Manage Guidelines and Best Practices for Datamodelling and database server and query optimisation
Assist & support other teams (mainly Development and QA) and provide mentoring expertise to developers
Knowledge of and experience applying No SQL design and integration with relational and reporting systems
Requirements:
Minimum of five years of leadership experience in data design and administration, architecture, and reporting
Experience with Data Analysis and Data Profiling
Hands on experience indexing, partitioning and data design performance considerations for industry standard DBMS (SQL Server)
Understanding of data warehousing design and development best practices
Understanding of ETL design and development best practices
Strong Datamodelling skills, including a deep understanding of relational and multi-dimensional database designs and the normalization levels of operational data stores and data marts
Experience of interfacing with project management
Ability to write moderate to complex database queries needed to investigate data issues, repair damaged data, and migrate data to new structures.