Senior BI 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 theme parks and consumer experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, MSNBC, CNBC, NBC Sports, Telemundo, NBC Local Stations, Bravo, USA Network, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through Universal Filmed Entertainment Group and Universal Studio Group, and have world-renowned theme parks and attractions through Universal Destinations & Experiences. NBCUniversal is a subsidiary of Comcast Corporation.
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.
Comcast NBCUniversal has announced its intent to create a new publicly traded company ('Versant') comprised of most of NBCUniversal's cable television networks, including USA Network, CNBC, MSNBC, Oxygen, E!, SYFY and Golf Channel along with complementary digital assets Fandango, Rotten Tomatoes, GolfNow, GolfPass, and SportsEngine. The well-capitalized company will have significant scale as a pure-play set of assets anchored by leading news, sports and entertainment content. The spin-off is expected to be completed during 2025.
Find your path and kickstart your career at NBCUniversal! Be part of the premiere rotational program that gives early career talent a well-rounded experience along with unmatched exposure to the media industry. The NBCUniversal Page Program is based out of New York, NY (the East Coast Page Program) and Universal City, CA (the West Coast Page Program). NBCUniversal Pages get the opportunity to contribute to big, new ideas and trailblaze the future of our company and industry.
Job Description
Senior BI Engineer
NBCUniversal Media, LLC seeks Senior BI Engineer in Playa Vista, CA
12180 Millenium Dr., Playa Vista, CALIFORNIA 90094
Full-time

• Drive and participate in the definition, the direction, and the development of the BI Reporting Platform.
• Work with internal stakeholders to create the requirements and technical design of the BI Reporting Platform and related intelligence tools.
• Work with business owners, analysts, product managers, and data engineers to implement visual, actionable reports that meet quality and performance requirements.
• Develop, maintain, update and support reports and their underlying datasets based on feedback and business changes.
• Continuous improvements and optimization of existing BI Dashboards and Advanced SQL queries powering the datasets.
• Drive and contribute to every phase of the report development life cycle (design, development, testing, iteration, deployment).
• Recognize and implement best practices in reporting: data integrity, test design, analysis, automated validations, and documentation.
• Educate and train business owners on BI intelligence tools and reports.
• Support internal stakeholders with ad-hoc requests and reports.
• Develop and drive the adoption of self-service BI tools and solutions.
• Find opportunities to innovate and lead the way.

Hybrid work schedule (minimum 3 days in office).
Qualifications
Bachelor's degree in Computer Science, Information Systems, or a related quantitative field (or foreign degree equivalent).
The position requires five (5) years of experience in the job offered, in a Business Intelligence role focused on data warehousing and business intelligence tools, techniques, and technologies, or in a related occupation.
The position requires each of the following skills, which must have been gained through five (5) years of experience:

Developing Visualization reports, charts, dashboards at enterprise scale using one of market leading BI reporting technology - Tableau or Looker;

Data warehousing concepts;

Developing and delivering high quality, testable, production ready reports.

The position requires each of the following skills, which must have been gained through four (4) years of experience:

Writing Advanced SQL and Python scripts;

Any public cloud platform such as Amazon Web Services (AWS) at enterprise scale.

The position requires each of the following skills, which must have been gained through three (3) years of experience:

Working on enterprise scale Relational, Multi-dimensional & multi-threaded Datawarehouse Systems such as Redshift and Snowflake;

Designing ETL jobs using tools like Talend to bring in new datasets as well as transform existing data sources to efficiently power Viz Dashboards;

Data mining and developing SQL-based and Python based ETL processes for large-scale, complex datasets;

Working on distributed, scalable, service-oriented platforms;

Understanding of the agile software development life cycle and CI/CD framework using GIT Repo & Jenkins.

The position requires each of the following skills, which must have been gained through two (2) years of experience:

Designing data models for existing and new pipelines;

Distributed data architectures and their eco-systems, namely Hadoop, Hive, Pig, Spark, EMR, etc.

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: $140,358 - $153,830.50 per year
Full-time: 40 hours/week
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.
\n\n
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 [email protected].
\n\n
Although you'll be hired as an NBCU employee, your employment and the responsibilities associated with this job likely will transition to Versant in the future. By joining at this pivotal time, you'll be a part of this exciting company as it takes shape.