Sr. Data Warehouse Engineer

Description

Responsibilities Design and support the database and table schemas for new and evolving sources of data Monitor and troubleshoot data issues on data warehouse servers Handle dimensional design as new areas of the business are loaded into the data warehouse Design and support the analysis services cubes to help with analytics Diagnose and resolve data warehouse ETL processes, data flows and business logic failures Work with database architects to define resource utilization needs Provide technical expertise and advice to business areas to help them smoothly transition manual reports and applications to the Business Intelligence environment Guide business areas in identifying new data needs and delivery mechanisms for reporting information Establish documentation of reports and data definitionsRequirements Associate, bachelor's or master's degree in business management, computer science or information technology Five years of experience with TSQL coding Two years of experience in performance tuning (SQL, ETL) Three years of experience with SQL Server Integration Services or similar ETL tools Two years of experience with SQL Server Analysis Services Two years of experience with dimensional modeling and other datawarehousing techniques