Manager of IT Risk and Compliance Analytics

Overview

Hybrid
Depends on Experience
Full Time

Skills

Risk Analysis
SQL
ETL
Excel

Job Details

Manager of IT Risk and Compliance Analytics
Primary Location: Bannockburn, Illinois V-Soft Consulting is currently hiring for a Manager of IT Risk and Compliance Analytics for our premier client in Bannockburn, Illinois.
Education and Experience

  • Bachelor's degree in Business Analytics, Information Systems, or a related field.
  • In-depth understanding of auditing standards and their application to user access reviews.
  • 7+ years of relevant work experience in a fast-paced professional role.
  • Previous audit, controls, process and/or IT audit is preferred, not required.
  • Proficiency in SQL, database management, data transformation, and data completeness concepts.
  • Advanced knowledge of data analysis using SQL queries, data types, and joins.
  • Expertise in data analysis using Excel and various ETL tools.
  • Strong understanding of data transformation techniques and data visualization tools.
  • Experience in troubleshooting activities and data tracing to ensure data transformation integrity.
  • Familiarity with Alteryx or a similar ETL tool.
  • Advanced level skills using Microsoft office products including Word, PowerPoint, and Excel, including functions such as VLOOKUP, INDEX-MATCH, and SUMIFS for data manipulation and analysis.

Knowledge, Skills and Abilities

  • Strong ability to analyze business requirements and translate them into practical review strategies and quantitative analytics.
  • Detail-oriented mindset with an ability to spot patterns, anomalies, and potential risks.
  • Solid problem-solving and critical-thinking skills and demonstrates the ability to be a self-starter who can utilize their strong problem-solving skills to generate creative solutions to complex issues.
  • Strong ability in bridging the gap between technical knowledge with practical business applications.
  • Strong commitment to maintaining ethical standards and confidentiality.
  • Demonstrate the ability to deal with changing priorities and multi-task several projects with the ability to succeed well under pressure, grasp new ideas quickly. Possess an all in attitude and embrace the ability to be part of a High-Performance team, focusing on adapting and overcoming obstacles.
  • Ability to lead and manage a team, providing guidance, mentorship, and feedback.
  • Demonstrate the ability to generate new ideas; recognize the need for and develop new approaches to problem resolution.
  • Effective project management and organizational skills to handle multiple tasks and priorities. Identify specific activities required to accomplish objectives and take action to achieve desired results; prioritize complex multiple activities and projects.

WHAT YOULL DO:
Job Responsibilities:

  • Develop, test, implement and manage necessary UER tool updates to ensure completeness and accuracy of user access.
  • Manage and oversee the execution the end-to-end centralized user entitlement reviews for organization, which includes the UER data preparation, ETL (Extract, Transform, Load) in UER data tools (Alteryx), monitoring of reviews while in process, perform post-access removal validation activities, and risk assessment of access removals for many applications across the organization.
  • Maintain standard operating procedures and documentation required to execute best practices to optimize the user access review process.
  • Manage and develop team of Analytics team members to attain skills and competencies necessary for the effective execution of quarterly UER processes.
  • Lead troubleshooting activities and data tracing to ensure data transformation integrity when questions arise.
  • Conduct data analysis using SQL queries, data types, and joins to review access data for accuracy and completeness.
  • Apply technical knowledge to map and execute ETL processes in the user access review workflow.
  • Utilize data transformation techniques and data visualization tools to present findings and recommendations.
  • Ensure compliance with relevant auditing standards throughout the user access review process.

V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks. As a valued V-Soft Consultant, youre eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth. V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. For more information or to view all our open jobs, please visit or call .
#LI-BP2