Data Management Undergraduate 2027 Summer Intern

About the Role

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. This 10‑week summer internship supports innovative data & analytics initiatives across the bank.

Experience During the Program

The program offers a dual experience. Interns spend half of their time partnered with a host team within the data & analytics community, working on assignments such as data quality monitoring, metadata management, ETL support, data integration, SQL development, cloud‑based data tools, and exploratory data analysis—including reporting, dashboarding, and ad‑hoc investigations. The other half is spent on a cross‑functional team with other Data & Analytics interns, colleagues, and business partners to deliver a real‑world project that spans the full project cycle. Past projects have focused on enhancing the customer experience, optimizing business spend, identifying new market opportunities, providing business insights, model development, and engineering metrics & dashboarding.

Responsibilities

• 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 proactively.
• Work hands‑on with internal data repositories to collect, organize, and analyze relevant datasets.
• Collaborate with stakeholders to gather feedback and refine solutions for maximum business impact.
• Present final project outcomes and insights to peers and business leaders as part of a capstone presentation.
• 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

• Currently pursuing a bachelor’s degree in computer science, information systems, statistics, engineering, or other technology‑related fields.
• Expected graduation between December 2027 and Spring 2028.
• Minimum GPA of 3.0.
• Experience working with raw and prepared datasets.
• Understanding of master data management principles and processes.
• Proficiency with SQL, Python, Microsoft Excel, and exposure to libraries such as Pandas.
• Familiarity with cloud computing environments (e.g., AWS), APIs, and structured data formats like JSON and YAML.

Preferred Qualifications

• Experience in data analysis and interest in data governance, including data quality, consistency, integrity, and security.
• Familiarity with data architecture concepts such as data pipelines, cloud storage, and data modeling.
• Exposure to tools such as Amazon S3, Redshift, SageMaker, DBeaver, or Starburst.
• Understanding of ETL concepts and their role in data integration and pipeline development.
• Demonstrated ability to thrive in diverse team environments and collaborate effectively.
• Strong written and verbal communication skills for conveying analytic results to non‑technical audiences.
• Solid analytical reasoning and problem‑solving abilities.
• Curiosity, initiative, and a proactive approach to learning and asking thoughtful questions.
• Resilience and drive to work through challenges and adapt to feedback.
• Technical familiarity with Amazon Redshift, Snowflake, Amazon S3, Alteryx (experience a plus).
• Eagerness to learn from mentors and grow technical and business acumen through hands‑on project work.

Hours and Work Schedule

• 40 hours per week.
• Monday – Friday, 8:30 am – 5:00 pm.

Location

Hybrid work structure with onsite presence at one of our headquarters in Columbus, OH; Johnston, RI; or Boston, MA.

Work Authorization

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.

Why Work for Citizens

Citizens offers a customer‑centric culture focused on helping customers and giving back to local communities. Employees benefit from a supportive and collaborative workforce, access to training and tools to accelerate potential, and opportunities for career growth.