Data Management Undergraduate 2027 Summer Intern

Citizens Bank; Johnston (RI); Hybrid; USD 34,000 - 49,000; Full time

Benefits offered by this job

Competitive pay

Medical, dental and vision coverage

Retirement benefits

Flexible work arrangements

Education reimbursement

Job summary

Citizens Bank offers a Data Management Undergraduate Internship as a 10-week summer program. Interns split time between partner teams on data quality, metadata management, ETL support, and cloud-based tools, plus a cross-functional capstone project.

Expect to work 40 hours per week in a hybrid setup across headquarters in Columbus, OH, Johnston, RI, or Boston, MA. Starting pay is $30 per hour, with a comprehensive benefits package.

Qualifications

• Pursuing a bachelor’s degree in a technology-related field such as computer science, information systems, statistics or engineering.
• Expected graduation between December 2027 and Spring 2028.
• Minimum GPA of 3.0.
• Experience with raw and prepared datasets and data governance concepts.
• Proficiency in SQL and Python; Excel; exposure to Pandas is a plus.

Responsibilities

• Support data management systems and workflows to meet business needs.
• Develop and optimize SQL queries for ETL processes.
• Triage data quality or integrity issues promptly.
• Work with internal repositories to collect and analyze relevant datasets.
• Collaborate with stakeholders to refine solutions and maximize business impact.
• Present project outcomes and insights to peers and leaders.

Skills

SQL

Python

Microsoft Excel

Pandas

AWS

JSON

YAML

Education

Bachelor’s degree in computer science or related tech field

Tools

Amazon S3

Redshift

SageMaker

DBeaver

Starburst

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

What you’ll need to apply

Basic Qualifications:

• 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

The position offers $30 per hour as a starting rate.

• We offer competitive pay, comprehensive medical, dental and vision coverage, retirement benefits, maternity/paternity leave, flexible work arrangements, education reimbursement, wellness programs and more.

• Note, Citizens’ paid time off policy exceeds the mandatory, paid sick or paid time-away policy of every local and state jurisdiction in the United States.

• For an overview of our benefits, visit https://jobs.citizensbank.com/benefits

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.

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.

Hours and Work Schedule

Hours per Week: 40

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

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.