Data Analyst - Audit Data Analytics

Candidate will provide support to audit teams through a number of advanced automation tools to develop new testing methodologies that provide coverage for high-risk areas. Support may be in the form of issue validation, point-in-time audits, dashboard development, or audit planning. Candidate will be given the opportunity to learn and make use of sophisticated tools (SQL, Alteryx, Informatica, SAS, Tableau, SSRS, DataRobot etc) and technologies (Big data like Hadoop, Python/R Programming, AI/Data Science,) to provide customized automated solutions across multiple business segments. Day-to-day activities will include data extraction from multiple sources, performing advanced data analytics, and building dashboards.  Opportunity exists for candidate to expand into predictive modeling, NLP solutions, and advanced analytics to provide deeper insight into the audit objectives.

Responsibilities:

• Works across development teams to contribute to the story refinement and delivery of data requirements through the delivery life cycle

• Leverages architecture components in solution development, codes solutions to integrate, clean, transform, and control data in operational and analytical data systems per acceptance criteria

• Builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management and defines and builds data pipelines and complex data sets to enable data-informed decision making, identifying and raising risks at all stages of the data engineering process

• Develops and executes test plans to produce quantitative results, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues and errors, and triages underlying causes

• Drives complex information technology projects to ensure on-time delivery and adheres to team delivery and release processes

• Identifies, defines, and documents data engineering requirements, communicating required information for deployment, maintenance, support, and business functionality

• Works with technology partners and a diverse set of stakeholders to identify and close gaps in data management standards adherence, negotiates paths forward, and helps identify and communicate solutions to complex data problems leveraging knowledge of information systems, techniques, and processes

• Independently develop automated testing solutions using a variety of technologies (SQL, Alteryx, SAS, Python, Tableau, etc.)

• Responsible for multiple projects simultaneously.

• Utilizes sound, seasoned analytical skills and possesses product, business, and technical expertise to execute assigned responsibilities.

• Coordinates, schedules, scopes, and leads data automation activities on audits (incl. large, cross-functional reviews).

• Leads data analysis of control deficiencies to drive actionable business impact, influences management on sufficiency of correctives actions, recommends audit rating.

• Implements risk-based audit strategy. Exercise judgment and critical thinking to influence business partners.

• Identifies control trends through data analysis in assigned business areas as well as assessing impact to the business and to the Bank overall by applying deep and broad business acumen.

• Coaches/trains team in execution of data automation activities to support the audit plan.

• Follows the lifecycle of our internal system for automation activities and ensure its data accuracy and completeness.

• Ensure timely delivery of automation activities as per the point-in-time audit and issue validation timelines.

REQUIRED SKILLS AND EXPERIENCE

• Bachelor’s degree OR 3 years minimum experience in data extraction with ability to write SQL queries. 

• 3+ years in Data analytics

• Skilled in the use of data wrangling and visualization tools such as Alteryx and Tableau. Understanding of Data Integration/ETL tools.  Familiarity with DataRobot, Instabase, and UIPath are a plus.

• Proven experience coordinating multiple projects/assignments simultaneously under minimal supervision and completing assigned tasks accurately and on a timely basis.

• Must demonstrate strong attention to detail with excellent organization skills.

• Excellent Communication skills (verbal and written)

DESIRED SKILLS AND EXPERIENCE

• Advanced SQL writing abilities

• 3  years of Data Analytics, Alteryx Core Certification, SQL Training, Database knowledge.

• Knowledge of how to connect to data sources and extract and analyze data

• Experience with Python is a plus

• AI/Data Science Experience is a plus

• Audit experience is a plus

Skills:

• Analytical Thinking
• Application Development
• Data Management
• DevOps Practices
• Solution Design
• Agile Practices
• Collaboration
• Decision Making
• Risk Management
• Test Engineering
• Architecture
• Business Acumen
• Data Quality Management
• Financial Management