> Markdown version of [/jobs/ext/4163261-data-engineer](https://www.wearedevelopers.com/jobs/ext/4163261-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Engineer

- **Company:** Morgan, Lewis & Bockius LLP
- **Location:** Philadelphia, PA, United States (Remote available)
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Microsoft Word, Microsoft Excel, Microsoft Azure, Databases, Data Integration, Extract Transform Load (ETL), Data Mart, Data Warehousing, Database Design, Database Development, Dimensional Modeling, Microsoft Office, Microsoft SQL Server, SQL Azure, Online Transaction Processing, Operational Databases, Performance Tuning, Microsoft PowerPoint, Cloud Services, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Data Streaming, Data Ingestion, Azure Data Factory, System Availability, Microsoft Fabric, Data Lineage, Data Pipelines
- **Published:** October 18, 2026
- **Apply:** https://diversityjobs.com/career/18686134/Data-Engineer-Pennsylvania-Philadelphia

## About the Role

* A bachelor's degree from four-year college or university and a minimum of 5 years of experience, including 3 years of SQL development experience.
 * Hands-on experience with Azure Data Factory (ADF), Fabric Data Factory (FDF), including pipeline development, data integration, transformation, orchestration, and integration with on-premises and cloud data sources as well as Lakehouses for FDF.
 * Working knowledge of Microsoft Fabric and modern cloud data warehouse architectures, including Fabric Data Warehouse, Lakehouse, OneLake and analytics services.
 * Experience designing and implementing cloud-based ETL/ELT solutions using Microsoft Azure and Fabric.
 * Experience with Online Transaction Processing (OLTP) using Microsoft SQL Server
 * Understanding of Data Warehouse Design including Data Marts, Multidimensional database design, Fact Tables, Star and Snow-flake, Schemas.
 * Hands-on experience in SQL and stored procedure tuning, database reorganization.
 * Strong verbal and written communication skills.
 * Self-starter and strategic thinker with problem solving skills.

Computer skills including; MS Office (MS Word, PowerPoint, Excel)

## Description

* Contribute to the Firm's SQL Server/SSIS-based ETL processes and cloud data platforms, including Azure and Microsoft Fabric.
 * Develop, support, and modernize data integration and warehousing solutions using SQL Server, SSIS, Azure SQL, Azure Data Factory (ADF), Microsoft Fabric, and Fabric Data Factory/Data Flows (FDF).
 * Support data warehouse and OLTP environments, including data ingestion, transformation, dimensional modeling, data quality, performance optimization, and integration.
 * Collaborate with Business Analysts, Data Architects, Developers, DBAs, and other IT teams to define and implement data.
 * Analyze data sources, interfaces, and dependencies and develop data flow diagrams, ERDs, source-to-target mappings, data lineage, and other technical documentation.
 * Design and support data integration solutions considering transaction volumes, data availability and timeliness, regulatory and retention requirements, security, privacy, and system dependencies.
 * Troubleshoot, diagnose, and resolve production data, database, and integration issues, coordinating with other IT teams as needed.
 * Develop and maintain SSIS packages, Azure Data Factory and Fabrice Data Factory pipelines, SQL Server objects.