Executive - MIS

Job Description

Title: Executive - MIS

Company Name: Healthcare Pharmaceuticals Ltd.

Vacancy: --

Age: Na

Job Location: Dhaka

Salary: --

Experience:

• At least 2 years
• The applicants should have experience in the following business area(s): Pharmaceutical/Medicine Companies

• Bachelor of Science (BSc) in Computer Science & Engineering
• Bachelor of Science (BSc) in Information Technology

B.Sc. (Hons.) in Computer Science & Engineering (CSE), Information Technology, or a related field, with minimum 2 years of experience in Business Intelligence, Data Analytics, or similar roles.

• At least 2 years
• The applicants should have experience in the following business area(s): Pharmaceutical/Medicine Companies

• Strong proficiency in SQL development (complex queries, stored procedures) and ETL processes, with sound knowledge of RDBMS and Data Warehousing (SAP HANA, SQL Server, Oracle, MySQL preferred).

• Practical experience in developing Bl reports and dashboards using SAP BI, Oracle BI, Power Bl, or similar tools (Qlik Sense, Tableau); knowledge of SAP ABAP programming will be considered an advantage.

• Expertise in data modeling, data normalization, data archiving, and advanced Excel skills including Power Query, PivotTables, complex formulas, and basic VBA macros.

• Strong analytical and problem-solving skills, high attention to data accuracy and quality, and ability to collaborate with cross-functional teams to translate business requirements into technical solutions

Healthcare Pharmaceuticals Ltd. is one of the leading pharmaceuticals companies in Bangladesh, certified by the international pharmaceutical regulatory authorities like TGA (Australia), NPRA (Malaysia), MCAZ (Zimbabwe), TFDA (Tanzania) etc. To support our expansion program, we are looking for candidates who are interested to join our team in the mentioned position.

Job Responsibilities:

• Develop and maintain advanced SQL queries, stored procedures, and scripts for complex data extraction, transformation, and analysis across multiple databases (SAP HANA, SQL Server, Oracle, MySQL)

• Design, automate, and manage dynamic dashboards and reports using Bl tools such as SAP BI, Oracle BI, and Power BI, ensuring data visualization supports key business decisions

• Perform data modeling, data normalization, and relationship mapping, and manage data archiving and historical data retention to ensure database optimization and integrity

• Develop, maintain, and monitor ETL (Extract, Transform, Load) processes to facilitate seamless data integration between various source systems and the Bl environment

• Leverage advanced Excel skills (Power Query, PivotTables, VBA macros, complex formulas) to consolidate, analyze, and visualize large datasets for operational and strategic reporting

• Collaborate with cross-functional teams (Sales, Marketing. Finance, IT) to gather requirements, translate business needs into actionable insights, and support sales forecasting, budgeting, and performance evaluation

Job function: Data Analysis

Location: Head Office