Data Engineer

Morgan Lewis • Philadelphia, PA

5d • Hybrid

About The Position

Morgan, Lewis & Bockius LLP is seeking a Data Engineer to support the Firm’s data services. Reporting to the Data Warehouse Manager, the role focuses on data integration, data warehousing, SQL development, ETL/ELT processes, data pipeline development and support, troubleshooting, and modernization initiatives. The position is based in the Philadelphia office with a hybrid in-office/remote working schedule.

The Data Engineer contributes to the Firm’s SQL Server/SSIS-based ETL processes and cloud data platforms, including Azure and Microsoft Fabric. The role develops, supports, and modernizes data integration and warehousing solutions; supports data warehouse and OLTP environments; documents data flows and dependencies; and helps ensure data integration solutions account for transaction volumes, timeliness, regulatory and retention requirements, security, privacy, and system dependencies. The position also troubleshoots production data, database, and integration issues, coordinating with other IT teams as needed.

Requirements

• Bachelor’s degree from a four-year college or university.
• A minimum of 5 years of experience, including 3 years of SQL development experience.
• Hands-on experience with Azure Data Factory (ADF) and Fabric Data Factory (FDF), including pipeline development, data integration, transformation, orchestration, integration with on-premises and cloud data sources, and 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, and star and snowflake schemas.
• Hands-on experience in SQL and stored procedure tuning and 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, and Excel).

Nice To Haves

• Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics certification (recommended, not required).
• DP-700 – Fabric Data Engineer Associate certification (recommended, not required).
• DP-600 – Fabric Analytics Engineer Associate certification (recommended, not required).

Responsibilities

• 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 that consider 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 Fabric Data Factory pipelines, and SQL Server objects.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level