Business Solutions Analyst, UP&E Data & Analytics

Sorry, this job was removed at 04:13 p.m. (PST) on Tuesday, Sep 24, 2024
Los Angeles, CA
Hybrid
85K-105K Annually
1-3 Years Experience
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment
NBCUniversal has a rich history of evolving the media and entertainment industry.
The Role

Company Description
At NBCUniversal, we believe in the talent of our people. It's our passion and commitment to excellence that drives NBCU's vast portfolio of brands to succeed. From broadcast and cable networks, news and sports platforms, to film, world-renowned theme parks and a diverse suite of digital properties, we take pride in all that we do and all that we represent. It's what makes us uniquely NBCU. Here you can create the extraordinary. Join us.
Job Description
The Business Solutions Analyst for data and analytics will provide valuable analysis and insight to all activities relating to the continued support and ongoing expansion of the data warehouse for the Universal Products & Experiences (UP&E) business solutions group. Reporting to the Director in charge of data and analytics for UP&E, this individual will be a key member of the team with focus on the following areas of responsibility: Data Analysis and Sourcing, Functional Data Requirements, Data Model Design review and approval, and ETL design review and approval. The Business Solutions Analyst will work with both internal and external technical resources, as well as our business partners, to develop and deliver solutions for everything from production bugs and minor enhancements to major business projects and initiatives.
Responsibilities

  • Partner with our Engineering and Data Architecture support teams to implement new structures and/or modify existing ones, providing meaningful input to data modeling discussions as well as ETL functional design and development
  • Evaluate all new incoming data sources, profiling for data type and content, and ensuring that new integration processes meet established standards for format and transmission protocols
  • Participate in designing, testing, and implementing system changes specifically related to any new or modified data structures, working with both onshore partners and offshore technical teams. This includes:
    • Gaining an understanding of business processes and source application data used to support the reporting and analytics for various departments within UP&E
    • Design - creating detailed documentation of data models and ETL logic, and general oversight of the development process
    • Testing - provide guidance and oversight to developers for initial unit testing, perform testing at the data level in test environment, manage handoff to BI lead to work with users on any additional reports-level testing
    • Implementation - confirm readiness for deployment and provide post-production review and final signoff
  • Continuous Improvement: Work with our Engineering and production support teams to recognize and implement opportunities for increased automation, better performance, scheduling optimization, etc.
  • Work closely with other application support teams to evaluate the impact of any changes that might affect existing data warehouse feeds, whether due to scheduling/timing or frequency of delivery, unexpected change in record counts, or structural changes to incoming data
  • Monitor ongoing development efforts and provide regular progress reporting of current activities to IT leadership and business partners


Qualifications

  • Minimum 2+ years of experience with developing and supporting data integration solutions for medium to large-scale data warehouses
  • Minimum 2+ years of recent experience supporting a large SQL database platform (Oracle, Snowflake, Teradata, etc.) and tools available to query/analyze them
  • Solid knowledge of data architecture and modeling principles, including data normalization, dimensional modeling, and referential integrity
  • Knowledge of and experience working with cloud architectures (AWS, Azure) for data integration
  • Strong data analysis skills, including ability to read and interpret data models and entity relationship diagrams for both the target data warehouse as well as source application systems
  • Strong SQL skills with hands-on experience both reading and writing statements with complex joins and advanced functions
  • Demonstrated experience authoring functional specifications for data integration, as well as providing oversight, review, and final approval of deliverables for database objects and integration processes
  • Experience working with an offshore development model
  • Ability to organize and lead design sessions for all phases of database development, including but not limited to data source review, logical and physical data modeling, and ETL/ELT design
  • Bachelor's degree in Computer Science, Data Science/Analytics, Software Engineering, or related field, or equivalent experience


PREFERRED QUALIFICATIONS:

  • Prior experience in the media industry is a plus
  • Experience with one or more of the following specific data disciplines: Retail Point-of-Sale Analysis, Contracts and/or IP Rights Management, Revenue Forecasting, Accounting/Controllership reporting
  • Familiarity with major reporting and analytics platforms tools such as Power BI, Tableau, MicroStrategy, etc.
  • Prior experience working with centralized infrastructure teams for data architecture and database platform support
  • Experience with Python scripting
  • Experience with Apache Airflow for ETL


Hybrid: 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: $85,000 - $105,000
Additional Information
NBCUniversal's policy is to provide equal employment opportunities to all applicants
\nand employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation,
\nmarital status, pregnancy, veteran status, membership in the uniformed services,
\ngenetic information, or any other basis protected by applicable law.
NBCUniversal will consider for employment qualified applicants with criminal histories,
\nor arrest or conviction records, in a manner consistent with relevant legal
\nrequirements, including the City of Los Angeles' Fair Chance Initiative For Hiring
\nOrdinance, 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, you have the
\nright to request a reasonable accommodation if you are unable or limited in your
\nability to use or access nbcunicareers.com as a result of your disability. You can
\nrequest reasonable accommodations by emailing [email protected].

What the Team is Saying

Naomi
Mike
Teela
Steve
Grace
Dora
Grander
Chris
Anne
The Company
Universal City, CA
50,000 Employees
Hybrid Workplace
Year Founded: 1910

What We Do

From film, television, news, theme parks, interactive media, and streaming, our people are at the center of it all. ​Here, we solve complex and business-critical problems. That’s why we’re looking for people to help us continue our evolution, imagining and delivering the most innovative and disruptive products and services through the latest tech advancements in the industry. ​

Here you can develop solutions. You’ll develop solutions that allow engineers to broadcast live TV from the comfort of their homes. These solutions will enable the use of our collection of hundreds of thousands of distinct intellectual properties across our film, television and streaming brands.

Here you can transform. You’ll make decisions and solve complex problems by leveraging insights that come from data, building AI to help enable solutions to optimize every aspect of our content eco-system.

Here you can build. You’ll build emerging immersive technologies that are used to power the broadcasts and streaming of global events like the Super Bowl and Olympics. You can create secure, elastic cloud-based services connecting parts of our global platform ecosystem that effect tens of millions of viewers, consumers and businesses that consume and love NBCUniversal’s content. And while you design, build and architect your career, we have the culture to make sure you’re supported.

Here you can work and still live your best life!

We’re leaders in our fields. We hire smart people and trust them to get the job done. We are never too busy to develop a fellow colleague. We understand our goals – or we ask. When we see something that needs doing – we do it. We make data-driven decisions. We fiercely believe in our talent and their growth. If you're ready to make an impact, here you can.

Why Work With Us

For us, it's more than just a work life. It's a daily passion. We take great pride in our legacy. We find fun in the challenge. We collaborate and inspire others. We're always creating, always solving and always ahead of competition.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

NBCUniversal Teams

Team
Tech that entertains the world
About our Teams

NBCUniversal Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Flexible
Universal City, CA

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account