PlanoRecruiter Since 2001
the smart solution for Plano jobs

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, Plano , Excel/VBA Analyst, Professions , Plano, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Plano RSS job feeds