Data Engineer
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
By continuing, you agree to our Terms & Privacy Policy.
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)