Data Engineer
Philadelphia, PA - USA
Job Summary
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 Firms 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 Firms 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 bachelors 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
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 Firms 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. If you believe you need a reasonable accommodation during the application process please contact Talent Acquisition at 888.534.5003 or
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.
Required Experience:
IC
About Company
At Morgan Lewis our 2,200+ lawyers and legal professionals provide corporate, transactional, litigation, and regulatory services across all industries.