The role of the Data Analyst will play a pivotal role in operationalizing and managing data, analytics and digital business initiatives, and transitioning to an ongoing support model.
Responsabilities
Reporting directly to the Head of the Department of Information Management and Technology, the incumbent is responsible for:
• Analysis of health datasets and design of storage and view data models based on best practices, naming conventions and industry data modelling patterns (such as star schemas).
• Design and management of reference/master data tables
• Creation of ETL-like “pipelines” using the tool, to help users load arbitrarily formatted data
• Management of users, roles and permissions
• Setup of the data catalogue
• Driving automation through effective metadata management and assisting with renovating the data management infrastructure.
This will include (but not be limited to):
• Learning and using modern data preparation, integration and AI-enabled metadata management tools and techniques.
• Tracking data consumption patterns.
• Performing intelligent sampling and caching.
• Monitoring schema changes.
• Automating — existing and future integration flows.
• Collaborating across departments to work with varied stakeholders within the organization for managing various data and analytics initiatives and their data consumption requirements.
• Supporting, educating and training e.g. troubleshooting, and proposing appropriate (and innovative) data ingestion, preparation, integration and operationalization techniques in optimally addressing these data requirements.
• Participating in ensuring compliance and governance during data usage.
• Provide data management user support
• Help users troubleshoot data loading issues
• Be available online during specified hours to answer ad-hoc questions from the user community
• Contribute to training materials, such as documents or FAQs
• Initiate or participate in online meetings with the service manager and/or users.
• Support in-house custom tools used for data management
• Become a product specialist of in-house custom tools
• Suggest ideas for system enhancements and features
• Test new versions of the software
• Submit bug reports
• Liaise with vendors/suppliers and coordinate their work as needed
Profil
Technical Skills :
Ability to review raw data in different formats and coding schemes and propose data models, including, design of tables, data types, foreign key relationships, star schemas, fact tables, reference/dimension tables, etc.
Ability to suggest creative ETL solutions to transforming arbitrarily formatted and coded data.
Ability to write SQL SELECT queries/views using SQL Server Management studio.
Ability to perform functional requirements analysis and business analysis.
Knowledge of popular data discovery, analytics and BI software tools like PowerBI, Tableau, and others for semantic-layer-based data discovery.
Familiarity in advanced analytics/programming tools such tools such as DHIS, R, Shiny, Python, Javascript, and others.
Excellent analytical and troubleshooting skills
Experience in MS Office 365
Optional Skills :
Experience with job orchestration tools
Familiarity with AI, machine learning, data lakes
Soft Skills :
Ability to communicate clearly and concisely, orally and in writing and establish effective working relationships with people of different national and cultural backgrounds
Education and Certifications :
First-level university degree in computer science, statistics, applied mathematics, data management, information systems, information science or a related field.
Desirable :
Post-graduate degree in computer science, statistics, applied mathematics, data management, information systems, information science or a related quantitative field.
Professional qualification or foundation certification in analysis methodologies such as IIBA-CCBA/CBAP or PMI-BPA.
Certifications on database programming languages including SQL, PL/SQL, or emerging tools like NoSQL/Hadoop oriented databases like MongoDB, Cassandra, others.
