Ruby Energy
Consultancy role for Data Engineering with the Microsoft Fabric platform
Hybrid (mainly remote)
Ruby Energy is a supplier of gas and electricity to the commercial market. They wanted to investigate and validate their legacy costing process, which consolidated past present and predicted data from a large number of disparate sources, so they might forecast expected fuel costs for the next few years to provide their customers with accurate fixed charge contracts.
Their existing process was manually intensive, using tools such as Excel, ultimately sored in SQL Server. It was slow, inaccurate, couldn’t be scheduled, and lacked an audit trail. They also lacked a safe data visibility platform.
They approached me to investigate use of Microsoft Fabric for ingestion, processing, analysis, and distribution.
Whilst the business wasn’t able to move to a Microsoft Fabric solution immediately, the contract documented and highlighted issues with the existing system and paved the way for a future Fabric implementation, and I demonstrated how they may be able to do this and the benefits of using Fabric for their processes.
- Technical Consultancy
- Legacy process investigation of existing cost stack
- Recommendations regarding ETL, security, and prediction mechanism for the cost stack using Microsoft Fabric
- Microsoft Fabric implementation
- Demonstrations of Fabric features
- Python notebooks
- Dataflows
- Data Pipelines
- Monitoring
- Deployment pipelines
- Source control integration
- Workspace and object level security
- Power BI