Tasks/Expectations
-
Develop understanding of power related data sets and flows
-
Document relationships between power related datasets (annotated screenshots of data canvas are sufficient)
-
Work closely with data engineering resources and data scientist resources to ingest required data into spotfire
-
Evaluate what data needs preprocessing and what can be done in spotfire
-
Make recommendations for data ingestion not currently obtained by XOM
Data-sets Required
-
Power Related Billing Data (ODS -> Capturis, SQL Server Endpoint -> Scraped Billing Data)
-
Power Usage Data (ODS Smart Meter Texas, ADX -> Ignition Data)
-
ERCOT Pricing Data (ODS ercot schema)
-
Weather Related Data (API)
Skillset
-
Code development with various tools like, Python, Spotfire, PowerBI
-
Experience in developing data flow concepts with data pulled from various equipment monitoring sources
-
Ability to develop architectural drawings representing system interfaces, data sources, output/reporting
-
Ability to work with data engineers and architects to develop a system that collects, interprets, monitors, and manages power type data collected from various power equipment sources