Sr. Data Engineer - Reston, VA - Freewheel

FreeWheel, a Comcast company, provides comprehensive ad platforms for publishers, advertisers, and media buyers. Powered by premium video content, robust data, and advanced technology, we're making it easier for buyers and sellers to transact across all screens, data types, and sales channels. As a global company, we have offices in nine countries and can insert advertisements around the world.
Job Summary
This role concentrates on advanced data structures and pipelines development and maintenance, upholding quality and integrity in diverse storage solutions. It involves optimizing data flows, mentoring junior engineers, and contributing to internal tool development. The role serves as a key expert, providing strategic guidance and innovative solutions in data engineering.
Job Description

• Advanced SQL skills
• Proficiency in a programming language (Python preferred)
• Experience with distributed computing frameworks (e.g., Apache Spark)
• Proficiency in Cloud data warehouse management workflow orchestration & automation
• Experience working on at least one cloud provider (AWS, GCP, or Azure)
• Experience with data pipeline design patterns, data modeling & data observability
• Ability to independently own modules and communicate & review technical designs
• Exposure to Ad-Tech platforms highly preferred but not required
• Prior experience or exposure to delivery customer facing data products and understanding of modern data stack - dbt, airflow, embedded analytics is highly preferred (not required)
• Enjoy working in challenging Analytics use cases and hard data shaping challenges
• Experience in collaborating with multiple teams delivering impactful work

Responsibilities:

• Developing data structures and pipelines to standardize and transform data, ensuring insights generation and reporting needs are met
• Ensuring data quality throughout ingestion, processing, and loading to target tables, maintaining high standards
• Creating ingestion frameworks for structured/unstructured data, implementing quality checks and reporting mechanisms
• Establishing methods for data consumption by end users and downstream applications, including database views and APIs
• Implementing data solutions on platforms like Kubernetes, Teradata, and Databricks, ensuring alignment with architectural standards
• Determining appropriate data storage on platforms based on privacy, access, and sensitivity requirements
• Understanding data lineage and transformation rules for efficient troubleshooting and impact analysis during changes
• Collaborating with management partners to optimize data sourcing and processing, enhancing data quality and process efficiency
• Mentoring junior data engineers, fostering skill development and knowledge sharing within the team
• Contributing to the creation and refinement of internal data engineering tools and frameworks to improve efficiency and scalability
• Consistent exercise of independent judgment and discretion in matters of significance.
• Regular, consistent and punctual attendance. Must be able to work nights and weekends, variable schedule(s) as necessary.
• Other duties and responsibilities as assigned.

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.
Comcast 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.
Skills:
Understanding Data; Data Engineering; Data Warehouse Modeling; Snowflake (Platform); Dimensional Data Modeling; Structured Query Language (SQL); Data Structures
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 Degree
While 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.
Relevant Work Experience
7-10 Years