Business Data Analysis Specialist at Fragomen in New York, NY

Summary: Fragomen is seeking an experienced Data Analyst to act as a primary point of contact between the business and external clients. The role involves developing detailed business requirements, designing reporting specifications, and ensuring timely case management in accordance with client SLAs. 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 Required Qualifications: - 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 - Applicants must be legally authorized to work in the United States without the need for current or future employer sponsorship Preferred Qualifications: - BS or BA preferred - Power Query experience preferred - Basic understanding of web-based data technologies and business immigration law preferred Required Skills: Microsoft Excel, Pivot Tables, Pivot Charts, Tableau, Power BI, Power Query, Dashboard development, Report building, Data quality, Data accuracy, Business analysis, Data analytics, Reporting support Benefits: Benefits offering, 401K, Paid time off plans