Business Data Analysis Specialist

Fragomen•New York, NY

1d•Hybrid

About The Position

Our NY office 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 client 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.

Requirements

Bachelor’s degree required (BS or BA preferred)
Minimum 1 year of experience in business analysis, data analytics, or reporting support
Strong proficiency in Microsoft Excel, including formulas, data manipulation, Pivot Tables, and Pivot Charts
Experience with data visualization and reporting tools such as Tableau or Power BI; Power Query experience preferred
Experience with dashboard development and report building
Strong analytical, troubleshooting, and critical thinking skills with a focus on data quality and accuracy
Ability to proactively identify risks, resolve issues, and improve inefficient processes
Excellent verbal and written communication skills
Strong customer service skills with the ability to support internal and external stakeholders
Ability to manage multiple priorities and deliverables in a fast-paced, deadline-driven environment
Highly organized with excellent attention to detail and problem-solving abilities
Basic understanding of web-based data technologies and business immigration law preferred

Nice To Haves

Legal knowledge in the immigration field is a plus!
Power Query experience preferred

Responsibilities

Serve as a reporting case analyst ensuring all cases are moving in a timely manner in accordance with process and client SLAs.
Act as a Business Analyst in terms of gathering requirements, creating reports and dashboards, and being able to take constructive feedback is a must.
Create and update process guides to improve report monitoring.
Analyze and create 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