Job Title – Data Management Analyst
Minimum Experience – 5-7 Years
Technical Skills Required – SAS (Strong Macro and SQL), Teradata, Unix Scripts, Autosys Scheduler, R/Python, Hue
1.Monitor and maintain production process which runs daily and produce base tables that feeds into all reporting and analytics. This includes ensuring we have required space available to run the job, archival of historical datasets, posting input files, cleaning up temp/ log files, resolving any process failures and validating the final output.
2.Check data availability and integrity across all digital data sources (EDW, Operations DB, CBOL Decision Engine, Clickstream tables) and work with the respective data owners for resolution.
3.Implement any new changes and logic in the code (e.g. adding promotional codes to track performance), test run and validate the results without impacting the regular production process.
4.Research new and existing data sources in order to contribute to new development, improve data management processes, and make recommendations for data quality initiatives.
5.Maintain best practices to ensure data are appropriately secured from security breaches.
6.Improve and customize current data solutions to meet business requirements. This includes migrating SAS based process from Unix platform to Big Data Hadoop platform using R/Python.
7.Provide approval for data implementation during migrations and perform periodic data quality reviews for internal and external data.
8.Perform complex data analysis and investigation for business requests to explain results and to make appropriate recommendations.
SAS, Strong Macro , SQL, Teradata, R/Python