Advanced, expert Excel skills is mandatory (5+ years)
Moderate-to-advanced SQL skills is also mandatory (5+ years)
Data mining experience (7+ years)
Analytics experience - dissect, distill, and simplify data (7+ years)
Day to Day:
The role provides critical end to end production support of metric reporting routines. The reports/dashboards are shared with senior executives within and outside of the organization to drive proper risk culture and business strategy. Given the level of the audience, report dashboards and executive summaries must be pristine and error free.
Data analytics responsibilities may include, and are not limited to, trending analysis, and success analytics to identify areas of discrepancy and possible at-risk controls. The work includes data mining, data aggregation, business metrics, SPI inventory output analysis, risk program metrics analysis, and performance/milestone analytics.
Success measures for this role include:
Consistent, timely delivery of reporting requirements using existing macros and code
Proactive identification of code or macro breaks
Successful application of macro/code fixes and creation
Demonstrated ability capture, manipulate and clean data from multiple sources and systems of record
Applied critical eye to catch errors or discrepancies
Reliable application of advanced Excel and SQL skills to produce reporting in an efficient, timesaving manner
Ability to remain nimble and positive when priorities change and Adhoc needs arise
Shows a sense of urgency and attention to detail as standard work practice
Strong collaboration
Significant attention to detail
Effective prioritization of workbench deliverables
Timely follow-up on reporting requests and questions
Experience working in a highly regulated industry or financial institution
Has previously interacted with senior level managers