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 & AutomationPrepare 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).
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.
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.00You 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.
Top Skills
What We Do
Fragomen is a leading firm dedicated exclusively to immigration services worldwide. Founded in 1951, Fragomen represents a broad range of companies, organizations and individuals to help facilitate the transfer of employees worldwide. We provide immigration support in more than 170 countries. An Am Law 100 and Global 100 firm, Fragomen’s professionals are respected thought leaders in the immigration field, as recognized by Chambers, Best Lawyers and Who’s Who. The firm employs more than 4,400 immigration professionals and support staff located in over 50 offices across the Americas, Asia Pacific and EMEA. Our services go beyond processing visa and work permit applications. We provide strategic consultative services and support to meet the full spectrum of business immigration needs. This includes government strategies and compliance, planning for mergers and acquisitions, and consular and document support. From our Immigration Technology Innovation Lab, we focus on using automation and artificial intelligence to pioneer sophisticated technology solutions to revolutionize the immigration experience for our clients. All services are designed to improve your speed-to-ground and help you mobilize your employee population so you can remain a cutting-edge player in your industry and competitive wherever you operate. We are committed to fostering a dynamic, diverse workplace. Year after year, Fragomen is recognized for our diversity by The American Lawyer, Law360 and the National Law Journal. Find out more at www.fragomen.com.
