Citizens is looking to foster a data-driven culture and support innovative data & analytics initiatives by providing undergraduate interns with hands-on experience in data management and analysis.
Requirements
- 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
- 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
- Understanding of ETL (Extract, Transform, Load) concepts and how they support data integration and pipeline development
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
- Successfully complete a video interview assessment within 4 days of receiving the link.
- Team Collaboration: Demonstrated ability to thrive in a team environment and collaborate effectively with colleagues from diverse backgroun
