Perform as the primary technical resource to design and implement enhancements and additions to an existing data warehouses which hosts multiple star schema based data marts. It’s projected that duties will include adding additional dimensions and attributes to existing stars, designing new stars from underlying data combined with new data sources. Primary work includes maintaining existing ETL procedures and packages. This position is writing SQL against the data warehouse using ETL tools to ensure that data sources are transferred from one database to the cloud. Strong SQL Server and SSIS is required.
Additional duties include design and implement an end user portal which will improve the data handling capabilities of the warehouse for an end user population.