Develop and support the creation of data quality dashboards in Power BI, by extracting data from various Global SAP systems into Snowflake and develop rules for identifying DQ issues using MS SQL Server Management Studio.
Writing and creating data quality rules using SQL and working extensively with the business to define requirements to support continuous data quality monitoring.
Provide extensive data analysis and profiling across a wide range of data objects.
Reconcile data against source to ensure results are trustworthy and reliable.
Strong focus on high levels of process automation ensuring data and results are kept up to date.
Supporting remediation work to correct data on our SAP systems.
Facilitate matching or linking multiple data sources together and create complex joins to provide data discovery and continuous DQ monitoring.
Essential Requirements
Highly experienced in developing and supporting the creation of data quality dashboards in Power BI, by extracting data from various Global SAP systems into Snowflake and develop rules for identifying DQ issues using MS SQL Server Management Studio.
Advanced T-SQL skills to support Data Analysis, Data Profiling and Data Quality rule creation.
Demonstrated experience & subject matter expertise within data management disciplines, including the three pillars of data quality, data governance and data architecture.
Expert in extracting and manipulating data in various formats.
Experience in working in a complex SAP data environment.
Excellent written and verbal communication skills with the ability to influence others to achieve objectives.
Experience in Snowflake or similar for data lakes.
Strong desire to improve the quality of data and to identify the causes impacting good data quality.
Experience of Business and IT partnering for the implementation of Data Quality KPIs and visualisations.
Strong Stakeholder management skills.
Excellent attention to detail.
Ability to work in fast-paced, dynamic environment and manage multiple streams of work simultaneously.
Experience of working in a global organisation, preferably within the pharmaceuticals industry and or Supply Chain.
Experience of working in global change projects.
Bachelor degree in computing, data or a related technology field, or equivalent number of years of experience.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.