Excel/VBA Analyst
Company: Apex Systems
Location: Plano
Posted on: May 8, 2024
Job Description:
VBA/Excel AnalystLarge Banking ClientDuration: 12-18
monthsLocation: Kennesaw, GA/Atlanta, GA or Plano, TX - (3 days
onsite, 2 Remote)Top Requirements:
- 5+ years of Analyst experience - Data Analyst, Excel/VBA
Analyst, etc.
- Large Enterprise Experience
- Reporting Experience
- VBA / VB (Visual Basics)
- MacrosPlusses:
- SQL
- Banking Industry ExperienceGroup: Business Controls Central
Reporting - SPI Reporting TeamBrief overview: This person will take
a bunch of data from all over the place, put it in excel and run a
macro against it. Need someone who has VBA skills to go in around
the scenes and adjust things, as needed. Each macro has tweaks that
need to happen. For example, Moved where folder is and update it.
Have others where they write data out to PowerPoint slides. Need to
make sure macros are cleaning out the records.Responsibilities: 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 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)
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
Keywords: Apex Systems, Allen , Excel/VBA Analyst, Professions , Plano, Texas
Didn't find what you're looking for? Search again!
Loading more jobs...