• Review employment-based immigration case files for completeness, consistency, and compliance with internal documentation standards • Conduct structured file transition audits to ensure proper organization and data accuracy • Identify missing documentation, discrepancies, and data inconsistencies; escalate issues as appropriate • Maintain accurate case data within the firm’s immigration case management system • Build and maintain recurring operational and client-facing reports • Create Salesforce reports and dashboards to support business reviews and internal analytics • Utilize advanced Excel functions (pivot tables, VLOOKUP/XLOOKUP) to analyze case data and generate summaries • Support preparation of quarterly and annual business reviews through data compilation and analysis • Respond to internal stakeholder reporting requests and ad hoc data analysis needs • Support document migration and data integrity initiatives, including internal audits and quality control checks • Collaborate with IT and legal teams to implement reporting enhancements and workflow improvements • Assist in developing reporting templates, dashboards, and internal tracking tools • Maintain strict confidentiality when handling sensitive client information