Offer summary

Qualifications:

Bachelor's degree in computer science, Information Systems, or related field., Minimum 6+ years of experience in data warehousing and engineering., At least 2 years in a Technical Lead role leading a team of 6-8 developers., Extensive experience with Azure Data Factory architecture and implementation..

Key responsibilities:

Design and build cloud data pipelines using Azure Data Factory.

Develop and optimize ETL/ELT workflows with ADF components and scripting languages.

Lead a team of junior engineers and developers.

Monitor, troubleshoot, and tune data pipelines for performance.

Job description

Job Description:

We are seeking a seasoned Azure Data Factory (ADF) Technical Lead with proven track to build scalable data integration solutions using ADF (migration or new implementation). The ideal candidate will have hands-on experience building enterprise or Line of business specific data warehouses/marts.

Key Responsibilities:

Design and build Cloud code pipelines using Azure Data Factory.
Develop and optimize ETL/ELT CI/CD workflows using ADF pipelines, Data Flows, Linked Services, Integration Runtimes, and Triggers.
Leverage PySpark, Kafka, Kenesis and Python for data transformation, cleansing, and enrichment tasks within Azure Synapse or Databricks environments.
Work closely with Architect to build solution.
Lead team of junior engineers and developers.
Performance tuning, monitoring, and troubleshooting of data pipelines and workflows.

Required Skills & Experience:

Minimum Bachelor’s degree in computer science, Information Systems, or related field.
Minimum 6+ years of experience in data warehousing/engineering.
At least 2 years in Technical Lead role to lead team of 6 – 8 developers.
At least 2+ years in Azure Data Factory architecture and implementation (migration or new implementation).
Understanding of ADF components: Pipelines, Datasets, Linked Services, Integration Runtime, Data Flows, and Triggers.
5+ years of experience in building and managing enterprise/data warehouse solutions.
2+ years of experience with Azure tool stack.
2+ years’ experience in Python and PySpark, kafka, kinesis for data processing and scripting.
Knowledge of data modeling.
Experience in data privacy regulations (e.g., GDPR, HIPAA).
Experience in Databricks (on Azure) for large-scale data engineering and transformation workflows, including the use of PySpark, Scala, Delta Lake, and MLflow. Familiarity with Notebook-based collaboration and version-controlled data pipelines.
Proficiency in SQL (T-SQL or SparkSQL) for developing complex queries, views, stored procedures, and optimization. Solid experience in Python, especially data manipulation libraries like pandas, numpy, and integration with PySpark.
Knowledge (hands-on preferred) of Microsoft Fabric (OneLake, Lakehouse, Notebooks, Pipelines) as an interactive environment for unified data analytics and collaborative workflows across Power BI, Synapse, and Data Engineering workloads.
Experience with structured, semi-structured (JSON, Parquet), and unstructured data
Azure Schema design and optimization for performance
Azure certifications (e.g., Azure Data Engineer Associate, Azure Solutions Architect Expert).
Experience with CI/CD pipelines for data solutions using Azure DevOps.
Experience with stored procedures in SQL server and Oracle
Experience with pipeline automation tools like Fivetran or custom connectors.

The annual salary range for this position is $113,000-$182,850. Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

Benefits available with this position include:

• Medical, vision, and dental insurance,

• Life insurance,

• Short-term and long-term disability insurance,

• 401k,

• Flexible paid time off,

• At least 15 paid holidays per year,

• Paid sick and safe leave, and

• Paid parental leave.

Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies. For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com.

Ongoing basis verbiage: To begin the application process, please click on the “Apply” button at the top of this job posting. Applications will be reviewed on an ongoing basis, and qualified candidates will be contacted for next steps.

#LI-Remote

#LI-MS3

Location:

USA - Remote - Ohio

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent

Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color, national origin, sex , sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law.

Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e-mail to ApplicantAccommodations@dentsu.com by clicking on the link to let us  know the nature of your accommodation request and your contact information. We are here to support you. 

Required profile