Student Intern - Data Architecture and Automation

ISO New England is the independent system operator responsible for ensuring the safe and reliable flow of electricity in our region and planning for the future of the electric grid. We are at the forefront of New England’s ongoing transition to clean energy.

Internship Title – Data Architecture and Automation

Department – Architecture and Data Governance

Minimum Education Level: Senior

Preferred Majors: Computer Science, Information Systems, Data Science

Get hands-on with the tech that keeps everything running! You'll help clean, streamline, and automate data processes, boosting accuracy and efficiency across IT systems. Build real-world skills and automation, problem-solving, and data management while making a direct impact on smarter, faster operations.

Who We Are

ISO New England is one of the most pivotal energy companies you may have never heard of. Our job is to oversee the 24/7 operation of the power grid that covers the six states of New England and to administer the region’s $ 10 billion-plus “stock exchange” for the buying and selling of wholesale electricity. Our work ensures that over 14 million people can reliably turn their lights on and complete their jobs, take care of their families, and live in comfort with convenience.

Department Description

The Architecture team at ISO New England plays a pivotal role in aligning technology solutions with business needs and managing the repositories of information that describe the ISO's IT ecosystem. The key part of this work includes overseeing data entry and data quality in the configuration management database (CMDB) - a critical tool for IT operations and change management. The team ensures data accuracy, consistency, and availability for many objects within the CMDB.

About the Internship

This internship will focus on improving the quality, consistency, and efficiency of CMDB data entry, updates, and reviews through workflows and automation. Currently, the CMDB tool lacks strict enforcement of data formats and relationships, which makes it challenging to maintain integrity across the system. The intern will help address these challenges by designing and implementing improvements that reduce manual effort, streamline processes, and enhance user experience.

What You’ll be Working On

- Analyze current CMDB data entry and update processes, identifying areas for improvement.

- Develop workflows and automation tools using Microsoft Forms, Power Automate, or similar platforms to enforce data consistency.

- Create scripts and queries in Python, Java, and post grey SQL to manipulate and standardize data.

- Collaborate with internal teams to understand their needs and translate requirements into practical solutions.

- Improved reporting and analysis capabilities through Excel and database queries.

- Enhanced user experience is creating intuitive and efficient processes.

How You’ll Make an Impact

You'll help improve the accuracy and reliability of critical data that drives technology decisions by streamlining processes and building automation solutions. Your work will boost efficiency, reduce errors, and support smarter, faster IT operations, all while giving you hands-on experience and shaping the backbone of enterprise systems.

What We Look For in a Candidate

- Familiar with Python or Java, and experience querying PostgreSQL databases.

- Strong skills and Excel and data manipulation for standardization.

- Experience or interest in learning workflow automation tools such as Microsoft Forms and Power Automate.

- High attention to detail with strong focus on accuracy.

- Excellent communication skills and a customer-focused mindset.

- A passion for improving user experience and process efficiency.

What You'll Gain

- Hands-on experience in data management, workflow automation, and user-centric design.

- Exposure to enterprise IT operations and architecture.

- Experience with stakeholders to identify and implement process improvements.

- Opportunity to contribute directly to ISO New England by reducing manual workload for senior staff -freeing time for strategic initiatives.

- A tangible impact on the organization's ability to rely on an accurate, high-quality CMDB database for better decision making.

This employer will not sponsor applicants for work visas for this position (ex: H-1B, F-1/CPT/OPT, O-1, E-3, TN, J, etc.).

#LI-DNP

This is a U.S. based role. If the successful candidate resides outside of the U.S., relocation will be required.

To be eligible for the internship candidate must have completed at least the first year of college and be currently enrolled in a four year or graduate-level academic program. Candidates must have the authority to work in the US on a permanent basis, without requiring sponsorship.

Equal Opportunity: We are proud to be an EEO employer. Applicants for employment are considered without regard to race, color, religion, creed, sex (including pregnancy, childbirth, and related medical conditions), gender identity or expression, sexual orientation, citizenship, national origin, age, ancestry, marital status, disability (including learning, mental, intellectual, and physical), service in the uniformed services, genetic information, or any other status protected by applicable law.

Drug Free Environment: We maintain a drug-free workplace and perform pre-employment substance abuse testing.