What are the responsibilities and job description for the Data Analyst position at Prequel Solutions?
We are seeking a highly organized and detail-oriented Application Access Data Analyst to join our team on a long-term contract basis, with the potential to convert to a direct hire. This role is critical to maintaining strong internal controls around employee access to applications, ensuring compliance, and supporting audit readiness.
The ideal candidate will have experience in access control processes, proficiency in Excel and SharePoint, and exceptional follow-through and communication skills.
Key Responsibilities:
Quarterly Access Report Management
Monitor and manage the schedule for quarterly application access reports.
Request, remind, and follow up with report owners to ensure timely submission.
Generate a subset of reports manually via the internal employees.
Data Entry & Review Support
Transcribe access data into the Employee Access Review by Manager spreadsheet.
Highlight terminated or transferred employees lists.
Workflow Oversight
Initiate and track application owner and manager access reviews using a SharePoint-based workflow.
Tracking & Documentation
Maintain and update a centralized tracking spreadsheet for all applications requiring quarterly reviews.
Document any changes to applications, review contacts, or reporting requirements.
Required Qualifications:
5 years of experience in roles involving:
Running and interpreting reports from access control systems
Merging and managing data using Microsoft Excel (e.g., VLOOKUP, filters, pivot tables)
Using SharePoint for workflows and documentation
Strong attention to detail and accuracy
Excellent organizational and time management skills
Clear and professional communication skills, both written and verbal
Preferred Experience:
Experience working in audit, compliance, or IT access governance environments
Familiarity with identity management tools and systems
