Job overview
this position plays a pivotal role in the administration of our master data tools and workflows, encompassing the automation of master data processes and the development of queries and alerts that provide transparency into data quality.
key responsibilities
* manage functionality of workflows in winshuttle and perform advanced troubleshooting when required
* oversee pim including users/permissions, imports/exports, and integrations
* compose queries, primarily in microsoft sql enterprise data warehouse, to measure quality and completion of master data elements and populate alerting jobs when data rules are not met or elements are missing
* own the required functionality of s4 mda tool as it pertains to the overall master data workflow process
* collaborate with technology teams to ensure seamless integrations and troubleshoot when they fail
* develop views into data quality queries using microsoft power bi and partner with bi engineering team to buildout data quality power bi dataset
* designed, tested, and deployed workflow automation solutions to streamline sap master data processes
* collaborate with it to develop automated data pipelines, api integrations, and etl processes for efficient data management
maintenance and performance enhancement
* responsible for the maintenance and performance of our master data tools, including managing log files, maintenance/upgrades, outage communication and diagnosing system failures
* analyze problems and identify trends, ensuring management is informed of problem areas
requirements and qualifications
* bachelor's degree in computer science, mis, it or another technical computing field
* 3 years of professional experience in a related field
* experience with database design both conceptual and physical
* performance troubleshooting and resolution experience (index tuning, profiling, job scheduling)
* experience determining methods and procedures to be implemented and used on complex technologies to enhance performance
* experience with master data management and product information management systems required
preferred qualifications include:
* ms sql server database platform
* microsoft sql server integration services (ssis)
* microsoft sql server analysis services (ssas) preferred
* programming language experience with one or more of the following: c#, c++, python, r preferred
* working with and developing restful web services preferred
* developing web applications in a microsoft .net c# environment preferred
* microsoft sql server reporting services and/or microsoft power bi preferred
* microsoft dax query language preferred
* developing and supporting cloud-based (paas) database platforms, preferably microsoft azure preferred
* big data platforms and data lake environments such as hadoop preferred
* knowledge and experience of data science and machine learning techniques preferred
* security experience as it applies to compliance, protection of assets, and company security preferred
* excellent verbal and written communication skills, including the ability to deliver presentations and convey technical and design strategies to different audiences
* experience with azure devops a plus