Data Science Intern, Interconnection & Transmission

Doist; Scottsdale (AZ); On-site; USD 28,000 - 41,000; Full time

Job summary

Arevon is recruiting for a Data Science Intern, Interconnection & Transmission, to support data collection, organization, and maintenance across multiple systems. You will transform data into usable databases and assist in automating data extraction and mapping for interconnection projects.

The role emphasizes Python and SQL proficiency, data management, and collaboration with teams handling ISO/RTO queue filings and transmission analytics, enabling hands-on exposure to power systems and project

Qualifications

• 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.
• Prefer general understanding of electric grid fundamentals, power systems, ISO/RTO interconnection processes or transmission planning concepts.
• 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.

Responsibilities

• 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.

Skills

Python

SQL

Data analysis

Analytical thinking

Excel

Data management

Communication

Education

Bachelor's or Master's in Electrical Engineering/Computer Engineering/Computer Science/Data Science/Mathematics/Statistics or related

Tools

Pandas

NumPy

GIS

Power BI

Tableau

PSS E/TARA

PROBE

SQL databases

ETL

Job description

About Arevon Arevon is a U.S. energy leader committed to powering America with affordable, reliable, and secure homegrown energy. Headquartered in Scottsdale, Arizona, and with a regional office in New York City, the company’s experienced and dedicated team develops, finances, builds, owns, and operates renewable energy projects nationwide. With a strong track record in utility-scale solar and energy storage, Arevon is a trusted partner to utilities and businesses seeking cost-effective, sustainable energy solutions. By prioritizing American manufacturing and domestic energy production, the company invests in U.S. jobs, strengthens local economies, and advances the country’s energy independence.

The Position Arevon is recruiting for the position of Data Science Intern, Interconnection & Transmission, an outstanding opportunity for individuals seeking an exciting, high-growth work environment in one of the most important industries for the 21st century. The Data Science Intern will support the Interconnection and Transmission teams by ensuring accurate collection, organization, and maintenance of critical data across multiple systems. This role will focus on collecting, compiling, and/or sourcing data/information from multiple sources, transforming it into useable database(s). The role will also provide an opportunity to gain an understanding of how data can be used across various cutting-edge tools used in the electric generation and transmission industry.

Projects

• 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.

Key Responsibilities

• 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.

Required Qualifications

• 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.
• Prefer general understanding of electric grid fundamentals, power systems, ISO/RTO interconnection processes or transmission planning concepts.
• 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 Qualifications

• 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.

Equal Opportunity Employer Statement

Arevon is an equal opportunity employer committed to fostering a diverse and inclusive workplace.

We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected characteristic under applicable law.

We encourage candidates of all backgrounds to apply.