Diverse Lynx
Data Architect with ETRM @ Houston, TX
Diverse Lynx, Houston, Texas, United States, 77246
Role - Data Architect with ETRMLocation: Houston, TXType: Contract
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 end-to-end data, integration, reporting solution for Utilities Systems cloud and hybrid hosting• nalyze 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 un-structured 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 skillsData and Integration ArchitectureExpertise in one or many of belowOracle/MySQL database design and developmentMongodb /Casandra design and developmentAzure Data ArchitectureExcellent stakeholder communication skillsAbility to lead and guide data team in the project/program and get the work done.Data Landscape ( As-Is and To-Be ) and Data FlowsConceptual Data Model and Canonical ModellingLogical Data Model and Physical Data ModelData Definition and Integration specificationDDL , DML , DCL , TCL concepts and scriptingData engineering and reverse data engineeringMaster Data and Data ManagementData Entity to Application mapping - Master , Create , Update , Read & DeleteRequirements analysis , data impact analysis , integration impact analysisData 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 onesApplication of Data science for energy/electricity forecastingExperience in architecting Python, R , mongo db, oracle db based forecasting solution hosted in cloud.Experience/knowledge on Talend , ADF and SOA based data integrationExperience in implementation of reporting and visualization solution using Power BI
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
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 end-to-end data, integration, reporting solution for Utilities Systems cloud and hybrid hosting• nalyze 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 un-structured 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 skillsData and Integration ArchitectureExpertise in one or many of belowOracle/MySQL database design and developmentMongodb /Casandra design and developmentAzure Data ArchitectureExcellent stakeholder communication skillsAbility to lead and guide data team in the project/program and get the work done.Data Landscape ( As-Is and To-Be ) and Data FlowsConceptual Data Model and Canonical ModellingLogical Data Model and Physical Data ModelData Definition and Integration specificationDDL , DML , DCL , TCL concepts and scriptingData engineering and reverse data engineeringMaster Data and Data ManagementData Entity to Application mapping - Master , Create , Update , Read & DeleteRequirements analysis , data impact analysis , integration impact analysisData 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 onesApplication of Data science for energy/electricity forecastingExperience in architecting Python, R , mongo db, oracle db based forecasting solution hosted in cloud.Experience/knowledge on Talend , ADF and SOA based data integrationExperience in implementation of reporting and visualization solution using Power BI
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.