Business Immigration Data and Content Analyst

100 Fragomen, Del Rey, Bernsen & Loewy, LLP; San Francisco (CA); Hybrid; USD 78,000 - 94,000; Full time

Benefits offered by this job

22 PTO days + Federal holidays

Medical, Dental, and Vision plans + F1

401K plan, with company matching

Job summary

Fragomen, an AmLaw 100 firm and leading immigration services provider, seeks an experienced Business Immigration Data and Content Analyst to serve as a primary liaison between the business and clients, translating data into compelling reports and dashboards.

The role requires business analysis, requirements gathering, and delivering accurate reports and forecasts to attorneys, paralegals, and clients, with a focus on data integrity and timely delivery in a hybrid San Francisco environment.

Qualifications

• BS or BA degree required.
• Minimum 1 year of business analysis or data analytics experience.
• Experience in corporate immigration and reporting support is a plus.
• Strong Excel skills and data visualization experience with Tableau/Power BI.

Responsibilities

• Translate data and messaging into presentations with visualizations.
• Gather requirements and create reports and dashboards.
• Analyze data to identify bottlenecks and provide solutions.
• Build forecast models and provide reporting support to attorneys and clients.
• Ensure data integrity and timely delivery of requests.

Skills

Data analytics

Business analysis

Power BI

Tableau

Microsoft Excel

Pivot tables

Power Query

Dashboards

Reporting

Education

BS or BA degree

Tools

Tableau

Power BI

Power Query

Pivot Tables

Microsoft Excel

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.

Responsibilities

• 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

Qualifications

• 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

Benefits

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

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.

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.

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.

Fragomen helps corporations and individuals navigate the complexities of global mobility and provides end‑to‑end support across the immigration lifecycle, from strategic planning and policy design to compliance, government investigations, litigation and more.

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.

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.

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.

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.

Fragomen is the leading global immigration law firm with more than 6,000 professionals in nearly 70 offices across the Americas, EMEA and Asia Pacific, delivering services in over 170 countries. Ranked on both the Am Law 100 and Am Law Global 100, the firm is widely recognized for its leadership in immigration law and commitment to fostering a culture where diverse attorneys thrive and all individuals have equal opportunities to succeed.

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.

Fragomen helps corporations and individuals navigate the complexities of global mobility and provides end‑to‑end support across the immigration lifecycle, from strategic planning and policy design to compliance, government investigations, litigation and more.

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.

Fragomen Forward: At Fragomen, pursuing an equal, diverse, and inclusive workforce goes beyond a policy. It’s part of our DNA—and always has been.

Giving Back. We have a deep history of giving back to the communities where we live and work—and we continue that mission today.

Corporate Social Responsibility. We believe there is more to success in business than generating profit—we want to do well by doing good. We are committed to considering the impact that our business decisions have on our people, our planet, the communities in which we work and our clients.

Sustainability. Fragomen is focused on sustainability in our business operations and practices—and we know there is much work to be done, with countless opportunities available to minimize our impact on the environment.

Well-being. We are committed to implementing firmwide initiatives that support the health and wellness of our people, including programs to address work-life balance and benefits that cover a wide range of well‑being needs of all employees.

Our #FragomenWorks program provides the ability to be successful at home or in the office, via Hybrid & Remote work arrangements.

Our Feedback Works process includes three managerial check‑ins per year to help you progress in your career.

Unique learning programs like: Fragomen Academy, Leadership Academy, Practical Management Academy, and Regional Development Conferences.