Data Engineer

As a Data Engineer at Morgan, Lewis & Bockius, you will report to the Data Warehouse Manager and support the firm’s data integration and warehousing initiatives. This hybrid role is based in Philadelphia, Pennsylvania, with responsibilities spanning SQL development, ETL/ELT pipeline work, production support, and modernization across Microsoft cloud platforms.

Key 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), and Microsoft Fabric, including 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 solutions.
• Analyze data sources, interfaces, and dependencies, and produce technical documentation such as data flow diagrams, ERDs, source-to-target mappings, and data lineage.
• Design and support integration solutions with consideration for transaction volumes, data availability and timeliness, regulatory and retention requirements, security, privacy, and system dependencies.
• Troubleshoot, diagnose, and resolve production issues across data, databases, and integrations, coordinating with other IT teams as needed.
• Develop and maintain SSIS packages, Azure Data Factory pipelines, and Fabric Data Factory pipelines, along with relevant SQL Server objects.

Requirements

• Bachelor’s degree from a four-year college or university and minimum 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, 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, including database reorganization.
• Strong verbal and written communication skills.
• Self-starter mindset and strategic approach to problem-solving.
• Computer skills including MS Office (MS Word, PowerPoint, Excel).

Technologies

• SQL Server, SSIS, Azure, Microsoft Fabric, Azure SQL
• Azure Data Factory (ADF), Fabric Data Factory/Data Flows (FDF)
• OLTP, SSIS packages, SQL, stored procedures
• Fabric Data Warehouse, Lakehouse, OneLake, analytics services
• Multidimensional database design, Fact Tables, Star and Snow-flake, Schemas
• MS Office (MS Word, PowerPoint, Excel)

Certifications

Recommended but not required:

• Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics
• DP-700 – Fabric Data Engineer Associate
• DP-600 – Fabric Analytics Engineer Associate

Location and Work Model

Philadelphia, PA (hybrid: in-office/remote).

CCPA Notice for California Applicants

Pursuant to the California Consumer Privacy Act, the following link contains the Firm's California Consumer Privacy Act Privacy Notice for Candidates which explains the categories of personal information that we collect and the purposes for which we use such personal information. CCPA Privacy Notice for Candidates