Address
Form of work
SalarySUMMARY: The Audit Data Analyst will be responsible for all aspects of data analysis, from meeting with stakeholders to define and gather requirements through the delivery of insightful and actionable analytics. The analyst is tasked with building/reporting of KPIs, dashboards, scorecards, trends, and ad hoc analytics. Extraction, cleansing, and transformation of data are all necessary functions to aid the analyst in the maintenance of established reporting as well as in the creation of ad hoc analysis and special projects as requested within the Internal Audit Department.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties and special projects may be assigned.
- Perform financial analysis and portfolio reporting using advanced analytic tools, such as SQL, Power BI, Python, Tableau and Advanced Excel.
- Use analytic tools to create transformations/calculations from raw data files to produce custom outputs
- Prepare project deliverables including written reports, data files, and presentations.
- Analyze results and create or maintain documentation in accordance with established procedures.
- Analyze reporting requirements, extract, and interpret data, and ultimately provide recommendations to management.
- Document and track issues and test results, then constructively and concisely reports findings or discrepancies.
- Develop streamlined and automated approaches for gathering and delivering data, thereby reducing manual business processes where possible.
- Must possess the ability to clearly document reporting logic and processes for auditability.
- Adheres to and complies with applicable, federal and state laws, regulations and guidance, including those related to anti-money laundering (i.e. Bank Secrecy Act, US PATRIOT Act, etc.).
- Adheres to Bank policies and procedures and completes required training.
- Identifies and reports suspicious activity.
EDUCATION
Bachelor's Degree Business Administration or related analytical field (ie Management Information Systems, Engineering, Math/Statistics, or Computer Science) preferred
EXPERIENCE
- At least 5 years of requisite data analysis and analytics experience; banking industry preferred
- Excellent verbal and writing skills with a strong business acumen required
- Basic understanding of programming languages and concepts required
- Demonstrated technical expertise in data analysis, design of KPI dashboards, scorecards, and ad hoc analysis required
- Large ERP Software Experience; Lawson and Workday preferred
- 1-2 years of experience with BI Tools; Tableau, Power BI and/or Python, and SQL preferred
KNOWLEDGE, SKILLS AND ABILITIES
Analytical
- - Synthesizes complex or diverse information; collects and researches data; uses intuition and experience to complement data, designs work flows and procedures.
- Communication - Ability to communicate by clearly conveying information to individuals or groups. Dependability
- - Follows instructions, responds to leadership direction; takes responsibility for own actions; keeps commitments; commits to long hours of work when necessary to reach goals; completes tasks on time or notifies appropriate person with an alternative plan. Interpersonal Skills
- - Focuses on solving conflict, not blaming; maintains confidentiality; listens to others without interrupting; keeps emotions under control; remains open to others' ideas and tries new things. Problem Solving
- - Identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem solving situations; uses reason even when dealing with emotional topics. Professionalism
- - Approaches others in a tactful manner; reacts well under pressure; treats others with respect and consideration regardless of their status or position; accepts responsibility for own actions; follows through on commitments. Quality - Demonstrates accuracy and thoroughness; looks for ways to improve and promote quality; Applies feedback to improve performance; monitors own work to ensure quality. Teamwork
- - Balances team and individual responsibilities; exhibits objectivity and openness to others' views; gives and welcomes feedback; contributes to building a positive team spirit; puts success of team above own interests; able to build morale and group commitments to goals and objectives; supports everyone's efforts to succeed.
- Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers and internal clients.
