Executive – MIS

Healthcare Pharmaceuticals Ltd.

Healthcare Pharmaceuticals Ltd.

Follow

More jobs from this company

Summary

• Vacancy: —
• Location: Dhaka
• Experience: At least 2 years
• Published: 28 Apr 2025

Requirements

Education

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.

Experience

• At least 2 years

Additional Requirements

• 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

Responsibilities & Context

Job function: Data Analysis

Location: Head Office

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, Pivot Tables, 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

Employment Status

Full Time

Job Location

Dhaka

Source link