Immigration Operations & Data Analyst

Job Description

About the Role: We are seeking an internal candidate with hands-on immigration knowledge who also brings strong technical and analytical skills, particularly in Excel-based automation and reporting. This role sits at the intersection of immigration operations, data management, and process optimization. The individual will partner closely with immigration legal teams to improve accuracy, efficiency, and insight across immigration-related workflows.

This is an ideal opportunity for someone who understands immigration case data and reporting requirements and can translate that knowledge into reliable analytics, visualizations, and automated processes.

How will you make a difference as an Immigration Operations & Data Analyst at Fragomen?

### Data Reporting & Automation

• Prepare Excel-based reporting to support immigration tracking, analysis, and operational decision-making using standardized data extracts and defined business rules.

• Build and maintain Power Query solutions to clean, transform, and combine data from multiple sources.
• Develop automation using VBA and/or Office Scripts to reduce manual effort and improve reliability.
• Create and maintain Power BI dashboards to provide visibility into immigration metrics, trends, and operational performance.
• Run and enhance reporting from Business Objects (BO/Boxi).

### Process Improvement & Collaboration

• Identify opportunities to streamline and standardize immigration data workflows.
• Translate business and immigration requirements into technical solutions that are maintainable and scalable.
• Partner with legal teams to ensure solutions align with business needs.
• Provide training and guidance to stakeholders on tools, dashboards, and reporting outputs.

### Immigration Operations & Subject Matter Support

• Partner with immigration stakeholders to understand data needs, recurring pain points, and reporting gaps.
• Support quality, consistency, and integrity of immigration-related data used for internal and external reporting and decision-making.
• Assist with documentation of data-driven immigration processes to ensure consistent usage and scalability.

Leverage your valuable skills and experience to make an impact at Fragomen:

• Immigration experience in a corporate (e.g., HR mobility) or professional services environment.
• Advanced proficiency in Microsoft Excel, including: Complex formulas, pivot tables, and large dataset handling
• Hands-on experience with Power Query.
• Strong analytical problem-solving skills and a data quality mindset.
• Experience with Business Objects/ Boxi reporting.
• Experience building Power BI reports and dashboards
• Demonstrated ability to automate workflows using VBA and/or Office Scripts
• Experience documenting processes and data definitions
• Background in business analysis, operations analytics, or reporting enablement.

Benefits:

At Fragomen, we know that great people make a great organization. We value our people and offer employees a broad range of benefits which includes:

• 27 PTO days + Federal holidays
• Medical, Dental, and Vision plans + FSA & HSA Plans
• 401K plan, with company matching

Learn More About Fragomen:

Please take time to read *About Us*, explore the *Meaningful and Impactful Work* we do for our clients, and review the standard *Benefits* we offer. You can find all the material to the right of this page.

Compensation:

The salary range for this role reflects a variety of factors considered in compensation decisions, including but not limited to an individual’s skills, experience, qualifications, work location, work arrangement, licensure and certifications, and applicable laws. Placement within the range will vary based on these factors, and compensation decisions are made to ensure internal equity and alignment with market data.

A reasonable and good-faith estimate of the current salary range for individuals able to work a hybrid schedule in the office locally is:

$78,000.00 - $94,000.00

You may also be eligible to take advantage of our benefits offering, 401K, and paid time off plans.

*All offers and/or employment contracts are contingent upon the successful completion of the Firm’s pre-employment screening process. This process may include verifying the candidate’s identity, confirming legal authorization to work in the offered position's location, and conducting a comprehensive background check, where permitted by local regulations.*