Business Immigration Data and Content Analyst

Fragomen; San Francisco (CA); Hybrid; USD 78,000 - 94,000; Full time

Benefits offered by this job

PTO & Holidays

Medical/Dental/Vision

401K with company match

Job summary

Fragomen, an AmLaw 100 firm and the leading immigration services provider, is seeking an experienced Business Immigration Data and Content Analyst to act as a primary liaison between the business and clients, translating data into compelling stories through reports and visuals. This role requires strong Excel, PowerPoint, and GSuite skills, familiarity with Tableau (preferred), and other reporting tools.

You will collaborate with legal teams to develop analytics and dashboards to tell a story

Qualifications

• BS or BA degree required.
• Minimum of 1 year of business analysis or data analytics experience.
• Minimum of 1 year of corporate immigration experience.
• At least 1 year of reporting support in a professional office using Microsoft Excel.
• 1 year of experience with data visualization tools; Pivot Tables/Charts, Tableau, PowerBI.

Responsibilities

• Translate data and messaging into powerful presentations with visualizations.
• Gather requirements, create reports and dashboards, and incorporate feedback.
• Analyze and create internal and client reports.
• Build forecast models to anticipate team and client growth.
• Identify bottlenecks and advise on innovative solutions.
• Provide reporting support to attorneys, paralegals and clients relating to tracking, preparation, and filing of immigration petitions and applications.
• Formulate technical specifications for new reports based on business requirements.
• Communicate reporting requirements and data integrity questions with team supervisors.
• Verify specialized and/or new reports for accuracy.
• Identify modifications to current reports to accommodate data from the firm’s case management application.
• Monitor and coordinate handling of new and pending reporting requests, ensuring timely delivery.

Skills

Excel expertise

Data analysis

Data visualization

Communication skills

Organization skills

Problem-solving

Attention to detail

Education

Bachelor's degree

Tools

Tableau

PowerBI

Power Query

Job description

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.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. 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.