Job Overview:Position Summary The SCADA Data & Reporting Analyst is responsible for developing and maintaining operational reporting solutions for the Remote Operations Control Center (ROCC). This position will collect, analyze, automate, and visualize operational data from SCADA systems, historians, HMIs, and other data sources to support renewable energy operations, executive reporting, site onboarding, and NERC compliance. The ideal candidate is highly analytical, detail-oriented, and experienced in Python, SQL, data automation, and business intelligence tools.
Primary Responsibilities - Develop and maintain daily, weekly, monthly, quarterly, and annual operational reports.
- Collect, clean, validate, and analyze data from SCADA systems, historians, HMIs, and operational databases.
- Develop automated Python and SQL scripts to collect, clean, organize, and prepare operational data from SCADA systems, historians, HMIs, databases, and APIs for reporting, dashboards, and analytics.
- Build dashboards using Power BI, Excel, or similar BI tools.
- Lead or assist with onboarding new renewable energy sites into the ROCC, including HMI integration, historian configuration, tag validation, data verification, and reporting setup.
- Maintain and troubleshoot data connections between SCADA systems, historians, HMIs, and reporting platforms.
- Analyze equipment performance, alarms, downtime, availability, curtailments, and production trends.
- Support operational investigations by collecting and organizing data.
- Assist with NERC compliance reporting and evidence collection.
- Develop SOPs, reporting documentation, and technical reference guides.
- Identify and implement automation, AI, and process improvement solutions to reduce manual reporting and improve operational efficiency.
- Collaborate with Operations, Engineering, IT, Asset Management, Compliance, and vendors.
Required Qualifications - Bachelor's degree in Data Analytics, Computer Science, Engineering, Information Systems, Mathematics, or equivalent experience.
- 2+ years of experience in data analytics, business intelligence, or operational reporting.
- Advanced Python programming skills.
- Strong SQL experience, including writing complex queries, joins, views, stored procedures, and optimizing database performance.
- Experience working with REST APIs.
- Experience with industrial historians (Ignition, PI, Canary, Wonderware Historian, or similar).
- Advanced Microsoft Excel skills including Pivot Tables, Power Query, and Power Pivot.
- Proficiency with Microsoft Office (Excel, Word, Outlook, PowerPoint).
- Strong analytical, troubleshooting, and communication skills.
- Excellent attention to detail and ability to manage multiple priorities.
Target Salary Range 90,000-110,000
Benefits:- Paid Company Holidays
- Paid Time Off
- Medical, Dental, Vision, FSA/HSA, Short Term/Long Term Disability
- 401K with matching contribution.
