Data Analyst

Tourism Archaeology & Museum Department

Lahore

On-site

PKR 1,200,000 - 1,800,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Tourism Archaeology & Museum Department is seeking a Data Analyst (BS-16) to transform raw administrative, visitor, excavation, and conservation data into actionable insights for heritage site management and tourism policy in Punjab.

You will bridge field operations with strategic planning, validating data against registers and delivering periodic dashboards for senior officials. Strong skills in SQL, Python/R, and ArcGIS with experience in Power BI are essential.

Qualifications

  • MSc/BS in Computer Science, Statistics or Data Science.
  • Experience with data cleaning, merging, and validating large datasets.
  • Familiarity with MIS, visitor logs, and artifact inventories preferred.

Responsibilities

  • Design and maintain automated data pipelines ingesting visitor footfall, revenue data, and artifact inventory into the central MIS dashboard.
  • Conduct statistical analysis on tourism trends, demographics, and conservation expenditure for quarterly reports.
  • Develop geospatial layers in ArcGIS to map heritage sites, buffers, and encroachment alerts for GIS systems.
  • Validate digitized accession records against physical registers and resolve metadata discrepancies with curators.
  • Prepare data-driven briefs and visualizations for ADP reviews showing progress of conservation projects.
  • Train staff on data entry protocols, templates in MS Access/Excel, and cybersecurity hygiene.

Skills

SQL
Python/R
Data analysis
Statistics
Dashboards

Education

BSc or MSc in CS/Statistics/Data Science

Tools

Power BI
Tableau
ArcGIS
MS Excel
MS Access

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.

Key duties and responsibilities:
  • Design and maintain automated data pipelines ingesting visitor footfall, revenue collection, and artifact inventory data from district museums and archaeological sites into the central MIS dashboard.
  • Conduct statistical analysis on tourism trends, seasonal visitor demographics, and conservation expenditure patterns to produce quarterly analytical reports for the Provincial Development Working Party (PDWP).
  • Develop geospatial layers in ArcGIS mapping protected heritage sites, buffer zones, and encroachment alerts for integration with the Department's GIS-based Heritage Information System.
  • Validate data integrity of digitized accession records against physical museum registers (Form TAM-12) and coordinate with Curators to resolve discrepancies in artifact provenance metadata.
  • Prepare data-driven briefs and visualizations for the Annual Development Program (ADP) reviews, highlighting scheme-wise physical and financial progress of conservation projects.
  • Train subordinate staff (Computer Operators, Clerks) on standardized data entry protocols, template usage in MS Access/Excel, and cybersecurity hygiene for official correspondence.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst (BS-16)
Data Analyst (BS-16)

Tourism Archaeology & • Lahore

On-site
PKR 1,000,000 - 1,800,000
Heritage Data Analyst & GIS Visualization
Heritage Data Analyst & GIS Visualization

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 1,200,000 - 1,800,000
Heritage Data Analyst for Tourism & Preservation Insights
Heritage Data Analyst for Tourism & Preservation Insights

Tourism Archaeology & • Lahore

On-site
PKR 1,000,000 - 1,800,000
Tourism Investment Analyst
Tourism Investment Analyst

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 1,200,000 - 1,800,000
IT Digital Transformation Expert
IT Digital Transformation Expert

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 1,800,000 - 3,200,000
Research Associate
Research Associate

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 60,000 - 100,000
Digital Specialist
Digital Specialist

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 670,000 - 1,339,000
Videographer
Videographer

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 670,000 - 1,339,000
Content Writer
Content Writer

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 900,000 - 1,300,000
Graphic Designer
Graphic Designer

Tourism Archaeology & Museum Department • Lahore

On-site
PKR 1,000,000 - 1,400,000
Top locations