Minimum of 5 years of experience in data engineering.
3 years of SQL development experience.
Hands-on experience with Azure Data Factory and Fabric Data Factory.
Working knowledge of Microsoft Fabric and cloud data architectures.
Experience with OLTP using Microsoft SQL Server.
Strong communication skills and problem-solving abilities.
Responsibilities
Contribute to SQL Server/SSIS-based ETL processes and cloud platforms.
Develop and modernize data integration and warehousing solutions.
Support data warehouse and OLTP environments, focusing on data quality and performance.
Collaborate with cross-functional teams to define and implement data solutions.
Analyze data sources and create technical documentation like data flow diagrams.
Design data integration solutions considering various requirements.
Troubleshoot and resolve production data and integration issues.
Benefits
Hybrid working schedule with flexibility between in-office and remote work.
Opportunity to work with modern cloud technologies and data architectures.
Collaborative environment with cross-functional teams.
Professional development opportunities through recommended certifications.
Full Job Description
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: 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
About Morgan Lewis
Morgan, Lewis & Bockius LLP is a global law firm. It provides legal services in areas such as antitrust, corporate, finance, intellectual property, labor and employment, litigation, mergers and acquisitions, private equity, public finance, real estate, restructuring and bankruptcy, tax, and trusts and estates. The firm serves clients in a variety of industries, including energy, financial services, healthcare, life sciences, retail, and technology. Morgan, Lewis & Bockius has offices in North America, Europe, Asia, and the Middle East.
