Lead Data Engineer

Company Description

NBCUniversal is one of the world's leading media and entertainment companies. We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our global theme park destinations, consumer products, and experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, NBC Sports, Telemundo, NBC Local Stations, Bravo, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through our powerhouse film and television studios, including Universal Pictures, DreamWorks Animation, and Focus Features, and the four global television studios under the Universal Studio Group banner, and operate industry-leading theme parks and experiences around the world through Universal Destinations & Experiences, including Universal Orlando Resort, home to Universal Epic Universe, and Universal Studios Hollywood. NBCUniversal is a subsidiary of Comcast Corporation. Visit for more information.

Our impact is rooted in improving the communities where our employees, customers, and audiences live and work. We have a rich tradition of giving back and ensuring our employees have the opportunity to serve their communities. We champion an inclusive culture and strive to attract and develop a talented workforce to create and deliver a wide range of content reflecting our world.

Job Description

The Lead Data Engineer position will serve as a key contact for all business departments concerning reporting and analysis using the Enterprise Data Platform for Universal Destinations and Experiences (UDX). This is a dynamic and fast-paced environment. This position requires "hands-on" business intelligence knowledge to support the business in using tools for their decision making around attendance dynamics, food and retail profitability, sales and marketing initiatives and operations efficiency.

RESPONSIBILITIES

• Collaborate with Product and business areas to identify and assess business requirements for information/data and then provide options, risks, costs, and benefits for the appropriate solution.
• Provide project estimates for cost-benefit analysis.
• Assess and document the flow of data between system components.
• Able to develop, understand and interpret logical and physical data models.
• Partner with the application and data architects to ensure effective data schemas for operational applications.
• Establish scalable, efficient, automated processes for large scale data analyses model development, model validation and model implementation.
• Work as part of a team and with clients to develop cloud data and analytics solutions.
• Development of cloud data platforms and business intelligence solutions.
• Data wrangling of heterogeneous data sources for exploring and discovering new insights.
• Work with highly collaborative agile teams on modern data architecture projects.
• Help coordinate the development of necessary project documentation and standards required for compliance and identified best practices.
• Coordinate with the business users during project implementations and continue to serve as a point of contact for future data questions and issues.
• Participate in vendor management to include oversight and monitoring vendor progress of development deliverables through to implementation.
• Work effectively with Technology Operations/Infrastructure teams to ensure a seamless transition of the completed solutions to the responsible technology/3rd party support organization for its continued operations and maintenance.
• Ensure business user issues are resolved in a timely manner.
• Able to cross train and mentor others as needed.
• Facilitate and lead meetings and requirements gathering sessions with end users at all levels (VP, Director, Managers, and Subject Matter Experts).
• Keeps management, project managers, team members and business stakeholders informed of critical issues, project status, changes, etc.
• Able to embrace and adapt to change while demonstrating flexibility and the ability to develop and follow new processes.
• Other duties as assigned.
• Key success measures of a Lead Data Engineer include technical proficiency in data processing technologies, collaboration with other teams, communication, and willingness to learn new things.

Qualifications

REQUIREMENTS

• Bachelor's degree from a four-year college or university is required, majors in a technical field preferred.
• 10+ years of demonstrated experience working as part of large Information Technology teams and/or consulting organizations partnering with clients/business groups to support complex data warehouse environment.
• Hands-on experience in predictive modeling, analysis of large volumes of data and business intelligence/analytics, tools, protocols, and practices.
• Hands-on in understanding and writing complex SQL in Snowflake, Teradata, Oracle, etc.
• Experience in scheduling integration workflows and reports.
• Knowledge of cloud data and orchestration platforms such as Snowflake, Azure Data Factory, Airflow, and Harbor / Rancher.
• Knowledge of data requirements, data modeling concepts, data integration, master data management, metadata management.
• Demonstrated ability to produce high quality technical documentation.
• Knowledge of systems development and project management methodologies/processes.
• Knowledge of one or more reporting/ad-hoc analysis tools, at least one the following:
  • MicroStrategy
  • Power BI
• Knowledge of Agile/Scrum frameworks.

DESIRED CHARACTERISTICS

• Strong interpersonal skills, with a demonstrated ability to make effective decisions while working through complex issues
• Must be able to utilize and effectively communicate functional and technical components of an initiative to applicable parties both verbally and through documentation.
• Attention to detail, good analytical and problem-solving skills, and critical thinking
• A self-starter/motivator and having a proactive, agile, and strategic mindset
• Experience in the hospitality industry
• Experience with one or more ETL tools, preferred Snowflake / Snowpark
• Experience with Data Cloud tools such as Python, Airflow, AWS / S3, Harbor
• Experience with GitLab / GitHub
• Familiarity with one or more data modeling tools such as Erwin, Embarcadero, etc.
• Familiarity with Cloud Computing architecture, protocols, and practices

This position is eligible for company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks. Learn more about the benefits offered by NBCUniversal by visiting the Benefits page of the Careers website. Salary range: $115,000 - $130,000 (bonus eligible)

Additional Information

As part of our selection process, external candidates may be required to attend an in-person interview with an NBCUniversal employee at one of our locations prior to a hiring decision. NBCUniversal's policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law.

NBCUniversal will consider for employment qualified applicants with criminal histories, or arrest or conviction records, in a manner consistent with relevant legal requirements, including the City of Los Angeles' Fair Chance Initiative For Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act, where applicable.

If you are a qualified individual with a disability or a disabled veteran and require support throughout the application and/or recruitment process as a result of your disability, you have the right to request a reasonable accommodation. You can submit your request to View email address on click.appcast.io.