Operations Developer - Retail Energy Trading
Current
New York, New York, United States
-Retail energy team's sole software & data engineer-Perform data analysis & subsequently data engineering for the retail energy business.-Develop and design Tableau & Power BI dashboards(BI reporting) that overview the general health of the retail business. This includes: profit & losses, date level filtered financial reporting, retail team efficiency, retail operations, and a weekly scorecard. Also work with Settlements, Tax Operations, Compliance & a variety of other teams to provide self-service data ingestion in Tableau & Power BI as well as automated data service using Python.-Develop data pipelines for Tableau. Connecting AWS, FTP files, & Microsoft SQL Server to our Tableau server.-Assist in developing data pipelines in Databricks, communicating with third party vendors in order to ensure proper data architecture and validation checks.-Utilize Visual Studio Code and Python in order to automate business operational processes for the retail energy team. (ex: Automated emails with embedded HTML & CSS, Notifications triggered by different data control charts, Automatic pricing and historical usage requests for potential clients).-Develop a variety of SQL queries in order to pull & analyze data in Microsoft SQL Server & Databricks. Furthermore, transform this data using Pandas & NumPy in Python in order to provide analysis that is easy to interpret and actionable.-Upon request, analyze and validate usage and trade data for the trading team.