Sr Data Analyst- Data Lake

The Senior Data Analyst is responsible for ensuring the integrity, quality, and accessibility of data in to Citizens Data Lake. This role involves leading data management initiatives, developing data governance strategies, and ensuring data systems and processes support business needs. This role involves managing data resources, developing data management strategies, and supporting data-related projects. The Data Analyst will work closely with various departments to ensure data is properly maintained, analyzed, and utilized to support business objectives.

Primary responsibilities include

• Design, develop, and maintain data management systems and processes for Citizens Data Lake.
• Oversee the collection, integration, and maintenance of data from multiple sources in to a AWS data lake. Ensure data quality, consistency, and security across all databases and systems.
• Collaborate with IT and business partners to understand data requirements and deliver solutions.
• Manage and optimize databases and data warehouses to ensure efficient data storage and retrieval. Monitor and optimize data storage, backup, and recovery processes. 
• Identify and resolve data-related issues in a timely manner.
• Write and refine complex SQL queries for data extraction and transformation.

Qualifications, Education, Certifications and/or Other Professional Credentials

• Solid understanding of consumer banking/financial products and business processes
• Strong SQL knowledge is required.  
• Scripting experience in SAS or python is a plus. 
• Experience working in cloud environments, ideally AWS. 
• Experience doing data discovery and analysis work with one or more commonly-used business intelligence tools, such as Tableau, SAS, Oracle, Microsoft, etc. 
• Experience working with various operating systems (Windows, Unix/Linux) and database management systems (Redshift, Oracle, MS-SQL, etc).
• Ability to collaborate effectively, take initiative and work as part of a team
• Strong attention to detail, communicate clearly.
• Bachelors degree in Computer Science, Data, or a similar technical field. 
   
   

Equal Employment Opportunity

Citizens, its parent, subsidiaries, and related companies (Citizens), provides 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, transgendered and transitioning individuals, 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 colleagues to bring their best selves to work every day and where all are expected to be treated with respect and professionalism. Employment decisions are based solely on experience, performance, and ability. We perform our best so we can do more for our customers, colleagues, communities and shareholders.

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.