Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 6 days ago

Data Engineer

Morgan, Lewis & Bockius LLP38 open roles

Where
Philadelphia, Pennsylvania
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowData EngineerMorgan, Lewis & Bockius LLP · Philadelphia, Pennsylvania

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Morgan, Lewis & Bockius LLP's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

12.3% of postings close within 7 days. Measured by our own scanner across the market. Morgan, Lewis & Bockius LLP postings stay open a median of 43 days.

Share of postings closed within
  1. 2.1%1 day
  2. 4.5%3 days
  3. 12.3%7 days
  4. 19.3%14 days
  5. 35.6%30 days
  6. 58.1%60 days
This job: posted 6 days ago

Morgan, Lewis & Bockius LLP median: 43 days open

The posting

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: 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 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. If you believe you need a reasonable accommodation during the application process, please contact Talent Acquisition at 888.534.5003 or [email protected]

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.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Morgan, Lewis & Bockius LLP's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Morgan, Lewis & Bockius LLP's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Morgan, Lewis & Bockius LLP's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.