Data Architect

Provide Data Architects that have Allegro and Endur ETRM experience to help create conceptual and logical data models for all required data products (by ETRM) in preparation for building. For the initial three-month period, a Subject Matter Resources (SMRs) may be engaged to assist in the development of the POD framework for data products and to establish the trading operating model.
·        Develop data architecture and lead the delivery of end-to-end data, integration, reporting solution for Utilities Systems cloud and hybrid hosting
·        Analyze business requirements, conduct data & integration impact analysis.
·        Develop enterprise data landscape, conceptual data model and logical data model
·        Understanding of data requirements for ETRM systems and associated data structures (Risk, Pricing, Contracts etc)

requirements – High availability, zero data loss, cyber security, high resilience, high performance, structured and un-structured data, time series data with resolution of as low as 10 ms, huge volumetric.

·        Support Business Analysts and Solutions architects to design the systems.

Mandatory data skills
Data and Integration Architecture
Expertise in one or many of below
Oracle/MySQL database design and development
Mongodb /Casandra design and development
Azure Data Architecture
Excellent stakeholder communication skills
Ability to lead and guide data team in the project/program and get the work done.
Data Landscape ( As-Is and To-Be ) and Data Flows
Conceptual Data Model and Canonical Modelling 
Logical Data Model and Physical Data Model
Data Definition and Integration specification
DDL , DML , DCL , TCL concepts and scripting
Data engineering and reverse data engineering
Master Data and Data Management
Data Entity to Application mapping - Master , Create , Update , Read & Delete
Requirements analysis , data impact analysis , integration impact analysis
Data Entity and Attribute Definition Data constraints, validation rules , consistency and defaulting rules Tools Sparx EA , SQL developer , Toad etc.
Database programming - PL/SQL and similar ones
Application of Data science for energy/electricity forecasting
Experience in architecting Python, R , Mongo DB, and oracle db-based forecasting solutions hosted in the cloud.
Experience/knowledge on Talend, ADF and SOA-based data integration
Experience in the implementation of reporting and visualization solutions using Power BI