Senior Data Warehouse Analyst
Universal City, CA

Job Description

Responsibilities

Role Purpose

The Senior Data Warehouse Analyst serves as a primary IT contact for the data warehouse reporting and analytics platform supporting the Brand Development division of NBCUniversal. This individual will be mostly internally-facing across IT teams, performing both functional and technical tasks to maintain the system and deliver projects.

Responsibilities

* Through data analysis and application review, as well as knowledge transfer from existing team members, quickly gain a deep understanding of business processes and source application data used to support the reporting and analytics for various departments within Universal Brand Development
* Partner with internal team members to understand and document user data requirements as they relate to new reporting requests, using this knowledge to develop functional requirements for new database structures and interfaces (ETL)
* Evaluate all new incoming data sources, profiling for data type and content, and ensuring that feeds meet established standards for format and transmission protocols.
* Work with the ETL development lead and our data architecture support team to implement new structures or modify existing ones, providing meaningful input to data modeling discussions as well as ETL design and development.
* Participate in designing, testing, and implementing system changes specifically related to these new and modified data structures, working with both onshore and offshore technical teams
* Design responsibilities include creating detailed documentation of data models and ETL logic, and general oversight of the development process
* Testing responsibilities include developing and executing use cases that cover both functional data requirements as well as source data validation


* Work closely with other application support teams to keep track of any changes that might affect data warehouse feeds, whether due to scheduling/timing or frequency of delivery, unexpected change in record counts, or of course structural changes to the incoming data that might cause a break in the regular process.
* Work with our ETL development team lead to recognize and implement opportunities for automation, performance improvements, scheduling improvements, etc.
* Monitor ongoing development efforts and provide regular progress reporting of current activities to IT and business teams

Qualifications/Requirements

Basic Qualifications

* Strong BI/DW technical analysis skills, including ability to read and interpret data models and entity relationship diagrams, as well as to read, write, and analyze complex SQL statements and their output
* Must have a minimum 3 years of recent hands-on experience with Teradata and Oracle database platforms and tools to analyze them (SQL Assistant, SQLDeveloper, etc.)
* Working knowledge of the Informatica toolset for ETL development, ideally with some hands-on experience


* Solid knowledge of data modeling concepts such as referential integrity, application-enforced integrity, data dependencies between source applications
* Prior experience working with centralized infrastructure teams for data architecture and database platform support
* Ability to organize and lead design sessions for all phases of database development, including data source review, data modeling, ETL design and logic
* Proven experience authoring functional requirements, as well as providing oversight, review, and final approval of technical specifications for database and ETL objects.
* Strong familiarity with scheduling/automation tools such as Control-M
* Experience with UNIX
* Experience with Microsoft data analysis tools such as Excel and Access
* The successful candidate will have strong experience in at least one of the following business disciplines: Retail Analytics, Contract Management, Product Development and Approval Systems, Finance/Accounting (SAP preferred)
* Bachelor's degree in Information Technology, Computer Science, or Computer-related degree
* Minimum 5 years of experience with data warehousing and business intelligence
* Minimum 5 years of experience with all phases of a software development lifecycle
* Minimum 3 years of experience in a data or business analyst role for a medium to large scale BI implementation

Eligibility Requirements

* Must be willing to work in Universal City, CA
* Must have unrestricted work authorization to work in the United States
* Must be 18 years or older

Desired Characteristics

Media / Entertainment background

Some retail experience a plus

Good understanding of BI tools, MicroStrategy a plus

Familiarity with Teradata, Oracle is a must

Ability to work independently and in a team environment

Experience with offshore development model