Data Analyst

Required Skills 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 Created dashboard reports or analytics