Data Management Undergraduate 2027 Summer Intern

Citizens; Johnston (RI); Hybrid; USD 25,000 - 36,000; Full time

Job summary

Citizens in Johnston, RI invites motivated undergraduates to join a 10-week Data Management Undergraduate Internship as part of its Enterprise Data and Analytics Early Career Program. Interns split time between host teams and cross-functional project work, gaining hands-on experience across data quality, ETL, SQL development, cloud data tools, and analytics lifecycle.

Participants collaborate with data partners to deliver meaningful insights, build dashboards, and contribute to governance

Qualifications

• Currently pursuing a bachelor’s degree in computer science, information systems, statistics, engineering, or other technology-related degrees
• Expected graduation date between December 2027 and Spring 2028
• Minimum GPA of 3.0
• Experience working with raw as well as prepared datasets
• Proficiency with programming languages / tools: SQL, Python, Microsoft Excel, with exposure to Pandas
• Familiarity with cloud computing environments (e.g., AWS), APIs, and working with structured data formats like JSON and YAML
• Understanding of master data management principles and processes
• Experience in data analysis and an interest in learning data governance principles

Responsibilities

• Support teams responsible for data management systems and workflows that support business needs
• Develop and optimize SQL queries for ETL
• Troubleshoot and resolve data quality or integrity issues
• Work hands-on with internal data repositories to collect, organize, and analyze datasets
• Collaborate with stakeholders to gather feedback and refine solutions to maximize business impact
• Present final project outcomes and insights to peers and leaders as part of a capstone presentation

Skills

SQL

Python

Microsoft Excel

Pandas

AWS

Education

Bachelor’s degree in computer science / information systems / statistics / engineering or related tech field

Tools

Amazon S3

Redshift

SageMaker

DBeaver

Starburst

Snowflake

Alteryx

Job description

Description

Data Management Undergraduate Internship

We’re developing the next generation of Colleagues!

Join the data-driven culture at Citizens and learn how we keep customers at the center of everything we do. We are looking for interns to join our 10-week summer internship program and support innovative data & analytics initiatives across the bank.

Experience During The Program

Our program offers interns a unique dual experience – Participants spend half of their time individually partnered with a host team within the data & analytics community to participate in ongoing work. Assignments for data analyst interns may be in areas aligned to data quality monitoring, metadata management, ETL support, data integration, SQL development, cloud-based data tools, and exploratory data analysis- including tasks related to reporting, dashboarding, and ad-hoc investigations. This component of the program provides direct exposure to teams in areas that align to intern education and interests.

The other half of the time, interns work on a cross-functional team, collaborating with other Data & Analytics interns, colleagues, and business partners to work on a real-world project. Projects are tailored so interns can experience the full project cycle. Past projects centered on areas such as enhancing the customer experience, optimizing business spend, identifying new market opportunities, providing business insights, model development, and engineering metrics & dashboarding.

Interns are expected to adopt a hybrid work structure and work out of one of our headquarters in Columbus, OH, Johnston, RI, or Boston, MA.

Please note: This role spans multiple teams and business areas. As such, specific responsibilities and tools may vary depending on the host team. Interns will be matched with teams to ensure meaningful contributions and strong collaboration.

As a Data Management Intern, You Can Expect To

• Support teams responsible for data management systems and workflows that support business needs
• Develop and optimize SQL queries for efficient data extraction, transformation, and loading (ETL)
• Troubleshoot and resolve data quality or integrity issues in a timely and proactive manner
• Work hands-on with internal data repositories to collect, organize, and analyze relevant datasets
• Collaborate with stakeholders to gather feedback and refine solutions to maximize business impact
• Present final project outcomes and insights to peers and business leaders as part of a capstone presentation
• Work with teams responsible for maintaining the integrity of the organization's data systems
• Assist in monitoring data quality and apply measures that support accuracy and consistency
• Follow enterprise-wide data standards and governance practices, including metadata, master data, and policy management

Basic Qualifications

What you’ll need to apply

• Successfully complete a video interview assessment within 4 days of receiving the link. If not completed within the timeframe, your application will be automatically withdrawn from consideration
• Currently pursuing a bachelor’s degree in computer science, information systems, statistics, engineering, or other technology-related degrees
• Expected graduation date between December 2027 and Spring 2028
• Minimum GPA of 3.0
• Experience working with raw as well as prepared datasets
• Understanding of master data management principles and processes
• Proficiency with programming languages / tools: SQL, Python, Microsoft Excel, with exposure to libraries such as Pandas for data manipulation
• Familiarity with cloud computing environments (e.g., AWS), APIs, and working with structured data formats like JSON and YAML

Preferred Qualifications

• Experience in data analysis and an interest in learning data governance principles including data quality, consistency, integrity, and security to support high quality data systems
• Familiarity with data architecture concepts such as data pipelines, cloud storage, and how data is structured and integrated within an organization and awareness of data modeling concepts
• Exposure to tools such as Amazon S3, Redshift, SageMaker, DBeaver, or Starburst considered a plus
• Understanding of ETL (Extract, Transform, Load) concepts and how they support data integration and pipeline development
• Team Collaboration: Demonstrated ability to thrive in a team environment and collaborate effectively with colleagues from diverse backgrounds and business units
• Communication Skills: Strong written and verbal communication skills, with an ability to successfully communicate analytic results, business insights, and business impact to a non-technical audience
• Analytical Thinking: Solid analytical reasoning and problem-solving skills, with the ability to break down complex problems using logic and quantitative methods
• Curiosity & Initiative: A strong sense of curiosity and ownership, with a proactive approach to asking thoughtful questions, researching unfamiliar topics, and seeking clarity on project goals
• Resilience & Drive: Demonstrated persistence and tenacity—willingness to work through challenges, adapt to feedback, and stay focused on delivering results
• Technical Familiarity: Exposure to or interest in learning tools such as Amazon Redshift, Snowflake, Amazon S3, and Alteryx. Prior experience is a plus but not required
• Learning Mindset: Eagerness to learn from mentors and business partners, and to grow technical and business acumen through hands‑on project work

Find more information about Enterprise Data and Analytics Early Career Program HERE

Please note that permanent work authorization in the United States is required. This position is not eligible for CPT, OPT, or visa sponsorship, now or in the future.

Hours and Work Schedule

Hours per Week: 40

Work Schedule: M-F 8:30am - 5pm

Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance.

Equal Employment Opportunity

Citizens, its parent, subsidiaries, and related companies (Citizens) provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability, perceived disability or history or record of a disability, ethnicity, gender, gender identity or expression, genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family status/parenthood, medical condition, military or veteran status, national origin, pregnancy/childbirth/lactation, colleague’s or a dependent’s reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and/or local laws. At Citizens, we are committed to fostering an inclusive culture that enables all colleagues to bring their best selves to work every day and everyone is expected to be treated with respect and professionalism. Employment decisions are based solely on merit, qualifications, performance and capability.

Why Work for Us

At Citizens, you'll find a customer‑centric culture built around helping our customers and giving back to our local communities. When you join our team, you are part of a supportive and collaborative workforce, with access to training and tools to accelerate your potential and maximize your career growth

Posting End Date: 09/19/2026