Data Analyst

Fragomen•New York, NY

25d•$78,000 - $94,000•Hybrid

About The Position

The Data Analyst manages client-facing reports, maintaining data quality and timely delivery in coordination with local U.S. and global case teams. The role supports attorneys, paralegals, and clients with reporting related to immigration petitions and applications, as well as certain financial data. It gathers business requirements, develops technical specifications for reports, verifies report accuracy, and coordinates new and pending requests. The analyst monitors case progress against processes and client service-level agreements, maintains reporting process guides, analyzes layered reports, and follows up with teams to ensure completion. The role also builds forecast models, identifies bottlenecks and potential solutions, and manages the internal Data Quality Scorecard for U.S. and global case teams, including requirements gathering, data mapping, and compliance with client-specific data standards.

Requirements

Bachelor of Science or Bachelor of Arts degree.
One to two years of experience providing business analysis or data analytics.
At least one year of experience providing reporting support in a professional office environment using SAP Business Objects/Web Intelligence (WEBI).
Basic understanding of web-based data-driven technologies.
Expertise in Microsoft Excel.
Strong verbal and written communication skills.
Strong data analysis and troubleshooting skills.
Ability to multitask in a fast-paced environment with tight deadlines.
Strong customer service skills with internal and external clients.
Excellent attention to detail.
Proven ability to handle multiple deliverables efficiently.
Strong organizational skills.
Critical-thinking and problem-solving abilities.

Nice To Haves

Familiarity with Tableau or other data visualization tools.
Basic understanding of business immigration law.

Responsibilities

Manage the catalog of client-facing reports to ensure data quality and timely delivery, working with local U.S. and global case teams as needed.
Participate in monthly and ad hoc external client technology meetings to provide reporting and data-quality updates.
Monitor and coordinate new and pending reporting requests to ensure requirements are met and reports are delivered on time.
Identify modifications needed to current reports to accommodate data from the firm’s case management application.
Provide reporting support to attorneys, paralegals, and clients relating to the tracking, preparation, and filing of immigration petitions and applications, as well as certain financial data.
Gather and analyze business requirements from legal teams and clients.
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.
Serve as a reporting case analyst, ensuring cases progress in a timely manner in accordance with processes and client SLAs.
Create and update process guides to improve report monitoring.
Analyze layered reports, including start date, EAD, and document reports; communicate direction to the team and follow up to ensure completion.
Build forecast models to anticipate team and client growth.
Analyze data points to identify bottlenecks and advise on innovative solutions.
Manage the internal Data Quality Scorecard for U.S. and global case teams, including requirements gathering, data mapping, and adherence to client-specific data standards.