This job has closed.

Fragomen · 13 hours ago

Data Engineer

United States

Full-time

Remote

Senior Level

6+ years exp

Fragomen is seeking a Data Engineer to join their Data Engineering Team within Technology & Innovation. This role focuses on building and scaling cloud data pipelines on Microsoft Fabric while supporting and modernizing legacy on-prem SQL Server and SSIS workloads.

ConsultingDocument ManagementLegalLegal Tech

H1B Sponsor Likely

Responsibilities

Build and maintain end-to-end data pipelines using Microsoft Fabric

Develop orchestration using Fabric Data Factory pipelines

Build and manage Fabric Dataflows for ingestion and transformation

Develop PySpark transformations using Fabric Notebooks and Lakehouse architecture

Implement metadata-driven frameworks supporting incremental and full loads

Ingest data from databases, APIs, files, and semi-structured sources

Partner closely with Platform Administrators on: Workspace design and access controls, Capacity planning and performance, Deployment, monitoring, and operational standards

Follow and contribute to Fabric development and promotion standards

Support and enhance on-prem SQL Server and SSIS ETL workloads

Develop and optimize SSIS packages, T-SQL stored procedures, functions, and views

Troubleshoot performance issues and validate data across cloud and on-prem systems

Support incremental migration of legacy workloads to Fabric

Validate and reconcile data for accuracy and consistency

Collaborate with BI and analytics teams to support reporting needs

Document pipelines, frameworks, and operational processes

Participate in solution design and technical decision-making

Build robust, reusable, production-grade data pipelines

Apply strong engineering discipline including version control and structured deployments

Thrive in a collaborative, fast-paced environment

Qualification

Microsoft FabricFabric Data FactoryPySparkSQL ServerSSISMetadata-driven ETLJSONXMLAnalytical skillsTroubleshooting skillsSDLC understandingAgile understanding

Required

6+ years of experience in Data Engineering or related roles

Hands-on experience with Microsoft Fabric

Experience with Fabric Data Factory pipelines and Fabric Dataflows

Strong PySpark and SQL Server skills

Experience with SSIS-based ETL processes

Strong understanding of metadata-driven ETL design

Experience with JSON, XML, and semi-structured data

Excellent written and verbal communication skills

Preferred

Hybrid (cloud + on-prem) data architecture experience

CI/CD exposure for data engineering workloads

Power BI or downstream analytics experience

Company

Fragomen

Glassdoor3.4

Fragomen is a legal firm that provides crisis management, employment verification, compliance, document, and immigration services.

Founded in 1951

New York, New York, USA

5001-10000 employees

https://www.fragomen.com

H1B Sponsorship

Fragomen has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2)

2024 (2)

2022 (5)

2021 (1)

2020 (5)