Citizens is looking to develop the next generation of colleagues by supporting innovative data & analytics initiatives across the bank, aiming to keep customers at the center of everything they do.
Requirements
- 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
- 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
- Experience working with raw as well as prepared datasets
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 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
Other
- 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
- 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
