Posted Jun 24, 2026 236 views
Fulcrum Pvt Ltd is seeking a detail-oriented and skilled MIS Executive / Advanced Excel Specialist with at least four years of experience to join our Finance Department located in DHA, Karachi. This role demands a professional who excels in managing and analyzing large volumes of data, preparing comprehensive reports, and delivering actionable business insights through advanced Excel techniques. The specialist will be responsible for creating professional dashboards, automating reporting processes, and ensuring the accuracy and confidentiality of sensitive company data. The position entails coordinating closely with various departments to gather necessary data and provide meaningful analysis to support informed business decisions.
In addition to strong technical expertise in Excel including VLOOKUP, XLOOKUP, Pivot Tables, and advanced formulas, the candidate will oversee a small team comprising one member, guiding their efforts in data management and reporting. This supervisory aspect requires leadership skills to manage workflow efficiently, ensuring all data-related tasks meet quality standards. The MIS Executive / Advanced Excel Specialist plays a critical role in enhancing the reporting framework by implementing automation techniques such as VBA macros and Power Query, thereby driving continuous improvements in data reporting and visualization.
Responsibilities
- Prepare daily, weekly, and monthly Management Information System (MIS) reports to support business operations and decision-making.
- Manage and analyze large datasets using advanced Excel skills to identify trends, patterns, and insights relevant to business functions.
- Develop and maintain professional dashboards and custom reporting formats tailored to managements requirements.
- Create and utilize Pivot Tables, Pivot Charts, and advanced formulas such as VLOOKUP, INDEX & MATCH, SUMIFS, and COUNTIFS to enhance data analysis capabilities.
- Perform rigorous data cleaning, validation, and formatting to ensure high data quality and reliability.
- Utilize conditional formatting and data validation rules to improve report accuracy and readability.
- Maintain strict confidentiality and integrity of all company data throughout data handling and reporting processes.
- Generate performance and operational reports that provide actionable insights to management for strategic planning.
- Lead improvements in reporting automation by developing and implementing VBA scripts, Macros, and Power Query techniques.
- Collaborate and coordinate with different departments to collect accurate and timely data necessary for comprehensive reporting.
- Supervise and mentor a junior team member by assigning tasks, conducting reviews, and providing technical guidance on Excel functionalities and data management.
- Continuously monitor and enhance existing MIS processes to increase efficiency, accuracy, and ease of use.
Skills
Fulcrum Pvt Ltd
Fulcrum is an ISO 9001-2008 certified Business Consulting Services Company. We offer customers the following services (Human Capital Development and Management Solutions, Business Process Outsourcing, Executive Search, Training and Development and Information Technology) which encompass continuum of essential business services to meet their needs throughout the business cycle and help organizations focus on their strategic initiative.
What is your Competitive Advantage?
Similar Job Titles
Zohaib Ali
Marketing Manager
Digital Online Devices
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Muzammil Baig
Digital Marketing Manager
IT Services Group
Aqib Irshad
Head of HR, Training & OD
FINCA
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Ali Aziz
CEO
Shopistan
