Data Analyst

We are seeking a detail-oriented and proficient Data Analyst with a strong focus on Microsoft Excel. In this role, you will be responsible for collecting, cleaning, analyzing, and interpreting data using Excel to provide actionable insights and support data-driven decision-making.

Responsibilities:

Extract, clean, and transform data from various sources into Excel.
Develop and maintain complex Excel spreadsheets and workbooks.
Perform data analysis using Excel functions, formulas, charts, and pivot tables.
Identify trends, patterns, and anomalies in data.
Prepare clear and concise reports and visualizations in Excel to communicate findings.
Collaborate with other teams to understand data needs and provide analytical support.
Ensure data accuracy and integrity.

Qualifications:

Proven experience as a Data Analyst with a strong emphasis on MS Excel.
Excellent proficiency in Microsoft Excel, including advanced formulas (e.g., VLOOKUP, INDEX/MATCH, SUMIFS), data validation, charting, and pivot tables.
Strong analytical and problem-solving skills.
Ability to interpret data and translate findings into actionable insights.
Excellent attention to detail and accuracy.
Good communication and presentation skills.

Preferred (Optional):

Experience with other data analysis tools or programming languages (e.g., SQL, Python).
Bachelor's degree in a relevant field (e.g., Statistics, Mathematics, Business Analytics).

Benefits:

Weekly 2 Days Off
EOBI
Medical Life Insurance (IPD + OPD)
Annual, Casual and Sick Leaves (38)
Annual Increment (Performance based)

Skills

MS Excel MS Excel Dashboards Microsoft Power BI Microsoft SQL

Job Details

Industry:

Information Technology

Functional Area:

Data Entry

Total Positions:

1 Post

Job Shift:

First Shift (Day)

Job Type:

Full Time/Permanent

Department:

Human Resource Department

Job Location:

Ghari Shahu, Lahore, Pakistan

Gender:

No Preference

Minimum Education:

Bachelors

Career Level:

Experienced Professional

Minimum Experience:

3 Years

Apply Before:

May 22, 2025

Posting Date:

Apr 22, 2025

Abacus Consulting

Information Technology · 1001-1500 employees - Lahore

For over 23 years, Abacus Consulting has been offering cutting-edge business solutions helping organizations to transform their visions into realities through a combination of latest business methodologies and technological tools. The business value offered by Abacus Consulting has a deep scale, is industry focused and technology driven with a world class delivery capability. We help clients transform their businesses and be the market leaders. We offer a wide range of products and services, including strategy consulting, privatization and public-private partnerships, mergers, acquisitions and divestitures, business advisory services, sector search and research, environmental advisory services, SAP implementation and education, enterprise performance management, supply chain & operations management, application development and management, mobile applications, business process outsourcing, organization design and development, HR surveys, change management and HR functional solutions./p