Data Engineer

Morgan Lewis; Philadelphia (Philadelphia County); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Morgan, Lewis & Bockius LLP in Philadelphia is seeking a Data Engineer to bolster the Firm’s data services with a focus on data integration, warehousing, SQL development, ETL/ELT processes, and modernization. The role follows a hybrid in-office/remote schedule in our Philadelphia office.

Reporting to the Data Warehouse Manager, you will contribute to SQL Server/SSIS ETL pipelines, develop cloud pipelines, ensure data quality, and collaborate with IT teams to design data flows, ERDs, and data

Qualifications

• Bachelor’s degree and 5+ years of experience, including 3+ years SQL development.
• Hands-on experience with Azure Data Factory (ADF) and Fabric Data Factory (FDF), including pipeline development and data integration.
• Working knowledge of Microsoft Fabric and modern cloud data warehouse architectures (Fabric Data Warehouse, Lakehouse, OneLake).
• Experience designing and implementing cloud-based ETL/ELT solutions using Microsoft Azure and Fabric.
• Experience with OLTP using Microsoft SQL Server.
• Understanding of data warehouse design including Data Marts, Star/Snowflake schemas, and data lineage.

Responsibilities

• Contribute to SQL Server/SSIS-based ETL processes and cloud data platforms (Azure and Fabric).
• Develop and modernize data integration and warehousing solutions using SQL Server, SSIS, Azure SQL, ADF, Fabric.
• Support data warehouse and OLTP environments, including data ingestion, transformation, and data quality.
• 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, and data lineage.
• Design and support data integration solutions considering security, privacy, regulatory, and performance requirements.
• Troubleshoot production data, database, and integration issues, coordinating with other IT teams.

Skills

SQL development

ETL/ELT development

Data warehousing

Azure data services

SSIS

Data modeling

SQL Server

Data integration

Education

Bachelor's degree

Tools

SQL Server

Azure Data Factory

Fabric Data Factory

Microsoft Fabric

On-premises/Cloud data sources

OneLake

Job description

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.

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

Education and experience

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

Certifications

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 #LI-Hybrid

Equal Employment Opportunity

Morgan, Lewis & Bockius LLP is committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities.

We value inclusion and solicit applications from all qualified applicants without regard to race, color, gender, sex, age, religion, creed, national origin, ancestry, citizenship, marital status, sexual orientation, physical or mental disability, medical condition, veteran status, gender identity, genetic information, or any other characteristic protected by federal, state, or local law.

Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment qualified applicants with arrest and conviction records.

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

Morgan, Lewis & Bockius, LLP reasonably accommodates applicants and employees who need them to perform the essential functions of the job because of disability, religious belief, or other reason protected by applicable law.

Employment Relationship

If hired, your employment relationship with the firm will be on an "at-will" basis, meaning that the firm may modify the terms and conditions of your employment at any time, and that either you or the firm will be free to end the relationship at any time with or without cause and with or without advance notice, although reasonable notice would be expected.

About Morgan Lewis

At Morgan Lewis, we work in collaboration around the world - always ready to respond to the needs of our clients and craft powerful solutions for them. From our offices in strategic hubs of commerce, law, and government in North America, Asia, Europe, and the Middle East, we work with clients ranging from established, global Fortune 100 companies to enterprising startups. We provide comprehensive litigation, corporate, finance, restructuring, employment and benefits, and intellectual property services in all major industries, helping clients address and anticipate challenges across vast and rapidly changing landscapes. And we approach every representation with an equal commitment to first understanding, and then efficiently and effectively advancing, the interests of our clients and arriving at the best results.

Search Firms

SEARCH FIRMS: Morgan Lewis does not accept resumes or referrals from search firms for most staff positions. If you are a search firm, employment agency, or representative of either, you will not be compensated in any way for your referral of a candidate to a position not approved for agency recruiters and/or for an inquiry submitted to anyone other than the recruiting contacts as listed on our main website.