Mis Officer (BS-17)

All Pakistan Solvent; Peshawar City Tehsil; Vor Ort; PKR 1.100.000 - 1.600.000; Vollzeit

Zusammenfassung

All Pakistan Solvent Extractors Association (APSEA) invites applications for an MIS Officer (BS-17) to oversee the organization’s digital infrastructure and MIS. The role focuses on designing, maintaining, and securing databases tracking industry statistics, subscriptions, licensing data, and market intelligence critical to the solvent extraction sector.

The incumbent will administer the ERP/CRM platform, run complex SQL queries for monthly reports, and develop automated Power BI dashboards for

Qualifikationen

• Experience designing relational databases for member management, production statistics, and financial ledgers.
• Strong data governance, integrity checks, and dashboarding capabilities.

Aufgaben

• Design and normalize relational databases for member management, production statistics, and financial ledgers
• Develop and maintain automated ETL pipelines for importing customs and market data into the central repository
• Create dynamic executive dashboards using Power BI visualizing crush volumes, oil yields, and price trends
• Administer ERP modules including General Ledger, Fixed Assets, and Membership Subscription cycles
• Enforce cybersecurity policies: manage firewalls, SSL certificates, role-based access, and disaster recovery drills
• Liaise with external vendors for software customization, annual maintenance contracts, and server hosting renewals

Kenntnisse

Database design

Data integrity

Cybersecurity

Tools

Power BI

ERP/CRM

SQL

Jobbeschreibung

The MIS Officer (BS-17) at the All Pakistan Solvent Extractors Association (APSEA) serves as the primary technical custodian of the Association's digital infrastructure and management information systems. The role entails designing, maintaining, and securing databases that track industry statistics, member subscriptions, import/export licensing data, and market intelligence reports critical for the solvent extraction sector. The incumbent ensures data integrity, system uptime, and the timely generation of analytical reports for the Executive Committee and regulatory stakeholders.

Daily workflows involve administering the Association's ERP/CRM platform, executing complex SQL queries for monthly crush reports and oil recovery ratios, and developing automated Power BI dashboards for executive decision-making. The officer manages user access controls, performs scheduled backups on cloud/on-premise servers, and troubleshoots hardware/software issues for the secretariat staff. Coordination with the Federal Board of Revenue (FBR) and Pakistan Bureau of Statistics (PBS) portals for data reconciliation is a recurring operational requirement.

Selection follows a competitive Category A process: a 100-mark MCQ written screening examination covering Computer Science fundamentals, Database Management, Programming Logic, and General Awareness of the edible oil industry. Candidates scoring the qualifying threshold are shortlisted on merit for document verification (degrees, experience certificates, CNIC). Final selection is determined by the Departmental Selection Committee interview assessing technical proficiency, situational judgment, and communication skills, with final merit calculated per prescribed weightage.

Key duties and responsibilities:

• Design and normalize relational databases for member management, production statistics, and financial ledgers
• Develop and maintain automated ETL pipelines for importing customs and market data into the central repository
• Create dynamic executive dashboards using Power BI visualizing crush volumes, oil yields, and price trends
• Administer ERP modules including General Ledger, Fixed Assets, and Membership Subscription cycles
• Enforce cybersecurity policies: manage firewalls, SSL certificates, role-based access, and disaster recovery drills
• Liaise with external vendors for software customization, annual maintenance contracts, and server hosting renewals