Senior Data Analyst - Controls Apply
Generate reports daily on data quality breaks and data validation shifts outside of BAU thresholds. Work closely with product stewards to perform required updates after upstream changes. Drives and participates in design, development and implementation of future Corporate Treasury reconciliations. Work under minimal supervision on Corporate Treasury projects that require creative solutions. Job responsibilities • Works with product Data Stewards to complete manual reconciliations, determine common reconciling items, variance types and gather business requirements for an automated solution. • Develop processes & queries to confirm application processes are working as per the requirements. • Validates data and signs off on reports within test environments to confirm Business Intelligence tool accuracy, functionality and EDM Standards are met. • Monitors technical and data issues within Business Intelligence tools and manages issue resolution, insuring that all Data Reconciliation and Data Validation controls are available. • Communicates status to stakeholders and escalates issues according to defined process, as needed. • Create required processes, controls, documentation and evidence to ensure adherence to EDM Standards and RDA requirements. Qualifications • Bachelor's degree in Finance, Accounting or Business Administration - or related work experience • 3-5 years experience analyzing and reporting financial data • General Ledger reconciliation experience • Advanced Microsoft Excel skills • Strong analytical and problem solving skills • Ability to coordinate, track and organize all written and verbal communications and prioritize accordingly • Understands concepts and application of Business Intelligence tools, demonstrates understanding of relationship between data and business rules and functions. • A demonstrated history of strong verbal and written communications skills • Ability to build relationships, negotiate and influence across diverse groups of stakeholders • Proven ability to balance strategic and tactical solutions, and to drive technology initiatives • Process design and data/financial analysis skills • Ability to multi-task Desired Skills • Advanced Microsoft Excel • SQL & Microsoft Visual Basic for Application experience • Ideal candidate should have a general comprehension of the bank products • Must have strong analytical skills and have experience working across multiple applications • Ability to work independently and take lead on addressing issues