Senior data engineer

Publicis CoLab
Chicago, IL

Company description

With a history that dates back over 80 years, Starcom is a global communications planning and media leader. We are an agency still grounded in our founding principle that people are at center of all we do. Each day, we apply this belief to harness the transformative power of data and technology to inspire and move people and business forward. With more than 7,000 employees in over 100 offices around the world, Starcom partners with the world's leading marketers and brands, including Bank of America, Best Buy, Kellogg Company, McDonald's, Novartis, Samsung, Visa and more.

Overview

We are seeking an experienced and highly skilled Senior Data Engineer to join our dynamic team. The ideal candidate will have a minimum of three years of hands-on experience in the Azure Cloud ecosystem and a strong foundation in building, deploying, and optimizing robust data pipelines. This role requires technical expertise in modern data warehousing, data lake management, and demonstrating cutting-edge AI services to drive process automation and efficiency. The successful candidate will be a proactive, innovative problem solver with excellent communication skills, dedicated to continuous improvement of our data platform.

Responsibilities

  • Design and deploy robust Azure Data Factory pipelines for scalable data ingestion and transformation.

  • Develop and optimize data workflows across Azure SQL Managed Instance, Azure Fabric Data Warehouse , and ADLS / OneLake storage.

  • Work extensively with Parquet files , including integration with Azure Databricks, and configure Delta Sharing for secure data exchange.

  • Manage data in Azure Data Lake , ensuring performance, security, and governance standard processes.

  • Collaborate across teams to implement AI-enabled tools and services for process automation and operational efficiency.

  • Develop clean, maintainable code in Python for data processing and automation tasks.

  • Participate in architectural discussions, mentor junior engineers, and contribute to engineering standard processes.

  • Suggest and implement process improvements proactively to enhance system reliability and development efficiency.

Qualifications

  • 2 to 5 years of hands-on experience with Azure Cloud data services.

  • Expertise in Azure Data Factory, Azure SQL Managed Instance, and Azure Data Lake Storage (ADLS).

  • Experience working with Azure Fabric Data Warehouse and managing data in OneLake.

  • Strong skills in Python for data engineering and scripting.

  • Proficient in Databricks , including configuration for external Parquet files and Delta sharing setup.

  • Strong understanding of Parquet file formats , distributed processing, and big data pipelines.

  • Strong understanding of T-SQL and ability to optimize queries for cloud-native execution

  • Knowledge of Fabric notebooks (Python/Spark) for data transformation

  • Experience with dataflows Gen2 in Fabric for ETL/ELT workloads

  • Understanding of Fabric workspace management, capacity planning, and cost optimization

  • Familiarity with Entra ID (formerly Azure AD) authentication and security principals

  • Design and implement medallion architecture (Bronze/Silver/Gold layers) in OneLake for data quality and governance.

  • Excellent communication skills with a proactive, innovative approach to problem-solving and continuous improvement.

Additional information

Starcom is an Equal Opportunity Employer. Our employment decisions are made without regard to actual or perceived race, color, ethnicity, religion, creed, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, childbirth and related medical conditions, national origin, ancestry, citizenship status, age, disability, medical condition as defined by applicable state law, genetic information, marital status, military service and veteran status, or any other characteristic protected by applicable federal, state or local laws and ordinances.

The Power of One starts with our people! To do powerful things, we offer powerful resources. Our best-in-class wellness and benefits offerings include:

  • Paid Family Care for parents and caregivers for 12 weeks or more

  • Monetary assistance and support for Adoption, Surrogacy and Fertility

  • Monetary assistance and support for pet adoption

  • Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balance

  • Tuition Assistance

  • Paid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and more

  • Matching Gifts programs

  • Flexible working arrangements

  • 'Work Your World' Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)

  • Business Resource Groups that support multiple affinities and alliances

The benefits offerings listed are available to U.S. based employees, are reviewed on an annual basis, and are governed by the terms of the applicable plan documents.

Compensation Range: $72,390 - $99,960 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 12/01/2025.

If you require accommodation or assistance with the application or onboarding process specifically, please contact [email protected] .

All your information will be kept confidential according to EEO guidelines.

#LI-DF1

Posted 2025-11-06

Recommended Jobs

Policy Consultant => Relocate to China

北京智汇环宇国际咨询有限公司
Chicago, IL

Job Description: Working online. This is a part-time job, working from home accepted. The responsibility of the job is to provide analytical and advisory report, which reflect the latest policy …

View Details
Posted 2025-10-26

Designer (Production Artist)

Brookfield Zoo
Chicago, IL

Designer (Production Artist) Location Chicago, IL : The mission of the Chicago Zoological Society is to inspire conservation leadership by connecting people with wildlife and nature. The Design depart…

View Details
Posted 2025-11-03

Production Manager - Viper Product Line (Day Shift)

G&W Electric
Bolingbrook, IL

Production Manager Reporting to the Director of Operations, this role is responsible for managing manufacturing operations and employees for a designated value stream, with full accountability for re…

View Details
Posted 2025-08-06

Rockford Illinois Internal Medicine | 90 minutes to Chicago & Milwaukee

Enterprise Medical Recruiting
Illinois

A health system serving the growing community and patient base in Rockford, Illinois is welcoming BC/BE Primary Care Physicians to its team. This is a full-time, permanent, and employed position in N…

View Details
Posted 2025-09-29

.net developer

Insight Global
Chicago, IL

Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of …

View Details
Posted 2025-11-03

Scientist

Oracle
Springfield, IL

Job Description The computer vision team is responsible for growing our capabilities in image analysis and recognition. Our goal is to enable customers to apply computer vision to solve their p…

View Details
Posted 2025-10-24

PBM Underwriting Professional - PBM

Southern Scripts
Chicago, IL

PBM Underwriting Analyst (Remote) Role and Responsibilities The Underwriting Analyst will be a highly motivated individual with experience in the PBM or Health Care industry and should be detail…

View Details
Posted 2025-10-15

Paramedic and EMT B

Elgin Medi Transport Inc
Batavia, IL

Job Description Job Description Elgin Medi Transport is seeking reliable and compassionate Paramedics and EMT-Bs for FULL and PART-time positions at our Batavia station! We are a family-owned, te…

View Details
Posted 2025-10-22

Convenient Care (PRN) - Advanced Practice Provider

Carle Health
Bloomington, IL

Overview: Carle Health is seeking an  Advanced Practice Provider  to join our Convenient Care Department in Bloomington-Normal, Illinois. Opportunity Details: PRN position Diagnose and treat pa…

View Details
Posted 2025-09-26

Barista

Bar Tutto
Chicago, IL

Position Summary The Barista is responsible for preparing and serving coffee, espresso-based beverages, and other café offerings with efficiency, warmth, and precision. This role combines hospitalit…

View Details
Posted 2025-10-18