Confirmed on the employer's own hiring board on Nov 16, 2026. First seen by Alion on Nov 16, 2026. Fragomen scores B on the Alion truth index.
Job Description
Position Summary
We are seeking a highly analytical and technically skilled Senior Data & Automation Analyst to support U.S. business immigration operations through data analysis, reporting, process automation, and digital solution development. This role will partner with legal teams, business stakeholders, and operational leadership to turn business needs into reliable, scalable solutions for internal and external users.
The successful candidate will combine strong immigration-domain knowledge with advanced Excel and Power Query capabilities, working knowledge of Power BI, and practical automation experience. This person must be comfortable taking an ambiguous request from discovery through delivery with limited oversight, while asking the right questions at the right time.
Key Responsibilities
Business Analysis & Solution Ownership
- Gather, clarify, and document business, reporting, and automation requirements from legal teams, operational leaders, and other stakeholders.
- Independently manage assigned solutions from initial discovery through design, development, testing, implementation, documentation, and ongoing support.
- Translate loosely defined needs into practical technical approaches, clearly identifying assumptions, dependencies, risks, and decisions.
- Ask targeted questions when appropriate and keep stakeholders informed of progress, constraints, and recommended next steps.
- Analyze current processes and identify opportunities to improve efficiency, consistency, data quality, and user experience.
Data Analytics, Reporting & Dashboards
- Design, build, maintain, and enhance dashboards and recurring reports in Microsoft Excel and Power BI.
- Use Power Query to extract, clean, transform, combine, and validate data from multiple sources.
- Create reporting solutions that support both internal operational users and external client-facing needs.
- Develop clear, decision-ready outputs with appropriate controls, validation steps, and supporting documentation.
- Troubleshoot data issues, reconcile results, and verify report accuracy and completeness before release.
Automation & Process Improvement
- Design, develop, test, deploy, and maintain automated workflows using Power Automate, UiPath, or comparable technologies.
- Use Excel, Power Query, Power BI, RPA, SAP, and Microsoft 365 tools in concert to reduce manual effort and create sustainable end-to-end solutions.
- Create monitoring procedures, process guides, and support documentation so automations can be operated and maintained by the broader team.
- Evaluate existing solutions and recommend modifications when business rules, source systems, or user needs change.
Platforms, Integration & Collaboration
- Build or support reports within SAP where feasible and appropriate.
- Integrate solutions with SharePoint Lists, document libraries, and related Microsoft 365 services.
- Contribute to low-code solutions using Power Apps when the use case warrants it.
- Partner effectively with legal, data, technology, and business operations teams.
- Provide training, knowledge transfer, and day-to-day technical support to solution users.
Required Qualifications
- Demonstrated knowledge of U.S. business immigration legal work involving skilled employment-based visa and permanent residence categories.
- Intermediate to expert proficiency in Microsoft Excel, including complex formulas, data validation, structured reporting, and dashboard development.
- Intermediate to expert experience with Power Query, including multi-source data transformation, data cleansing, merges, append operations, and reusable query design.
- Familiarity with Power BI, including report and dashboard development, data modeling concepts, and publishing or supporting business-facing content.
- Hands-on experience with Power Automate, UiPath, or another workflow/RPA platform, or desire to integrate these tools into product workflow, where appropriate.
- Demonstrated ability to combine multiple technologies into automated reporting or operational solutions.
- Strong analytical, troubleshooting, quality-control, and problem-solving skills.
- Ability to independently organize work, manage multiple deliverables, and drive requests to completion with limited oversight.
- Clear written and verbal communication skills, including the ability to work with technical and non-technical stakeholders.
- High attention to detail and sound judgment when working with sensitive legal, employee, and client data.
Preferred Qualifications
- Experience building reports or extracting data within SAP.
- Experience integrating solutions with SharePoint Online Lists and document libraries.
- Experience creating Power Apps or other low-code business applications.
- Working knowledge of Power BI semantic models, DAX, data relationships, refresh processes, and governance practices.
- Familiarity with relational data concepts, SQL, APIs, or structured data exchange methods.
- Experience supporting client-facing reporting, business operations, or professional services environments.
- Experience documenting solutions, developing user guides, and training end users.
Education & Experience
- Bachelor’s degree in data analytics, information systems, business, computer science, or a related field, or equivalent relevant professional experience.
- Prior experience in business analysis, reporting, data analytics, automation, or a related technical role.
- Professional experience supporting U.S. business immigration legal work is strongly preferred.
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.

