This power data would fit nicely into an ETL (Extract, Transform, Load) process. ETL is a mature technology with excellent tools available.
For example, my latest project was to read a data feed of insolvent companies and compare it to online trademark data. Each day it produces a new list of trademarks which have become available.
This is just one example of how ETL works great at data processing and provides a much more robust solution than custom code. Most freelancers will quote you based on custom code which is hard to maintain and rigid to adapt as you grow.
Here are some standard ETL functions we would use.
- Scheduling (hourly)
- Download the AESO data
- Transform the AESO data into CSV
- Store to the OneDrive using REST
The tool I provide would also allow you to implement analytics, send email alerts, upload to FTP, compare against a historian or database, link to spot prices, etc. These modifications can be "drawn" into the ETL transform as additional ETL steps.
If you are interested, we could do this as a fixed-price contract rather than hourly. The scope you have provided is clear and I can provide a direct quote.
I am located in Alberta, Canada and have worked with clients worldwide for twenty years. I am an English speaking freelancer and can bring creativity, dedication, and a wealth of experience in the computing industry to your project.
Thank you for your consideration. Please contact me to discuss my bid further.
Best regards,
Jay