Senior Data & Automation Analyst
Fragomen
Atlanta, GA
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. Fragomen is the leading global immigration law firm with more than 6,000 professionals in nearly 70 offices across the Americas, EMEA and Asia Pacific, delivering services in over 170 countries. Ranked on both the Am Law 100 and Am Law Global 100, the firm is widely recognized for its leadership in immigration law and commitment to fostering a culture where diverse attorneys thrive and all individuals have equal opportunities to succeed. Fragomen helps corporations and individuals navigate the complexities of global mobility and provides end-to-end support across the immigration lifecycle, from strategic planning and policy design to compliance, government investigations, litigation and more. The firm combines legal acumen and advanced digital capabilities to simplify global mobility and deliver smarter, faster and more adaptive solutions via a suite of technology brands—including Nomadic, its business travel platform that enables real-time compliance, WorkRight, its multi-jurisdictional employment verification software and Simple Citizen, a digital solution designed to streamline the pathway to US citizenship. With a global presence, multidisciplinary approach and investment in technology, Fragomen is uniquely positioned to address today’s immigration challenges and shape the future of workforce mobility. Fragomen is committed to promoting diversity, inclusion and equal opportunity for all employees and applicants, regardless of race, ethnicity, heritage, gender, age, religion, disability, sexual orientation, gender identity or intersex status. At Fragomen, we do meaningful and impactful work for our clients and put a focus on our Responsible Business Practices: #LifeAtFragomen: We drive innovation and change. We respect colleagues, embrace diversity, and empower others. #FragomenForward: At Fragomen, pursuing an equal, diverse, and inclusive workforce goes beyond a policy. It’s part of our DNA—and always has been. Year after year, we are recognized as leaders in diversity in our industry. Giving Back. We have a deep history of giving back to the communities where we live and work—and we continue that mission today. Serving the less fortunate by providing advice and community support where it is most needed allows us to help immigrants secure a better future for themselves and their families. Corporate Social Responsibility. We believe there is more to success in business than generating profit—we want to do well by doing good. We are committed to considering the impact that our business decisions have on our people, our planet, the communities in which we work and our clients. Sustainability. Fragomen is focused on sustainability in our business operations and practices—and we know there is much work to be done, with countless opportunities available to minimize our impact on the environment Well-being. We are committed to implementing firmwide initiatives that support the health and wellness of our people, including programs to address work-life balance and benefits that cover a wide range of well-being needs of all employees. Our #FragomenWorks program provides the ability to be successful at home or in the office, via Hybrid & Remote work arrangements. Our Feedback Works process includes three managerial check-ins per year to help you progress in your career. Unique learning programs like: Fragomen Academy, Leadership Academy, Practical Management Academy, and Regional Development Conferences.
Apply on firm site →