Lead Data Engineer

NBCUniversal•Universal City, CA

22d•$115,000 - $130,000•Onsite

About The Position

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.

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.

Nice To Haves

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

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.