2,300,357open jobs
145,988companies
269,708added this week
Browse all
Location
In office (Atlanta)
Seniority
Senior
Visa
Sponsors visas in United Kingdom; no register of this country names it
Employment
Full-Time

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.

Overview
Company
Impact
Profile match
Fragomen is a corporate immigration law firm that advises multinational employers, government bodies and individuals on visas, work permits, global mobility programs and immigration compliance. Founded in 1951 by William Fragomen, it operates more than 50 offices across the Americas, Europe, the Middle East, Africa and Asia-Pacific, with large processing and support centers in India and the United Kingdom. The firm is headquartered in New York, New York, United States.

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.

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,300,357 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Remote, many countries
Similar stack
Same company
Atlanta
$132k – $252k per year · Remote (location not specified) · Nationals only · Full-Time · 10+ years exp · Bachelor's Degree · United States
AI/ML
OCR
Apply
$82k – $122k per year · In office · Full-Time · 5+ years exp · High School Diploma · United States
Apply
Power BI SME 1 hour ago
$110k – $125k per year · In office · Top Secret · 3+ years exp · Bachelor's Degree · Dahlgren
SQL
AI/ML
Machine Learning
DevOps
Azure
Analytics
Power BI
ETL/ELT
Apply
$113k – $193k per year · Hybrid · 5+ years exp · Eden Prairie
Python
SQL
Databases
Snowflake
Databricks
AI/ML
AI Agents
RAG
Machine Learning
DevOps
GCP
Azure
AWS
Management
Agile
Apply
$118k – $184k per year · In office · TS/SCI · Full-Time · 10+ years exp · Associate's Degree · Annapolis Junction
Apply
up to $27k per year · Remote (likely EAEU) · 3+ years exp
Python
SQL
1C
Databases
ClickHouse
Apache Iceberg
Trino
AI/ML
Airflow
dbt
DevOps
Amazon S3
Analytics
ETL/ELT
Data Vault
Apply
$22k – $26k per year · Remote (EAEU) · Moscow
SQL
Management
Confluence
Jira
Agile
Scrum
Kanban
UML
BPMN
Apply
$14k – $19k per year · Remote (EAEU) · Bachelor's Degree · Moscow
SQL
DevOps
Rest API
Cybersecurity
КриптоПро
Management
Agile
Kanban
BPMN
Apply
Remote (EAEU) · Moscow
DevOps
SOAP
Management
UML
BPMN
Apply
Remote (EAEU) · 3+ years exp · Saint Petersburg
Python
SQL
Databases
PostgreSQL
Snowflake
ClickHouse
Google BigQuery
Amazon Redshift
AI/ML
SciPy
NumPy
Statsmodels
Mobile
AppsFlyer SDK
Analytics
Tableau
Power BI
ETL/ELT
Metabase
Looker
Apply
In office · Public Trust · Full-Time · 6+ years exp · Bachelor's Degree · Atlanta
Analytics
Tableau
Power BI
Apply
$34k per year · In office · Full-Time · High School Diploma · Atlanta
Apply
Hybrid · Full-Time · 3+ years exp · Bachelor's Degree · Atlanta
AI/ML
Copilot
Cursor
ChatGPT
Claude Code
Prompt Engineering
Function Calling
AI Agents
RAG
AWS Bedrock AgentCore
LLM Guardrails
Agentic Workflows
DevOps
CI/CD
Cybersecurity
HIPAA
Least Privilege
Management
Jira
Agile
Apply
$67k – $116k per year · Hybrid · 3+ years exp · Bachelor's Degree · Atlanta · Indianapolis · Tampa · Miami · Wilmington
Apply
≈ $138k – $283k per year (Estimated) · Hybrid · Full-Time · 8+ years exp · Bachelor's Degree · Grand Prairie · Atlanta · Indianapolis · Overland Park · Durham
Python
Go
Java
TypeScript
AI/ML
Model Context Protocol
Function Calling
Anomaly Detection
Structured Outputs
LLM Guardrails
DevOps
Terraform
CloudFormation
CI/CD
AWS
Kubernetes
FinOps
Cybersecurity
Least Privilege
Apply
See all jobs
This is one of many
2,300,357 more open roles from verified company boards, updated every day.