Business Data Analysis Specialist I

Job Description

About the role: Fragomen, an AmLaw 100 firm and the leading immigration services provider, is seeking an experienced Data Analyst (Business Data 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. In this role, the Data Analyst will work closely with legal teams to develop detailed business requirements and will then design reporting specifications to support these requirements.

If you have superb Excel skills, have an analytical mindset and are a strong self-starter, this role is for you! Legal knowledge in the immigration field is a plus!

Applicants must be legally authorized to work in the United States without the need for current or future employer sponsorship. We are unable to provide visa sponsorship for this position.

How will you make a difference as a Senior Business Data Analysis Specialist at Fragomen?

• Conduct high-level reporting analysis, including new change reports, monitoring of case progression, client data audits and file transfers. This includes reviewing changes to substantive data points and communicating updates/action to team. This also includes reviewing weekly and monthly data reports to ensure updates/changes are captured and flagging misses to team leads.
• Create and maintain detailed process guides and SOPs, including data entry protocols. This includes purging outdated content and organizing SharePoint site to enhance accessibility. Support similar exercise for other pods as needed.
• Manage and expand team email templates and CMQ communications to support scalable client communications. This includes drafting templates for expansion of CMQ; serving as additional CMQ resource for coverage; serving as additional Concierge Support resource for coverage; and training to ultimately manage CMQ reporting.
• Train and mentor caseworkers on NIV data entry protocols. This includes data-related training for new hires, and ad hoc training as necessary for individual resources or broader team.
• Liaise closely with NIV leads to ensure Data Team continuously delivers necessary data reporting tools.
• Contribute to case intake and assignments, and manage ad hoc projects as required.

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

• Bachelor’s degree in information systems, Data Analytics, Data Science, Computer Science, Business Intelligence, or a related technical field
• Experience with Power Query, scripting in Excel, and coding experience like Python or SQL
• Strong Excel skills, including advanced formulas, logic, and pivot tables
• Familiarity with SQL for querying and data extraction across relational databases
• Demonstrated ability to work independently and prioritize in a fast-paced, high-accountability environment
• Attention to detail, strong problem-solving skills, and willingness to dive into unfamiliar systems or datasets
• Familiarity with building KPI dashboards and performance monitoring reporting
• Understanding of ETL/ELT workflows, data transformations, and pipeline logic
• Experience with business intelligence platforms such as Tableau or PowerBI
• Exposure to legal operations, case management systems, or immigration data environments
• Foundational knowledge of API integrations and data feeds

• 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 and troubleshooting skills
• Strong customer service skills to both internal and external clients
• Strong communication skills - both verbal and written is a MUST.

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:

$57,000.00 - $66,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.