Be responsible for the Institution's data model and perform data modelling work that enables production systems and applications to use data and drive business processes.
Be the Service Owner and Subject Matter expert for data warehousing, analytics and reporting.
Take control of Institution’s underlying data structures and techniques required to support its complex financial and economic analysis and reporting.
Oversee Institution's wide data governance, assuring project design against transitional and target data architecture states (including offsite outsources teams).
Providing direction to Solution Designers and Database Administrators.
Mentoring of team members, outsource companies and Change Delivery teams in the use of semantic models.
Building composite views from multiple data sets for IT and the Business; for the Subject Matter Expert and service owner for master data management.
Evaluate existing data models and physical databases for variances and discrepancies.
Validate business use cases for accuracy and completeness of proposed data models.
Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models.
Perform reverse engineering of physical data models from databases and SQL scripts.
Work closely with the business units to help them achieve their business goals by leveraging the technologies the Institution has, mentoring them and helping the IT team improve their Service Portfolio.
Supporting and contributing to the Institution's other oversight activities.
Qualifications
University or College degree in Computer Engineering, Computer Science or business administration or relevant field
At least 9 years of professional experience (following the award of the diploma);
Minimum 6 years of experience in Data Architecture and Data Modelling for transactional systems;
Experience with RUP or comparable systems engineering disciplines.
Experience working with other Data Architects and Business Intelligence Architects to evolve the Agency’s data architecture;
Large organization experience.
Advanced level knowledge and understanding of application design, systems engineering and integration, in particular in the areas related to the key responsibilities described;
Experience in data design governed by Enterprise Data Architecture is desirable, preferably using TOGAF;
Experience with process modelling is an advantage;
Experience with the use of PowerDesigner and/or Sparx Enterprise Architect;