Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailRole Data Architect with ETRM (Energy Trading and Risk Management)
Location Houston TX(Onsite)
Job Description:
Data Architect with ETRM (Energy Trading and Risk Management)
Look from oil and gas company background will be a good fit.
Role Description : Data Architect 10 to 15 years of experience
The key responsibilities will be
Develop data architecture and lead the delivery of endtoend 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)
Develop physical data modelling and database designs.
Design databases to meet and exceed different non fictional requirements High availability zero data loss cyber security high resilience high performance structured and unstructured data time series data with resolution of as low as 10 ms huge volumetric.
Design data migration data quality solution.
Support Business Analysts and Solutions architects to design the systems.
Conduct Database activities such as database creation management testing programming on database data engineering reverse data engineering reporting analytics data migration etc based on project requirement
Lead data engineers/development to implement the solutions as per design
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 ( AsIs and ToBe ) 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 oracle db based forecasting solution hosted in cloud.
Experience/knowledge on Talend ADF and SOA based data integration
Experience in implementation of reporting and visualization solution using Power BI
Full Time