Immigration Business Analyst

Role Overview

• 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

Requirements

• Bachelor’s degree required
• 2+ years of experience in a fast-paced business immigration firm
• Prior experience in immigration data/reporting, case management, or paralegal-level support
• Experience working with immigration case management software (e.g., INSZoom, LawLogix, Docketwise, or similar)
• Experience building Salesforce reports and dashboards
• Advanced Excel proficiency, including:
• Pivot tables
• VLOOKUP/XLOOKUP
• Strong analytical and problem-solving skills
• Demonstrated attention to detail and ability to identify data discrepancies
• Strong written communication skills for preparing summaries and reports.

Benefits

• paid time off and paid holidays
• medical, dental, vision, and life insurance coverage
• health savings and flexible spending accounts to help offset healthcare and dependent care expenses
• multiple retirement plan options (401k & Roth 401k)
• access to an employee assistance program