Data Analyst II

Job Summary

The Data Analyst II routinely interacts with managers and supervisors from all lines of business to analyze requirements and create solutions for process automation, reports, queries, and productivity applications.

 This position serves as a liaison between the business units and IT development staff and is responsible for developing detailed project specifications, communicating effectively and consistently with all parties, and ensuring final deliverables are accurate and meet department standards.

 

Key Responsibilities / Essential Functions

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 


* Conceptualize and document requirements and solutions for reports, process automation, APIs, and productivity applications.


* Create test cases and provide quality review and quality control across all project types.


* Ensure that developers write, translate, and code projects according to specifications.


* Verify that reports (Power BI, ADF/SSIS extracts) are accurate, meet design standardizations, and contain appropriate processing options (parameters).


* Oversee the creation of bug-free automation routines in automation tools like UiPath or other middleware.


* Ensure timely completion of all deliverables.

 


* Consistently communicate project status to all involved stakeholders and communicates effectively with programmer staff to achieve high quality results on projects.


* Complete accurate and consistent documentation across all development platforms and projects.


* Maintain confidentiality and security of sensitive information.


* Adhere to all corporate policies and procedures, Federal and State regulations, and laws.


* Complete all mandatory annual compliance training.


* Follow regulatory requirements including those pertaining to the Bank Secrecy Act (BSA), Anti-Money Laundering (AML), Customer Identification Program (CIP), and OFAC to assist in the identifications, detection and determent of money laundering and other unlawful activities, as well as regulations pertaining to lending and consumer compliance to include fair lending laws.


* Perform other duties and special projects as assigned.

 

 

 

Job Requirements

Education:


* Bachelor’s degree in business, computer science, or an equivalent computer information systems degree, with a focus on system analysis and/or project management.

 

Required:


* 3+ years of work experience in analysis and problem resolution.


* Ability to run basic SQL queries for data research, production support, and quality checking reports.


* Familiarity with gathering requirements, quality assurance/quality control, system testing methodologies, and business documentation concepts.


* Ability to communicate well with technical resources and follow group processes related to project lifecycle.


* Highly self-motivated, detail-orien...