Data Engineer

• 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.

• 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)

Morgan, Lewis & Bockius LLP, a leading global law firm with offices in major commercial, legal, and governmental hubs worldwide, is seeking a Data Engineer. Reporting to the Data Warehouse Manager, the Data Engineer is responsible for supporting the Firm’s data services, with a focus on data integration, data warehousing, SQL development, ETL/ELT processes, data pipeline development and support, troubleshooting, and modernization initiatives.

This position will reside in our Philadelphia office with a hybrid in-office/remote working schedule.