Business Intelligence Technical Lead-Data Warehouse Job in Pasadena, California US
Business Intelligence Technical Lead-Data Warehouse
The Business Intelligence team is looking for a creative, skilled database architect with experience in a broad range of database and ETL technologies. Integrating information from across the enterprise is a key role of the BI team. As a BI Technical Lead, you will have the opportunity to design and oversee the implementation of a data warehouse, which will combine data from numerous sources into a single repository. Good communication skills, motivation, flexibility, and the ability to self-teach are all of paramount importance in order to be successful in this role. Responsibilities: - Data architecture, to include data modeling, development and reporting - ETL design and development (including knowledge of best practices) - Building OLAP solutions in MS SSAS - Creating and administering SQL Server databases from a wide variety of sources, using MS SSIS - Contributing to project timelines, budgets, and justifications - Implementation of new reporting and development tools - Adaptation/integration of existing tools - Administration/maintenance of Windows servers Qualifications: Basic Qualifications: - Bachelor's degree in a related field and/or 4 years of equivalent experience. - A minimum of 8 years of experience in technology consulting including research, synthesis, development, monitoring of technologies and consulting with management regarding recommended technology directions, maintenance and dissemination of standards. - 5 years minimum experience with MS SQL - Proven experience with OLAP technology - 2 years minimum experience with ETL - 3 years minimum experience with Data Warehousing - Ability to learn new technologies quickly, and without formal training Preferred Qualifications: - Experience with MS SQL Server Analysis Services (SSAS) - Experience with MS SQL Server Integration Services (SSIS) - Windows Server and IIS administration knowledge - Ability to present technical concepts to a non-technical audience - Master's Degree