Data Engineer

dlapiper; United States; Hybrid; USD 110,000 - 150,000; Full time

Job summary

DLA Piper is seeking a Data Engineer, Solutions & Data to design, build, and operate data pipelines and integration processes that translate raw data into trusted datasets for analytics and reporting. The role focuses on governance, data quality, and secure access across Azure-based tools.

Based in the United States with a hybrid schedule, you will collaborate with cross-functional teams to deliver analytics-ready data and reusable components that support multiple initiatives and faster

Qualifications

• Requires 3+ years in data engineering or data platform roles.
• Experience building data pipelines and data integration with governance.
• Proficient in SQL and Python; familiar with data modeling concepts.
• Scripting/automation skills with PowerShell or similar.
• Experience with Azure data services and cloud-based data warehousing.

Responsibilities

• Design, build, and operate data pipelines and integration processes.
• Consolidate data sources into centralized SQL-based point with mappings.
• Ensure data quality, performance, and security; monitor pipelines.
• Collaborate with engineers, analysts, and stakeholders in Agile pods.
• Provide reusable data assets and components for multiple initiatives.

Skills

SQL

Python

Azure Data Factory

Azure Databricks

Azure Event Hubs

SSIS

Azure Synapse

PowerShell

Java

Go

Education

High School or GED

Bachelor's Degree

Tools

Azure Data Factory

Azure Databricks

Azure Event Hubs

SSIS

Azure Synapse Analytics

SQL Server

Job description

DLA Piper is, at its core, bold, exceptional, collaborative and supportive. Our people are the backbone, heart and soul of our firm. Wherever you are in your professional journey, DLA Piper is a place you can engage in meaningful work and grow your career. Let's see what we can achieve. Together.

Summary

The Data Engineer, Solutions & Data role designs, builds, and operates data pipelines and data integration processes that translate raw data into trusted, usable datasets for analytics, reporting, and downstream solutions. The role focuses on operationalizing pipelines with governance and service expectations (SLAs), improving data quality and reusability, and enabling secure access to integrated data in support of business initiatives. In current initiatives, data engineering includes consolidating data from multiple sources into a central SQL-based integration point and performing field mapping and transformations, so solution teams can consume data consistently.

Location

This position can sit in any of our U.S. offices and offers a hybrid work schedule.

Responsibilities

• Data Pipeline Engineering & Integration: Build and operationalize data pipelines across heterogeneous environments, aligning to governance principles and service expectations (SLAs).
• Build and maintain ingestion, transformation, and publication of pipelines (data engineering practice) to deliver analytics-ready data.
• Consolidate data from multiple sources into a centralized integration point (e.g., a single SQL Server instance) and manage field mappings and transformations to support consistent downstream consumption.
• Data Platform & Storage: Design and implement data pipelines using Azure data technologies (e.g., Azure Data Factory, Azure Databricks, Azure Event Hubs, SSIS) to ingest, process, and deliver data from sources such as APIs and other systems.
• Build and maintain data warehousing capabilities (e.g., Azure Synapse Analytics) to support analytics and reporting workloads.
• Data Quality, Reliability & Operations: Identify, troubleshoot, and resolve data issues including data quality, integrity, latency, and security concerns; apply monitoring and operational best practices to keep pipelines reliable and performant.
• Contribute to data quality and governance practices, including profiling datasets, defining quality rules, and establishing monitoring/remediation approaches.
• Collaboration & Delivery (Agile Pod Model): Work cross-functionally with engineers, analysts, and stakeholders to understand requirements and deliver data solutions that support sprint-based delivery.
• Support pod-level delivery by producing reusable data assets and integration components that can be leveraged across multiple initiatives.

Desired Skills

• Proficiency in SQL and Python.
• Data pipeline tooling and cloud data services experience (Azure Data Factory, Azure Databricks, Azure Event Hubs, SSIS).
• Data warehousing experience (Azure Synapse Analytics) and strong fundamentals in data modeling, warehousing, and governance.
• Scripting/automation skills (PowerShell and related tooling) for platform operations and troubleshooting.
• Preferred experience includes familiarity with additional programming languages such as Java, Scala, or Go; experience integrating data from multiple enterprise source systems into a central SQL-based integration layer; and familiarity with DataOps concepts and operating in cross-functional teams that include data engineering personas.

Measures of Success

The measures of success for this role include delivering data pipelines with trusted, quality data with agreed service levels, enabling faster onboarding of new data and more consistent analytics/AI consumption and creating reduced manual effort through reusable integrations and standardized transformations, improved data reliability and operational readiness.

Minimum Education

High School or GED

Preferred Education

Bachelor's Degree in Computer Science, Engineering, or related field.

Minimum Years of Experience

3 years of experience in data engineering and/or data platform engineering (pipelines, integration, and operational support).

Essential Job Expectations

All DLA Piper employees are expected to demonstrate excellence in how we serve our clients and develop our people, upholding our firm values as part of our culture. Specific expectations include: Communicate effectively, both verbally and in writing, with clients, lawyers, business professionals, and external audiences. Produce high-quality work and respond to correspondence in an efficient, timely, and professional manner. Meet deadlines, manage competing priorities, and commit to meeting high standards. Comply with firm policies and procedures. Maintain confidences as required in a law firm environment.

Physical Demands

Sedentary work: This is primarily sedentary work, requiring occasional exertion of up to 10 pounds of force to lift, carry, push, pull, or move objects. The role involves sitting for extended periods, with occasional