Lead Data Engineer

Company Description

Each day Universal Studios Hollywood creates unforgettable experiences for our guests from around the world. We bring to life the ultimate Hollywood experience with our real working movie studio and heart-pounding rides, shows and attractions that put you inside some of the world’s most popular movies and TV shows. USH offers something for everyone from thrill seekers to movie lovers to family fun for all ages. Our Team Members are passionate individuals who create memorable moments whether it’s on the studio lot, or in our conference rooms, theaters, or kitchens. We believe in the talent of our team members. It’s our passion and commitment to excellence that drives our business to succeed in everything we do across the park. We believe in a culture of family and fun, here you can make a difference and build your career!

NBCUniversal owns and operates over 20 different businesses across 30 countries including a valuable portfolio of news and entertainment television networks, a premier motion picture company, significant television production operations, a leading television stations group, world-renowned theme parks and a premium ad-supported streaming service.

Here you can be your authentic self. As a company uniquely positioned to educate, entertain and empower through our platforms, Comcast NBCUniversal stands for including everyone. We strive to foster a diverse and inclusive culture where our employees feel supported, embraced and heard. We believe that our workforce should represent the communities we live in, so that together, we can continue to create and deliver content that reflects the current and ever-changing face of the world.

Job Description

Want to play in the Data Cloud?  Are you an integration rockstar?  If you are, here’s a chance to becoming a celebrity at the Entertainment Capital of LA!  Universal Studios.

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 Studios Hollywood.  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 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 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.

This position has been designated as hybrid, generally contributing from the office a minimum of three days per week.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) 

Qualifications

• Bachelor’s degree from a four-year college or university is required, majors in a technical field preferred.
• 7+ 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 Teradata, Oracle, Snowflake etc.
• Experience in scheduling integration workflows and reports.
• Knowledge of cloud data platforms such as Snowflake
• 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:
• Tableau
• 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 Informatica Power Center
• Familiarity with Data Cloud tools such as Python
• Familiarity with one or more data modeling tools such as Erwin, Embarcadero, etc.
• Familiarity with Cloud Computing architectures, protocols, and practices

Additional Requirements:

• Must be willing to adhere to all Company COVID-19 workplace safety policies and protocols.

Additional Information

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 in a manner consistent with relevant legal requirements, including the City of Los Angeles Fair Chance Initiative For Hiring Ordinance, where applicable.

If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation if you are unable or limited in your ability to use or access nbcunicareers.com as a result of your disability. You can request reasonable accommodations in the US by calling 1-818-777-4107 and in the UK by calling +44 2036185726.