Description At Citizens, we're more than a bank and here, you’ll experience new things, create new opportunities, think beyond your role and make an impact! In this Technology Services - Risk and Finance Senior Data Analyst position, you will work with internal clients to understand, define and document business requirements. You will utilize proprietary software to analyze and design technical solutions used to compile, load, and report data. Most importantly, you’ll feel valued for who you are and supported to achieve what’s important to you, personally, and professionally! Additional responsibilities will include: + Interpreting and translating business requirements into data requirements and linking them to mapping lineage documents used by developer colleagues. + Identifying data gaps that may exist between internal client needs against available information housed with the reporting data mart or data warehouse. + Profiling big data sources using SQL across a wide variety of different product “Systems of Record” to satisfy gaps in data requirements. + Leading team member discussions to determine the best data source options, requirements gapping, expected data content profiling, and source/transformation/target mapping. + Generating and documenting pseudo logic required to derive data attributes that need to be synthesized from existing base data elements. + Providing instruction and ongoing support to developer/programmer resources to ensure mapping documentation is clear and well understood. + Generating complex data queries to perform testing and validation checks as required to assist developers with production code migrations or post-prod validations. Experience and Skills: + 5+ years of work experience as a Business Analysts in a large data environment + Strong analytical and systemic thinking, problem solving, and SQL skills + Strong communication (written and verbal), presentation skills + Proven technical Documentation skills using MS Office 365 Suite + Demonstrated ability to manage multiple projects to completion + Self-Starter comfortable working independently or as part of a team + Desire to learn emerging methods and technologies and wanting to stay on top of latest ideas within the logical mapping design and development discipline + Experience with the following a plus, Snowflake, AWS Redshift, S3, Python, Oracle, SAS + Working knowledge of DBeaver, Athena, Aqua Data Studio or a comparable query tool to analyze data in a variety of DBMSs (Database Management Systems) Education and Certifications + Bachelor's Degree in Business, OIM (Operations and Information Management), Computer Science, or Mathematics. Hours & Work Schedule Hours per Week: 40 Work Schedule: Monday through Friday, 8:30AM – 5:00PM Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance. Equal Employment Opportunity At Citizens, we are committed to fostering an inclusive culture that enables colleagues to bring their best selves to work every day. Employment decisions are based solely on experience, performance, and ability. 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 (including transgender individuals who are transitioning, have transitioned, or are perceived to be transitioning to the gender with which they identify), 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. Equal Employment and Opportunity Employer Citizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates. Why Work for Us At Citizens, you'll find a customer-centric culture built around helping our customers and giving back to our local communities. When you join our team, you are part of a supportive and collaborative workforce, with access to training and tools to accelerate your potential and maximize your career growth 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. 01/03/2025