Data Developer

Major Responsibilities:

         Support LMD’s Logistics Management Information System (LMIS) unit to review data and its quality

         Interpret data and analyze results and quality of data using statistical techniques

         Develop the means and extract data from databases, data warehouses and transform and analyze it using best practice statistical methods

         Define and design data report formats based on the needs of stakeholders using Crystal reports, Power BI and other relevant presentation platforms.

         Use data mining and analyze data to define key performance indicators (KPIs) and dashboards based on inputs from supporting data and colleagues.

         Develop Crystal Report source files according to specifications and/or by reviewing existing reports extracting data from relational databases.

         Develop dashlet and presentation components on dashboard using PowerBI in conjugation with other relevant presentation utilities and platform by extracting data from MangoDB warehouse.

         Carry out data validation, integrity and consistency test by creating validation scripts and integration scripts manually or using automated tools.

         Supports project by understanding data and business processes impacting the application.

         Data Analysis of COVID-19 Logistic Management Daily Report of Central Stores, PHLMCs, Hubs & Hospitals

         Stock Summary Report of COVID-19 Commodities of Central Stores, PHLMCs, Hubs & Hospitals

         Work on Management Division Consumption, ASL & EOP Report of COVID-19 commodities

         Daily COVID-19 Response related tasks

         FY 2076/77 Q1/Q2/Q3 SDPs data

         Verification of Various COVID-19 related stores

         New COVID products availability check in the eLMIS

Qualification and Experience:

·         Bachelor’s degree, preferably in IT or communication background.

·         Must have supply chain management experience of public sector health commodities in Nepal

·         Basic knowledge of Software Development Life Cycle.

·         Strong written and verbal communication skills.

·         Worked in a similar capacity for preferably 3+ years

·         Proficiency in English and fluent in Nepali, if not native speaker.

·         Excellent understanding of data analytics tools

·         Ability to coordinate reviews, investigate data issues, and recommend corrective actions

·         Have 3+ professional working experience of data analysis using SQL Server reporting services, crystal report, MangoDB, PowerBI and other relevant data analysis tools

·         Advanced knowledge of relational data base technologies, standard query language, PL/SQL

·         Advanced knowledge of data warehouse technologies, ETL and data modeling techniques.