Data Management Undergraduate Summer Internship

Job Description

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, Coralville, IA or Westwood, 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 2026 and Spring 2027
• 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

About Us

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 statparenthood, 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.

Equal Employment and Opportunity Employer

Job Applicant Data Privacy Policy

Background Check

Any offer of employment is conditioned upon the candidate successfully passing a background check, which may include initial credit, motor vehicle record, public record, prior employment verification, and criminal background checks. Results of the background check are individually reviewed based upon legal requirements imposed by our regulators and with consideration of the nature and gravity of the background history and the job offered. Any offer of employment will include further information.