
Business Immigration Data and Content Analyst
- Excel
- PowerPoint
- G-Suite
- Tableau
- Data Visualization
- Pivot Tables
- Power BI
- Power Query
- AI
- Equity
- Pension
Job Description
Fragomen, an AmLaw 100 firm and the leading immigration services provider, is seeking an experienced Business Immigration Data and Content Analyst (Business Immigration Data and Content Analysis Specialist) who will act as a primary point of contact between the business and work closely with our external clients to understand reporting needs. With a keen understanding of corporate immigration, in this role, the Business Immigration Data and Content Analyst will work closely with legal teams to understand business needs and messaging to help develop reporting/analytics and visualizations that help to “tell a story”. Â
This position requires a strong understanding of corporate immigration, superb Excel, PowerPoint (and GSuite counterparts) skills, understanding of Tableau (preferred), and other reporting tools skills. If you have an analytical mindset and are a strong self-starter, this role is for you!  Knowledge in the immigration field is a must!Â
How will you make a difference as a Business Immigration Data and Content Analyst at Fragomen? Â
Help translate data and messaging into powerful presentations supported with smart visualizationsÂ
Act as a Business Analyst in terms of gathering requirements, creating reports and dashboards, and being able to take constructive feedback is a must.Â
Analyze and create custom internal & client reportsÂ
Build forecast models to anticipate team and client growth.Â
Analyze data points to identify bottlenecks and advise on innovative solutionsÂ
Provide reporting support to attorneys, paralegals and clients relating to the tracking, preparation, and filing of immigration petitions and applicationsÂ
Formulate technical specifications for new reports based on business requirements Â
Communicate regularly with team supervisors regarding reporting requirements and data integrity questionsÂ
Verify specialized and / or new reports for accuracyÂ
Identify modifications that need to be made to current reports to accommodate data from the firm’s case management applicationÂ
Monitor and coordinate the handling of new and pending reporting requests, to ensure satisfaction of requirements and timely deliveryÂ
Leverage your valuable skills and experience to make an impact at Fragomen:Â
BS or BA degree requiredÂ
Minimum of 1 year of experience providing business analysis or data analyticsÂ
Minimum of 1 year of experience in corporate immigrationÂ
At least one year of experience providing reporting support in a professional office environment using, Microsoft Excel.Â
1 Year of Experience with data visualization tools; (Pivot Tables, Pivot Charts; Tableau, PowerBI)Â
Experience using Power Query preferred.Â
Inquisitive mindset, question things, dig deeper while looking at data to determine quality and accuracy of the data.Â
Proactively identify risks and take action to mitigate and resolve issues, including data quality issues, unsustainable processes, and impact of business process changes to various stakeholders.Â
Strong data analysis, visualization and troubleshooting skillsÂ
Strong customer service skills to both internal and external clientsÂ
Dashboard development, report buildingÂ
Basic understanding of web-based data driven technologiesÂ
Expertise in Microsoft Excel; Strong formula knowledge to accomplish various goals and data manipulation.Â
Strong communication skills - both verbal and written is a MUST. Â
Ability to multi-task in a fast-paced environment with tight deadlinesÂ
Excellent attention to detailÂ
Proven experience in handling multiple deliverables efficientlyÂ
Strong organization skillsÂ
Critical thinking and problem-solving abilitiesÂ
Basic understanding of business immigration law preferredÂ
Fragomen is committed to promoting diversity, inclusion and equal opportunity for all employees and applicants, regardless of race, ethnicity, heritage, gender, age, religion, disability, sexual orientation, gender identity or intersex status.
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:Â
22 PTO days + Federal holidaysÂ
Medical, Dental, and Vision plans + FSA & HSA PlansÂ
401K plan, with company matchingÂ
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. We use limited AI‑assisted tools for administrative screening purposes only - never for decision‑making. All hiring decisions are made by people. Applicants may have rights to information and explanations regarding the use of such tools, or request human review, as required by applicable regional laws.
Business Immigration Data and Content Analyst · Fragomen