MIS & Data Analytics Lead (SQL, Power BI)

All Pakistan Solvent; Peshawar City Tehsil; On-site; PKR 1,100,000 - 1,600,000; Full time

Job summary

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

Qualifications

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

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

Skills

Database design

Data integrity

Cybersecurity

Tools

Power BI

ERP/CRM

SQL

Job description

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