Primary Responsibility : Responsible for developing, customizing, maintaining, troubleshooting and implementing the data warehouse for Starz Entertainment.
Essential Duties and Responsibilities:
Develop data warehouse star schemas such as, dimensions, facts and measures.
Responsible for understanding concepts, best practices and functions of a data warehouse in the corporate environment.
Analyze source system data and create staging designs and dimensional data models.
Troubleshoot and resolve performance issues with overall infrastructure.
Translate reporting requirements into technical specifications and data warehouse solutions.
Analyze data from multiple data sources and develop a process to integrate the data into a single but consistent view.
Develop and maintain ETL stored procedures to load data originating from Sybase ASE, Microsoft SQL Server, and Oracle into the data warehouse.
Analyze complex data patterns in order to establish technical solutions to resolve data issues in fast paced environment.
Coordinate the efforts of multiple technical resources to ensure the solution is implemented timely and precisely.
Develop standards and processes to ensure the successful operational support required to ensure daily reporting is timely and accurate, so that day-day-business decisions can be made by the executive staff.
Responsible for fully documenting the data warehouse environment and operational components.
Education, Knowledge, and Experience:
Bachelor’s degree in Computer Science or similar discipline preferred; Five years’ related IT experience; Experience with and comfortable engaging and working with all levels of business stakeholders; And/or training; And/or equivalent combination of education and experience.
Experience with complex enterprise business applications data discovery, dimensional modeling/data warehousing and relational databases utilizing Enterprise Reporting tools such as Business Objects, Cognos or OBIEE.
Sybase ASE, Sybase IQ and/or Microsoft SQL Server experience required.
Strong communication and team building skills.
Desire to work in a heavily collaborative environment, taking on a variety of roles when necessary.
Starz Entertainment, LLC - 16 months ago