Data Engineer

As a Data Engineer at Morgan, Lewis & Bockius, you will help build and improve the firm’s data integration and data warehousing capabilities. This role reports to the Data Warehouse Manager and supports production systems through development, modernization, troubleshooting, and performance-focused enhancements. The position is hybrid based in Philadelphia, PA, with a mix of in-office and remote work.

What you will do

• Contribute to the firm’s SQL Server/SSIS-based ETL processes and cloud data platform initiatives, 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 across 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 and interfaces, including dependencies, and produce technical documentation such as data flow diagrams, ERDs, source-to-target mappings, and data lineage.
• Design and support integration approaches that account for transaction volumes, data availability and timeliness, regulatory and retention needs, security, privacy, and system dependencies.
• Troubleshoot, diagnose, and resolve production data, database, and integration issues in coordination with other IT teams as needed.
• Develop and maintain SSIS packages, Azure Data Factory pipelines, and Fabric Data Factory pipelines, along with SQL Server objects.

Qualifications

• Bachelor’s degree from a four-year college or university and minimum 5 years of experience, including 3 years of SQL development.
• 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, and Schemas.
• Hands-on experience in SQL and stored procedure tuning, including database reorganization.
• Strong verbal and written communication skills.
• Self-starter who applies strategic thinking and problem solving.
• Computer skills including MS Office (MS Word, PowerPoint, Excel).

Technologies

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

Certifications (recommended, not required)

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

For California applicants, pursuant to the California Consumer Privacy Act, the firm’s California Consumer Privacy Act Privacy Notice for Candidates explains the categories of personal information collected and the purposes for which it is used.