Sr Data Engineer (Python & Airflow) REMOTE

Job description

Universal Ads, a part of Comcast, enables any brand, of any size, to seamlessly make and buy commercials across premium video reaching new qualified audiences at scale.

Universal Ads combines premium and brand-safe video content directly from the most influential media companies with the ease and familiarity of social ad buying.

It is your one-stop shop for high-quality video ads delivering performance and unmatched scale.

**Job Summary**

Responsible for designing, building and overseeing the deployment and operation of technology architecture, solutions and software to capture, manage, store and utilize structured and unstructured data from internal and external sources.

Establishes and builds processes and structures based on business and technical requirements to channel data from multiple inputs, route appropriately and store using any combination of distributed (cloud) structures, local databases, and other applicable storage forms as required.

Develops technical tools and programming that leverage artificial intelligence, machine learning and big-data techniques to cleanse, organize and transform data and to maintain, defend and update data structures and integrity on an automated basis.

Creates and establishes design standards and assurance processes for software, systems and applications development to ensure compatibility and operability of data connections, flows and storage requirements.

Reviews internal and external business and product requirements for data operations and activity and suggests changes and upgrades to systems and storage to accommodate ongoing needs.

Work with data modelers/analysts to understand the business problems they are trying to solve then create or augment data assets to feed their analysis.

Integrates knowledge of business and functional priorities.

Acts as a key contributor in a complex and crucial environment.

May lead teams or projects and shares expertise.
**Job Description**

**Required Skills**

+ 3+ Years of experience in Data Engineering
+ Experience with Python
+ Experience with Big Data
+ Experience with Data Pipelines (Airflow)

**Core Responsibilities**
Develops data structures and pipelines aligned to established standards and guidelines to organize, collect, standardize and transform data that helps generate insights and address reporting needs.
Focuses on ensuring data quality during ingest, processing as well as final load to the target tables.
Creates standard ingestion frameworks for structured and unstructured data as well as checking and reporting on the quality of the data being processed.
Creates standard methods for end users / downstream applications to consume data including but not limited to database views, extracts and Application Programming Interfaces.
Develops and maintains information systems (e.g., data warehouses, data lakes) including data access Application Programming Interfaces.
Participates in the implementation of solutions via data architecture, data engineering, or data manipulation on both on-prem platforms like Kubernetes and Teradata as well as Cloud platforms like Databricks.
Determines the appropriate storage platform across different on-prem (minIO and Teradata) and Cloud (AWS S3, Redshift) depending on the privacy, access and sensitivity requirements.
Understands the data lineage from source to the final semantic layer along with the transformation rules applied to enable faster troubleshooting and impact analysis during changes.
Collaborates with technology and platform management partners to optimize data sourcing and processing rules to ensure appropriate data quality as well as process optimization.
Creates and establishes design standards and assurance processes for software, systems and applications development to ensure compatibility and operability of data connections, flows and storage requirements.

Reviews internal and external business and product requirements for data operations and activity and suggests changes and upgrades to systems and storage to accommodate ongoing needs.
Develops strategies for data acquisition, archive recovery, and database implementation.
Manages data migrations/conversions and troubleshooting data processing issues.
Understands the data sensitivity, customer data privacy rules and regulations and applies them consistently in all Information Lifecycle Management activities.
Identifies and reacts to system notification and log to ensure quality standards for databases and applications.

Solves abstract problems beyond single development language or situation by reusing data file and flags already set.
Solves critical issues and shares knowledge such as trends, aggregate, quantity volume regarding specific data sources.
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.

Comcast will consider for employment applicants with arrest or conviction records in accordance with the requirements of applicable law, including the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Please note that federal state, or local laws and regulations may restrict or prohibit Comcast from hiring individuals convicted of certain crimes.

Additionally, an applicant’s criminal history may have a direct, adverse, and negative relationship on the job duties of this position, which may result in the withdrawal of a conditional offer of employment.

**Skills:**

Data Modeling; PostgreSQL; Amazon Elastic Compute Cloud (Amazon EC2); Amazon Athena; Apache Airflow

**Salary:**

National Pay Range: $90,010.97 USD-$210,963.22 USD Illinois Pay Range: $95,636.66 USD - $185,647.63 USD Colorado Pay Range: $101,262.35 USD - $194,086.16 USD Hawaii Pay Range: $118,139.40 USD - $177,209.10 USD Washington DC Pay Range: $129,390.78 USD - $194,086.16 USD Maryland Pay Range: $106,888.03 USD - $194,086.16 USD Minnesota Pay Range: $101,262.35 USD - $177,209.10 USD New York Pay Range: $106,888.03 USD - $210,963.22 USD Washington Pay Range: $101,262.35 USD - $202,524.69 USD California Pay Range: $101,262.35 USD - $210,963.22 USD New Jersey Pay Range: $112,513.72 USD - $202,524.69 USD Vermont Pay Range: $106,888.03 USD - $168,770.58 USD

Comcast 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.

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 (https://jobs.comcast.com/benefits) 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

**Job Family Group:** Enterprise Analytics & Data Intelligence

Required Skill Profession

Other General