Data Engineer

16 hours ago

Philadelphia, Pennsylvania, United States Morgan Lewis Full-time
Overview

Experience, qualification, and soft skills, have you got everything required to succeed in this opportunity Find out below.

As a Data Engineer at Morgan, Lewis & Bockius, you will support data services with a focus on integration, warehousing, and reliable data pipelines. You’ll work on SQL Server/SSIS ETL processes and cloud platforms like Azure and Fabric to modernize data solutions. The role sits in a hybrid Philadelphia office environment, collaborating with analysts, architects, and IT teams to ensure data availability, quality, and compliance. You will shape data flows and documentation to enable data-driven decision making across the firm. This role offers the chance to influence a modernization program at a renowned law firm.



Responsibilities
  • Contribute to SQL Server/SSIS ETL processes and cloud platforms (Azure, Microsoft Fabric).
  • Develop, support, and modernize data integration and warehousing solutions using SQL Server, SSIS, Azure SQL, ADF, Fabric, and Fabric Data Factory/Data Flows.
  • Support data warehouse and OLTP environments: 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 flows.
  • Analyze data sources, create data flow diagrams, ERDs, mappings, and data lineage; document technical interfaces.
  • Design data integration solutions considering volume, availability, timeliness, security, privacy, and dependencies.
  • Troubleshoot production data, database, and integration issues; coordinate with IT teams as needed.
  • Develop and maintain SSIS packages and pipelines (ADF, Fabric Data Factory) and SQL Server objects.

Key requirements
  • Bachelor degree with at least 5 years of experience, including 3 years in SQL development.
  • Hands-on experience with Azure Data Factory (ADF) and Fabric Data Factory (FDF), including pipelines, data integration, transformation, orchestration, and cloud/on-premises data sources and lakehouses.
  • Working knowledge of Microsoft Fabric and modern cloud data warehouse architectures (Fabric Data Warehouse, Lakehouse, OneLake, analytics services).
  • Experience designing and implementing cloud-based ETL/ELT solutions on Microsoft Azure and Fabric.
  • Experience with OLTP using Microsoft SQL Server; strong data warehouse design knowledge (data marts, star/snowflake schemas). xhuatnn
  • SQL and stored procedure tuning, and database reorganization; strong communication skills; self-starter and strategic thinker.
  • strong verbal and written communication
  • self-starter
  • strategic thinker
  • SQL Server
  • SSIS
  • Azure Data Factory (ADF)