Job DescriptionThe 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.
QualificationsREQUIREMENTS- 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:
- 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 InformationAs 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.
