Senior IT Risk and Compliance Analytics Analyst

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

• Bachelor's degree in Business Analytics, Information Systems, or a related field.
• 5+ years of experience in a fast-paced professional role.
• Previous audit, controls, process and/or IT audit is preferred, not required.
• Basic understanding of auditing standards and their application to user access reviews.

Knowledge, Skills and Abilities

• Strong ability to analyze business requirements and translate them into practical review strategies and quantitative analytics.
• Strong ability in combining technical knowledge with business understanding.
• Strong commitment to maintaining ethical standards and confidentiality.
• 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.
• Familiarity with troubleshooting activities and data tracing techniques.
• 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.
• Demonstrate the ability to generate new ideas; recognize the need for and develop new approaches to problem resolution.
• Demonstrate the ability to efficiently manage own time, activities and resources. Identify specific activities required to accomplish objectives and take action to achieve desired results; prioritize complex multiple activities and projects.
• Deals openly and honestly with people in all levels of the organization while building credibility and maintaining trust. Exhibits empathy and sensitivity for the needs of others. Is perceived by others as being helpful and supportive.
• Strong communication and written skills - Demonstrate the ability to present ideas and information in a clear, concise, organized and diplomatic manner; listen to others to respond effectively to ideas and questions.

Technical Skills:

• Familiarity with Alteryx or a similar ETL tool.
• Familiarity with SQL, database management, data transformation and data completeness concepts.
• Proficiency in data analysis using SQL queries, basic data types and joins.
• Familiarity with data modeling and data mapping techniques
• Familiarity with data transformation techniques and data visualization tools.
• Basic knowledge of database vocabulary and its relevance to user access review processes.
• Intermediate to advanced level skills using Microsoft office products including Word, PowerPoint and Excel.
• Intermediate to advanced skills in Excel using functions such as VLOOKUP, INDEX-MATCH and SUMIFS for data manipulation and analysis.

WHAT YOULL DO:
Job Responsibilities:

• Collaborate with cross-functional teams to gather and understand business requirements for implementing applications within UER tools, including understanding access provisioning processes and technical architecture for security across various applications.
• Utilize data analysis techniques, including SQL queries, to assist in reviewing access data for accuracy and completeness.
• Lead troubleshooting activities and data tracing to ensure data transformation integrity when questions arise.
• Proactively address issues that may result in the UER data being inaccurate.
• Execute 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.
• Support the development, testing and implementation of necessary UER tool updates to ensure completeness and accuracy of user access.
• Apply analytical and critical thinking skills to identify potential risks, weaknesses and compliance issues and risk assessment processes in user access controls. Track and remediate access compliance issues in a timely manner.
• Apply technical knowledge to map and execute ETL processes in the user access review workflow.
• Contribute to maintaining compliance with relevant auditing standards throughout the user access review process.
• Communicate with various internal stakeholders and external auditors to explain how the UER process works both technically and functionally.
• Maintain standard operating procedures, documentation of vocabulary and best practices to optimize 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-LG1