Job Description
About the Role: Fragomen, an Am Law 100 firm and the leading immigration services provider, is seeking an experienced Data Analyst to join our team. The role will require a strong Excel skillset with a passion for delivering high quality data and visualizations. The role will not require prior immigration experience, but an interest in learning our field will be a key to success.
If you have superb data skills, have an analytical mindset and are a strong self-starter, this role is for you!
How will you make a difference as a Data Analyst - Immigration at Fragomen?
- Provide data analysis and reporting services to support attorneys, paralegals, legal teams, and clients.
- Assist with preparing client reports and arranging large data sets to produce clearly translatable action items based on internal data.
- Perform internal database information clean-up as needed.
- Use advanced Excel features such as xLookup, conditional formatting, filtering and macros to automate data sorting for clear presentation.
- Ensure data accuracy and integrity through quality control measures when handling sensitive or high-volume information.
- Analyze immigration data with Excel-based tools for case-specific tracking and immigration lifecycle management.
- Create dashboards, pivot tables, charts, and formulas to monitor immigration metrics and client-specific data insights.
- Act as a Subject Matter Expert within employment-based immigration and provide guidance to the greater team.
- Collaborate with attorneys and client stakeholders to generate custom reports and presentations.
- Perform audits and data integrity checks within Fragomen’s case management system and Excel spreadsheets.
- Work with clients to perform intake of cases, troubleshooting issues and establishing case strategy, along with recommending solutions and process improvements.
- Translate data into action items for the team, and clearly communicate next steps to internal stakeholders.
- Demonstrate a continuous improvement mindset and regularly look for opportunities to improve quality, efficiency, and standardization with processes, products, or services.
Leverage your valuable skills and experience to make an impact at Fragomen:
- 3 or more years of experience in a data analysis role
- As this role supports highly important immigration data, candidates without prior immigration experience should have a strong interest in immigration law and the immigration field
- Excel experience is required
- A variety of Excel skills, e.g. pivot tables, VLOOKUP/XLOOKUP, and macros are all preferred
- Experience creating high quality data and data cleansing
- Experience leverage data filters, conditional formatting, formulas and macros to sort and manipulate large datasets
- Excellent written and verbal communication skills, including the ability to proofread documents, draft fluent prose, and avoid grammatical mistakes without the aid of AI engines
- Experience building data visualizations
- Desire to contribute to a positive work environment through collaboration and teamwork
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
Learn More About Fragomen:
Please take time to read About Us, explore the Meaningful and Impactful Work we do for our clients, and review the standard Benefits we offer. You can find all the material to the right of this page.
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.
