Job Description :
Near-Term – Maintain current data environment.
Ensure all automated data processes in SQL Server and Alteryx continue to run and update data sets in both SQL Server and Tableau Server.
Troubleshoot and repair processes that fail.
Ensure all manual data files continue to be picked up and dropped in the necessary file folder locations in order to be picked up by downstream Alteryx processes.
Provide general DB admin and optimization services for existing Brand Analytics SQL Server.
Mid/Longer-Term – Shift data processes from the Brand Analytics SQL Server to the new Hilton core enterprise data assets (i.e. the ‘data lake’) with the eventual goal of decommissioning the Brand Analytics Server. This includes the following:
Assisting the DnA data team in assessing if a particular data set is available in the new enterprise data environment.
If yes, transitioning the data process to use the new data environment.
If no, documenting that the data set is not available and determining if/when it might be made available.
Re-engineering data processes/ data tables as appropriate to more effectively manage data and ensure database/ application performance.
Working with the DnA data team to establish a MDM process/tool/application that will enable the Brands to more effectively track many ‘manual’ data sets.