Data Engineer 2

Comcast Advertising is driving the TV advertising industry forward, from delivering ads to linear and digital audiences to pioneering the tech that makes it possible. We help brands connect with their audiences on every screen using advanced data, technology, and premium video content. Our media sales division helps local, regional, and national brands reach potential customers through multiscreen TV advertising. Our ad tech division FreeWheel provides comprehensive adtech that makes it easier to buy and sell premium video advertising across all screens, data types, and sales channels.

Job Summary

Looking for a skilled Data Engineer with expertise in SQL and Python experienced in building large-scale data pipelines using Apache Spark and designing robust data architectures on AWS. The ideal applicant will have hands-on experience and curiosity to learn and develop skills in data lake architectures, open table formats (Delta Lake), and modern data platforms delivery self-service analytics for large number of users. If you are a problem solver, a data platform enthusiast, and someone who thrives in fast-paced environments, this is an opportunity for you!

Job Description

Responsibilities:

• Architect, design, and build high-performance, scalable data pipelines that support large-scale data processing needs.
• Develop complex Big Data ETL workflows using modern frameworks such as Databricks Delta Live Tables (DLT).
• Design and implement robust data lake architectures, including open table formats such as Delta Lake and Apache Iceberg.
• Define, promote, and enforce data engineering best practices to ensure data quality, integrity, reliability, and performance.
• Lead the implementation of observability and monitoring across pipelines, including data cataloging, lineage, and metadata management.
• Contribute to peer reviews, knowledge sharing, production support, incident resolution, and change management activities.
• Adhere to code management and version control best practices across all development workflows.
• Produce high-quality documentation including data flows, lineage diagrams, and architecture details, aligned to data engineering documentation standards.
• Ensure comprehensive code coverage through the creation of unit and integration tests, following test-driven development (TDD) principles.
• Own critical components of large-scale batch ETL systems and clearly articulate data models and design decisions to Product, Engineering, and Leadership stakeholders.
• Manage multiple priorities effectively, balancing long-term architectural direction with immediate business needs.
• Build advanced semantic layers and support the creation of customer-facing self-service analytics solutions.
• Exercise independent judgment and discretion in handling complex and impactful technical decisions.
• Maintain regular, consistent, and punctual attendance, with flexibility to work nights, weekends, or variable schedules as required.
• Demonstrate strong understanding of semantic layer technologies such as Looker, Tab, Snowflake, and Databricks.
• Perform additional duties and responsibilities as assigned.

Qualifications:

• Minimum 2 yrs experience in Data Engineering.
• Proficient in Python, PySpark. Good grasp on SQL.
• Hands-on experience in Databricks and/or Snowflake is preferred
• Data Warehouse modeling paradigms
• Understanding of Cloud based architectures. We use AWS.
• Problem solving skills
• Nice to have: Certifications AWS Certified Developer AssociateDatabricks Certified Data Engineer AssociateSnowPro Advanced: Data Engineer

Employees at all levels are expected to:

• Understand our Operating Principles; make them the guidelines for how you do your job.
• Own the customer experience think and act in ways that put our customers first, give them seamless digital options at every touchpoint, and make them promoters of our products and services.
• Know your stuff be enthusiastic learners, users and advocates of our game-changing technology, products and services, especially our digital tools and experiences.
• Win as a team make big things happen by working together and being open to new ideas.
• Be an active part of the Net Promoter System a way of working that brings more employee and customer feedback into the company by joining huddles, making call backs and helping us elevate opportunities to do better for our customers.
• Drive results and growth.
• Support a culture of inclusion in how you work and lead.
• Do what's right for each other, our customers, investors and our communities.

Disclaimer: This information has been designed to indicate the general nature and level of work performed by employees in this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications.

Skills

Collaboration, Data Warehouse ETL, Technical Requirements

Compensation

This job can be performed in Illinois, and Massachusetts with a Pay Range of $79,728.27 - $132,880.46Comcast intends to offer the selected candidate base pay within this range, dependent on job-related, non-discriminatory factors such as experience. The application window is 30 days from the date job is posted, unless the number of applicants requires it to close sooner or later.

Base pay is one part of the Total Rewards that Comcast provides to compensate and recognize employees for their work. Most sales positions are eligible for a Commission under the terms of an applicable plan, while most non-sales positions are eligible for a Bonus. Additionally, Comcast provides best-in-class Benefits to eligible employees. We believe that benefits should connect you to the support you need when it matters most, and should help you care for those who matter most. That’s why we provide an array of options, expert guidance and always-on tools, that are personalized to meet the needs of your reality - to help support you physically, financially and emotionally through the big milestones and in your everyday life. Please visit the compensation and benefits summary on our careers site for more details.

Education

Bachelor's DegreeWhile possessing the stated degree is preferred, Comcast also may consider applicants who hold some combination of coursework and experience, or who have extensive related professional experience.

Certifications (if applicable)

Relevant Work Experience

2-5 YearsComcast is an equal opportunity workplace. We will consider all qualified applicants for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, veteran status, genetic information, or any other basis protected by applicable law.