Data Engineer Ii - Automation & Analytics

Job Description:

RESPONSIBILITIES

• 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 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. Exercises 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 automation activities to support the audit plan.
• Follow 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 in Computer Science, Information Systems (IS), Accounting, Finance or similar
• 3 years minimum experience with Data Analytics, Audit, Risk or other relevant experience
• Ability to analyze and interpret data through SQL queries.
• Skilled in the use of data wrangling and visualization tools such as Toad, Alteryx and Tableau.
• 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

• Advance SQL writing abilities
• Experience with Python
• Understanding of Data Integration/ETL tools. 
• Familiarity with DataRobot, Instabase, and UIPath are a plus.
• AML Audit experience

Shift:

Hours Per Week: