Location: Remote
Headquarter: Mumbai Maharashtra India
Position: Senior Data Quality Analyst
Summary:
Data Quality analyst will work with various data operational and execution teams to establish data quality polices and standards and implementing it to improve data quality with the help of tools, templates, KPI’s dashboards and act as quality advisory to the data stakeholders.
Key Role Outputs:
- Successfully establish data quality assurance policies, measurement criteria and SLA’s working with stakeholders
- Successfully identify data quality issues by implementing data quality measures and assurance polices
- Implement data quality reports and dashboards as per business requirements for various key processes.
- Successfully able to monitor, report and communicate data quality issues to all stakeholders
- Able to provide inputs in data quality process improvements and can provide updates for continuous data quality improvements
- Trusted, enterprise, business-driven data dictionary/glossary
Major Duties/Responsibilities:
Enterprise Master Data Quality Analyst:
The Enterprise Master Data Quality Analyst assists with the management of the company's data assets in order to improve and maintain timeliness and quality of the data. This enterprise role provides the specialist viewpoint when representing enterprise data initiatives.
- Design and establish data quality procedures for use in the data production process.
- Establish reporting mechanisms like scorecards, dashboards to demonstrate data quality issues
- Preparation of data quality assurance documents such as checklists, guidelines, manuals, templates, forms, etc..
- Establish data sampling best practices for data quality measures
- Establish automation procedure for obtaining recurring quality reports
- Collaborates with IS teams to prioritize and implement changes and strategies
- Identify, assess, fix, document, and communicate potential quality issues in the way data is collected, stored, processed, or used.
- Implementing data quality and validation reports in ETL tool i.e. SAP Information Steward for S4 Data migration process.
- Indepth expertise with SQL (Structured Query Language) and hands-on with writing data extraction queries.
- Expertise with SAP Master data objects, key tables and its relationships. Ex. Materials, Customers, Vendors.
- Setting up a data quality dashboards per business needs using Power BI/similar visualization tool.
- Uses reporting mechanisms (e.g., scorecard, dashboards) to identify gaps and trends in poor data quality or progress against KPIs and metrics
- Interacting with users to resolve data quality problems using techniques such as root cause analysis as well as collecting data quality requirements.
- Implement and monitor data quality procedures for use in the data production process.
- Monitoring of service level agreements and data quality assurance policies.
- Participate in cross-functional teams and assist various groups in design of test plans, data quality policy decisions, etc. to ensure data quality objectives are met.
- Design, collect, analyze, and report on data quality assurance / production performance metrics.
- Implement and execute data clean up measures
- Provide data quality training and presentations to members of organization.
- Document data quality assurance contribution to various projects and analyze the return on the use of quality data.
Data Governance Documentation Lead
- Establish and maintain data quality assurance policies.
- Ownership of enterprise data definitions, business rules, standards, and key design decisions (KDDs) within the enterprise Data Dictionary/Glossary
- and BPDs
- Establish and document best practices for data clean up
- Leads global data cleansing efforts for the respective master data responsibility area
Benchmarking, External Networking:
Incorporate industry best practices and tools based on emerging trends and changing business requirements. Benchmark and participate in sharegroups with other organizations in order to advance The Hershey Company’s capability.
Minimum knowledge, skills and abilities required to successfully perform major duties/responsibilities:
Leadership/Facilitator Skills:
- Ability to work well with others as well as part of a team
- Ability to adapt work style to other cultures and time zones.
- Ability to handle multiple priorities
- Strong drive for results
- Ability to sell ideas and influence peers and management
- Strong business and financial acumen
- Initiates projects resulting in increased efficiency
- Improvement mindset
- Act as change agent and champion approved change
- Strong communication skills
- Ability to lead and manage deliverables in large projects
- Strong English fluency
Technical Skills:
- Expertise with SQL for data extraction to build reports using multiple tables for Master data object.
- Expertise with SAP Master data model/technical structure and relationships between various tables.
- Understanding and experience with data quality process and various dimensions.
- Understanding of data migration process including scoping, profiling, classification, mapping, pre/post load validations, reconciliation.
- Experience with SAP Information Steward or any other data profiling/ETL tool - usage to build reports, setup tasks for scheduled refreshes, data profiling.
- Hands-on with Power BI is beneficial.
- Advanced MS Office skills (Excel, Word, PowerPoint, Sharepoint)
- Ability to interpret, establish and maintain data definitions, business rules and standards
- Advanced SAP skills (Master Data, Order to Cash, Inter-company accounting)
Minimum Education and Experience Requirements:
- 7+ years of data quality experience (EMDM - Enterprise Master Data Management, Data quality, ERP data migration, data Governance, data Profiling)
- Bachelors in Computer Science/ IT highly preferred or any Bachelors degree