Data Analyst

Prime System Solutions; Lahore; On-site; PKR 2,000,000 - 2,750,000; Full time

Job summary

A leading company is seeking a highly analytical Data Analyst to support its data warehouse initiative in Lahore. This role involves designing dashboards, optimizing SQL queries, and managing ETL pipelines. The ideal candidate will be skilled in PowerBI, SQL, and Azure Data Factory, providing actionable insights to drive business goals.

Qualifications

• Expertise in PowerBI, SQL, and DAX development.
• Hands-on experience with Azure Data Factory for ETL.
• Proven ability to optimize databases and architecture.

Responsibilities

• Develop and optimize dashboards using PowerBI.
• Design and manage SQL queries for data analysis.
• Leverage Azure Data Factory for ETL pipeline management.

Skills

PowerBI

SQL

DAX

Azure Data Factory

Analytical mindset

Job description

We're on a mission to accelerate a data warehouse buildout that will enhance analytics, reporting, and organizational intelligence across our teams. Working directly with Uzair and other internal stakeholders, this role is critical to bringing technical rigor and analytical firepower to our evolving data ecosystem.

Role Summary

Were seeking a highly analytical and technically skilled Data Analyst to support our data warehouse initiative. This individual will be instrumental in designing and delivering advanced dashboards, optimizing queries, and managing data pipelines through PowerBI, SQL, and Azure Data Factory. You'll play a strategic role in translating data into actionable insights that align with broader business goals.

Key Responsibilities

Data Analysis & Reporting

• Develop interactive and visually compelling dashboards using PowerBI
• Apply advanced DAX to enhance data models and reporting functionality
• Translate complex business requirements into scalable analytical outputs
  
  
  

️ Database Management

• Design and optimize SQL queries for data extraction, transformation, and analysis
• Collaborate with engineers to establish database indexing, schema development, and performance tuning
• Ensure the data layer supports efficient retrieval and high-quality insights
  
  
  

Data Integration & Workflow Automation

• Leverage Azure Data Factory (ADF) to build and manage ETL pipelines
• Integrate diverse data sources into centralized repositories
• Maintain data integrity, latency standards, and business logic accuracy
  
  
  

Collaboration & Communication

• Partner with internal stakeholders to define reporting needs and KPIs
• Present findings to both technical and non-technical audiences
• Support decision-making through clear data storytelling and actionable insights
  
  
  

Required Skills & Experience

• Expertise in PowerBI, SQL, and DAX development
• Hands-on experience with Azure Data Factory (ADF) for ETL and data integration
• Proven ability to design and optimize databases, indexes, and schema architecture
• Strong analytical mindset and attention to detail
• Ability to work independently, manage timelines, and communicate effectively
  
  
  

Preferred Qualifications

• Prior experience with data warehouse implementation or optimization projects
• Familiarity with cloud infrastructure and modern data architectures
• Understanding of data governance, security, and compliance best practices
• Experience in cross-functional teams and agile environments