Primary functions: data architecture, data analysis and design, data standardization, data quality management, reference and master data management, data integration, data governance
Primary Deliverables: Data architecture, data flow, logical models, physical source data models, data profiling reports and data audits, data definitions, data taxonomy, data insights, meta-data, data lineage, data cleansing services
Activities: data modeling, data audit, detailed data design, define rules, establish master data solutions, define hierarchies and affiliations, profile|analyze|assess data quality, design data quality management procedures, clean and correct data quality defects, establish data governance.
Preferred candidate should:
• Demonstrate critical thinking, analytical skills, and employ judgment to offer thoughtful, concise input toward resolutions of problems.
• Be able to translate data requirements into business processes and reverse engineer business processes into data requirements
• Comprehension of DevOps and Agile development and application to data centric architecture and solutions
• Strong communication and interpersonal skills with strong English proficiency
• Leadership skills needed to successfully promote ideas, coordinate work activities, and plan deliverables within a project team.
• Minimum Bachelor’s Degree in Engineering Technology, Computer Science, or closely related field.
• This is a hands on role and the consultant should be able to work independently with business and also in a team environment
Technical Competencies:
• Advanced expert database handling languages (SQL Stored Procedures and variants)
• Expert in performance tuning Oracle/SQL Server procedures
• Expert in data modeling (physical and logical), ER diagrams, data dictionary, data map, normalize/de-normalize, agile data modeling
• Expert in data manipulation tools such as: SSMS, SSIS, TOAD, Access, Excel
• Expert in ETL tools preferably SAP Data Services
• Working knowledge of SAP and ability to identify the SAP Tables quickly
• Good to Expert Knowledge on SAP FICO and Sales & Distribution
• Practical skill sets in Data visualization tools preferably Tableau
• Knowledge of other programming languages and ability to write code (i.e. ABAP, Python)
• A minimum of 5 years’ experience in SAP Data Management and Governance, SAP Data Services (Data Extract, Data Profiling, de-duplication)
• Advanced competency in TOAD for Oracle, SQL Server Database, SAP HANA (Modeling, SDI, Stored Procedures) and Tableau
• A minimum of 5 years’ experience in SAP Data Management and Governance, SAP Data Services (Data Extract, Data Profiling, de-duplication)
• Advanced competency in TOAD for Oracle, SQL Server Database, SAP HANA (Modeling, SDI, Stored Procedures) and Tableau
• Basic Project Management and Business Process modeling