VBA Data Analyst - Apex Systems

Job#: 2027307

Job Description:

Position 1:
SQL Reporting Analyst

Large Banking Client

Duration: 12-18 months

Location: Kennesaw, GA/Atlanta, GA or Plano, TX - (3 days onsite, 2 Remote)

Top Requirements:

• 5+ years of Analyst experience - Data Analyst, Reporting Analyst, SQL Analyst
• SQL - Building out Views, Editing and writing queries
• Large Enterprise Experience
• Reporting Experience

Plusses:

• Excel
• Banking Industry Experience

Position 2:
VBA/Excel Analyst

Large Banking Client

Duration: 12-18 months

Location: 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)
• Macros

Plusses:

• SQL
• Banking Industry Experience

Group: Business Controls Central Reporting - SPI Reporting Team

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

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.