Heading

Scottsdale, AZ

Internship

Onsite

Intern

Arevon is a U.S. energy leader that develops, finances, builds, owns, and operates renewable energy projects, with a focus on utility-scale solar and energy storage. The Data Science Intern will support the Interconnection and Transmission teams by collecting, organizing, validating, transforming, and automating data processes related to electric grid interconnection queues, transmission projects, and operational analytics.

Apply Now

Responsibilities

Map Eastern Interconnection (EI) and Western Electricity Coordinating Council (WECC) Generation Interconnection Queues (GIQ) and transmission projects to raw source files
Aggregate, map and process regional ISO/RTO queue filings, tracking project statuses (e.g., active, under study, withdrawn, operational) and Interconnection customer data
Develop a change-set tracker to monitor changes in transmission object characteristics - Line Status, impedance, voltage Magnitude, Bus Angle, etc.- between various study cases
Assist in automating data extraction, web scraping, mapping, change-detection processes across all core interconnection projects
Extract, update and validate electrical topology, system study cases and GIQ data
Parse regional queue applications, commercial operation dates, capacity values, resource types (solar, wind, storage, thermal) to maintain a unified data pipeline
Identify opportunities to automate data ingestion from grid operator portals (e.g., PJM, MISO, CAISO, SPP, ERCOT) and improve workflow efficiency. Maintain a systematic repository of data issues, study case mismatches, queue record discrepancies assisting in their resolution
Maintain and query backend databases that feed key operational dashboards, interconnection cost models and transmission analytics

Qualification

Required

* Currently pursuing a Bachelor's or Master's degree in Electrical Engineering, Computer Engineering, Computer Science, Data Science, Mathematics, Statistics, or a related technical discipline
* Proficiency in Python, SQL, or other programming languages used for data analysis and automation
* Strong analytical and problem-solving skills with the ability to interpret and organize complex datasets
* Experience working with Microsoft Excel and data management tools. Effective written and verbal communication skills
* Familiarity with relational databases and data transformation techniques. Ability to collect, clean, validate, and organize data from multiple sources. Strong attention to detail and commitment to data accuracy
* Ability to work independently while collaborating in a team environment

Preferred

* Prefer general understanding of electric grid fundamentals, power systems, ISO/RTO interconnection processes or transmission planning concepts
* Coursework or experience in electric power systems, transmission planning, data standardization, automation, or energy markets
* Experience with data analysis libraries such as Pandas, NumPy, or similar tools
* Familiarity with GIS, spatial data, or mapping tools
* Knowledge of power system modeling software such as PSS®E/TARA, PROBE, or similar applications
* Understanding electric transmission networks or utility operations
* Experience with SQL databases and ETL (Extract, Transform, Load) processes
* Experience developing scripts or automating repetitive data processing tasks
* Familiarity with version control on large databases
* Experience creating dashboards or reports using Power BI, Tableau, or similar visualization tools
* Previous internship, research, or project experience in the energy, utility, or renewable energy industry