VBA Data Analyst
Kennesaw, Georgia
Employer: Apex Systems
Industry:
Salary: Competitive
Job type: Part-Time
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:
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:
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 .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.
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
- Excel
- Banking Industry Experience
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
- SQL
- Banking Industry Experience
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 .
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.
Created: 2024-05-03
Reference: 2027307
Country: United States
State: Georgia
City: Kennesaw
Similar jobs:
-
Staff Technical Data Analyst, Lifecycle Marketing Operations
Intuit in Atlanta, Georgia -
Data Management Analyst
Koch Industries in Atlanta, Georgia -
Strategic Business Data Analyst - Office of Research
Kennesaw State University in Kennesaw, Georgia💸 $84180 - $95000. per year -
Pricing Data Analyst
WestRock in Atlanta Headquarters, Georgia -
Adobe Analytics Data Analyst/Architect
Cognizant Technology Solutions in Atlanta, Georgia -
Sr. Data Warehouse Analyst (MDX)
Insight Global in Kennesaw, Georgia -
Data Protection and Sovereignty Analyst, Global Security
TikTok in Atlanta, Georgia -
Senior Data Analyst I
LexisNexis Risk Solutions Group in Alpharetta, Georgia -
Co-op, Crew Resources - Data Analyst (Fall, 2024)
Delta Air Lines in Atlanta, Georgia -
Data Analyst
Lukos LLC in Atlanta, Georgia -
Master Data Analyst
WestRock in Atlanta Headquarters, Georgia -
Technical Data Analyst
Insight Global in Atlanta, Georgia -
Senior Data Analyst I
LexisNexis Risk Solutions Group in Alpharetta, Georgia -
Data Analyst Intern (Business Intelligence)
LexisNexis Risk Solutions in Alpharetta, Georgia💸 $20 per hour -
Data Analyst (Kennesaw,Plano)
Experis in Kennesaw, Georgia -
Data Analyst Sr.
Saxon Global in [ Alpharetta , Ga], Georgia -
Project Delivery Senior Analyst - Senior Data Governance Engineer
Deloitte in Atlanta, Georgia -
Procurement Master Data Analyst
Koch Industries in Atlanta, Georgia -
Data Privacy and Compliance Analyst
Insight Global in Atlanta, Georgia -
Clinical Data Analyst - Piedmont Augusta
Piedmont Healthcare in Augusta, Georgia