Data Engineer

Morgan, Lewis & Bockius; Philadelphia (Philadelphia County); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Morgan, Lewis & Bockius is seeking a Data Engineer based in Philadelphia, reporting to the Data Warehouse Manager. This hybrid role focuses on SQL development, ETL/ELT pipelines, and modernization across Microsoft cloud platforms such as Azure and Fabric.

You will build and support data integration and warehousing solutions, collaborate with analysts and DBAs, document data flows, and ensure data quality, security, and timeliness across on-premises and cloud sources.

Qualifications

• Bachelor’s degree from a four-year college.
• Minimum 5 years of experience in data engineering.
• At least 3 years of SQL development experience.
• Hands-on experience with Azure Data Factory (ADF) and Fabric Data Factory (FDF).

Responsibilities

• Contribute to SQL Server/SSIS-based ETL processes and cloud data platforms (Azure, Microsoft Fabric).
• Develop, support, and modernize data integration and warehousing solutions (SQL Server, SSIS, Azure SQL, ADF, Fabric).
• Support data warehouse and OLTP environments including ingestion, transformation, and data quality.
• Collaborate with Business Analysts, Data Architects, Developers, DBAs, and IT teams to implement data solutions.
• Analyze data sources, document data flows (ERDs, source-to-target mappings, data lineage).
• Design integration solutions with attention to security, privacy, and regulatory requirements.
• Troubleshoot production issues across data, databases, and integrations with other IT teams.
• Develop and maintain SSIS packages and Fabric pipelines, plus related SQL Server objects.

Skills

Strong communication

Self-starter

Analytical thinking

Team collaboration

Problem-solving

Hybrid work mindset

Education

Bachelor’s degree

Tools

SQL Server

SSIS

Azure Data Factory

Fabric Data Factory

Azure SQL

Fabric

OneLake

Lakehouse

SQL

Stored procedures

Job description

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