Data Analyst (BS-16)

Tourism Archaeology &; Lahore; On-site; PKR 1,000,000 - 1,800,000; Full time

Job summary

The Tourism, Archaeology & Museum Department seeks a Data Analyst to transform raw administrative, visitor, excavation, and conservation data into actionable intelligence for policy formulation and heritage site management in Punjab. You will bridge field operations and strategic planning, ensuring evidence-based decisions for tourism promotion and preservation across the region.

Daily tasks include extracting datasets from MIS, validating against registers, and generating dashboards using Power

Qualifications

• Degree in CS, Statistics or Data Science with strong data analytics exposure.
• Experience transforming raw data into actionable insights using SQL, Python/R.
• Proficiency with BI tools and dashboards for policy and heritage planning.

Responsibilities

• Transform administrative, visitor, and excavation data into actionable intelligence.
• Extract data from MIS, visitor logs, and field reports for analysis and dashboards.
• Clean and validate data; develop periodic dashboards for senior leadership.

Skills

Data analysis

Statistical reasoning

Education

Bachelor's or Master's in Computer Science / Statistics / Data Science

Tools

MS Power BI

ArcGIS

Advanced Excel

SQL

Python

R

Tableau

Job description

The Data Analyst (BS-16) in the Tourism, Archaeology & Museum Department serves as the primary technical resource for transforming raw administrative, visitor, excavation, and conservation data into actionable intelligence for policy formulation and heritage site management. This role bridges the gap between field operations at archaeological sites and museums and the strategic planning wing of the department, ensuring evidence-based decision-making for tourism promotion and heritage preservation across Punjab.

Daily workflows involve extracting datasets from the Department's Management Information System (MIS), digitized visitor logs at museums (e.g., Lahore Museum, Taxila Museum), and excavation progress reports from field directors.

The analyst cleans data using SQL and Python/R scripts, validates entries against physical registers (Accession Registers, Visitor Books, Conservation Logs), and generates periodic dashboards for the Secretary and Director General.

Key tools include MS Power BI for visualization, ArcGIS for spatial mapping of heritage sites, and Advanced Excel for financial reconciliation of ticketing revenue.

Career progression follows the BS-17/18 promotion track towards Senior System Analyst or Director (IT & Statistics) upon qualifying departmental promotion examinations.

Selection follows the Category A (Written Screening Examination Cadre) process conducted by the Punjab Public Service Commission (PPSC).

Candidates appear in a 100-mark MCQ-based written test covering Statistics, Data Analytics tools (SQL, Python/R, Tableau/Power BI), General Knowledge, Pakistan Studies, and Islamic Studies.

Candidates securing the qualifying merit (typically top 5-10 per vacancy) are shortlisted for document verification of academic degrees (MSc/BS in Computer Science, Statistics, Data Science) and experience certificates.

Final merit is determined by the Departmental Selection Committee interview assessing technical proficiency, domain awareness of heritage management, and communication skills.