Senior Data Engineer - Arlington, VA Hybrid

Sapient Corporation; Arlington (VA); Hybrid; USD 109,000 - 130,000; Full time

Benefits offered by this job

Health benefits

Paid leave

Wellness program

Learning opportunities

Job summary

Publicis Sapient in Arlington, VA seeks a Senior Data Engineer to build scalable data pipelines, orchestrate with Azure Data Factory, and load trusted data into the Enterprise Data Lake, Delta Lake, and Azure Synapse Analytics dedicated SQL pools.

You will own testing, data quality configuration, performance tuning, and production support across enterprise data solutions, collaborating with data architects, analysts, and business stakeholders. Hybrid work arrangement offered.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
• 4+ years of data engineering experience.
• 2+ years of Azure Databricks experience.
• Strong experience with Databricks, Delta Live Tables (DLT), Delta Lake, PySpark, Python, SQL, and Spark SQL.
• Strong experience with Azure Data Factory.
• Experience loading data via Enterprise Data Lake, Delta Lake, and Synapse.
• Experience configuring Databricks compute, data quality rules, monitoring, and optimization.
• Experience unit testing and coordinating integration testing/UAT.
• Experience creating HLDs/DDs and data pipeline documentation.
• Experience with Azure DevOps, Git, CI/CD and production deployments.
• Experience supporting production data platforms and incident resolution.

Responsibilities

• Create new batch and streaming data pipelines by leveraging existing ingestion frameworks and tools.
• Orchestrate, schedule, and monitor data pipelines using Azure Data Factory.
• Develop and enhance data transformations using PySpark, Python, and SQL.
• Parse, transform, and load data into Enterprise Data Lake, Delta Lake, and Azure Synapse dedicated SQL pools.
• Build and maintain Databricks data engineering solutions, including Delta Live Tables (DLT) and pipeline maintenance.
• Configure and maintain data quality rules, monitoring, and automated alerts.
• Perform unit testing and coordinate integration testing and UAT with business/tech partners.
• Create and maintain high-level designs (HLDs), detailed designs (DDs), data mappings, and runbooks.
• Tune and optimize Databricks, Spark, SQL, and Synapse workloads for performance/cost.
• Provide production support including incident troubleshooting and root-cause analysis.
• Use Azure DevOps and Git for source control, CI/CD, and controlled deployments.
• Collaborate with data architects, analysts, and stakeholders to deliver reliable data products.

Skills

Data engineering

Azure Databricks

Delta Live Tables

Delta Lake

PySpark

Python

SQL

Spark SQL

Azure Data Factory

Synapse

CI/CD

DevOps

Education

Bachelor's degree (CS/Engineering/IS)

Tools

Azure DevOps

Git

Job description

Senior Data Engineer - Arlington, Hybrid

As a Senior Data Engineer you will create and enhance scalable data pipelines using established ingestion frameworks, orchestrate workflows with Azure Data Factory, and develop transformations that load trusted data into an Enterprise Data Lake, Delta Lake, and Azure Synapse Analytics dedicated SQL pools. This role also owns testing, technical documentation, data quality configuration, performance optimization, maintenance, and production support for enterprise data solutions.

Your Impact

• Create new batch and streaming data pipelines by leveraging and extending existing data ingestion frameworks and tools.
• Orchestrate, schedule, and monitor data pipelines using Azure Data Factory.
• Develop and enhance data transformations based on business and technical requirements using PySpark, Python, and SQL.
• Parse, transform, and load data into the Enterprise Data Lake, Delta Lake, and Azure Synapse Analytics dedicated SQL pools.
• Build and maintain Databricks data engineering solutions, including Delta Live Tables (DLT), compute configuration, and pipeline maintenance.
• Configure and maintain data quality rules, validation controls, reconciliation processes, monitoring, and automated alerts.
• Perform unit testing and coordinate integration testing and user acceptance testing (UAT) with business and technology partners.
• Create and maintain high-level designs (HLDs), detailed designs (DDs), data mappings, operational runbooks, and support documentation.
• Tune and optimize Databricks, Spark, SQL, and Synapse workloads for performance, reliability, scalability, and cost efficiency.
• Provide production support, including incident troubleshooting, root-cause analysis, defect resolution, and operational maintenance.
• Use Azure DevOps and Git to support source control, CI/CD, release management, and controlled production deployments.
• Collaborate with data architects, analysts, business stakeholders, and support teams to deliver reliable enterprise data products.

Your Skills & Experience

• Bachelor s degree in Computer Science, Engineering, Information Systems, or a related field.
• 4+ years of data engineering experience, including hands-on delivery and support of enterprise data pipelines.
• 2+ years of hands-on Azure Databricks data engineering experience.
• Strong experience with Databricks, Delta Live Tables (DLT), Delta Lake, PySpark, Python, SQL, and Spark SQL.
• Strong experience orchestrating data pipelines with Azure Data Factory.
• Experience loading and serving data through Enterprise Data Lake, Delta Lake, and Azure Synapse Analytics dedicated SQL pools.
• Experience configuring Databricks compute, data quality rules, monitoring, maintenance processes, and workload optimization.
• Experience performing unit testing and coordinating integration testing and UAT.
• Experience creating HLDs, detailed designs, data pipeline documentation, and operational runbooks.
• Experience with Azure DevOps, Git, CI/CD pipelines, and production deployment practices.
• Demonstrated experience supporting production data platforms and resolving data pipeline incidents.

Additional Information

Salary Range: $109,000-130,000

The range shown represents a grouping of relevant ranges currently in use at Publicis Sapient. Actual range for this position may differ, depending on location and specific skillset required for the work.

As part of our dedication to an inclusive and diverse workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, color, national origin, ethnicity, gender, protected veteran status, disability, sexual orientation, gender identity, or religion. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us at [e-mail]

• An inclusive workplace that promotes diversity and collaboration.
• Access to ongoing learning and development opportunities.
• Competitive compensation and benefits package.
• Flexibility to support work-life balance.
• Comprehensive health benefits for you and your family.
• Generous paid leave and holidays.
• Wellness program and employee assistance.

#LI-Hybrid