Data Entry & Advanced Excel Specialist

Core Edge Solutions is seeking a detail-oriented and organized Data Entry & Advanced Excel Specialist to join their team in Gulberg, Lahore. This on-site position requires working night shifts from 7:00 PM to 4:00 AM. The ideal candidate will have between six months to one year of relevant experience and possess strong skills in Microsoft Excel, data entry, data management, and reporting. The role involves handling large datasets efficiently, maintaining accurate records, and automating spreadsheet tasks to support business operations.

Key Responsibilities

- Accurately enter, update, and organize data within Excel spreadsheets and databases.
- Prepare, format, and maintain Excel reports, dashboards, and data summaries.
- Utilize advanced Excel formulas and functions for data management and analysis.
- Create and manage Pivot Tables, Power Query reports, and automated spreadsheets.
- Perform data cleaning, validation, deduplication, and error correction to ensure data integrity.
- Extract, consolidate, and organize data from multiple sources for reporting purposes.
- Identify and resolve missing values, duplicate records, and data inconsistencies.
- Maintain structured records while ensuring data accuracy and confidentiality.
- Automate repetitive data entry and reporting tasks using VBA macros.
- Collaborate with internal teams to collect, verify, and update necessary information.

Required Qualifications

- Advanced proficiency in Microsoft Excel, including Pivot Tables, Power Query, and Data Validation.
- Strong command of formulas such as VLOOKUP, XLOOKUP, INDEX/MATCH, nested IF, SUMIF, COUNTIF, and IFERROR.
- Experience with conditional formatting, dynamic arrays, and advanced text, date, and logical functions.
- Skilled in data sorting, filtering, formatting, and overall spreadsheet management.
- Ability to design Excel dashboards, consolidate data, and generate comprehensive reports.
- Accurate and efficient data entry skills with high attention to detail.
- Experience in data cleaning, deduplication, handling missing or NULL values, and data standardization techniques like Flash Fill and Text to Columns.
- Capability to manage large volumes of data while meeting strict deadlines.
- Basic knowledge of VBA for macros and task automation.
- Strong written and verbal communication skills are essential.
- Minimum of six months to one year of experience in data entry, Excel reporting, or data management.
- Excellent analytical and problem-solving abilities with a commitment to data accuracy.
- Educational background in IT, Computer Science, Business, or related fields is advantageous.

Preferred Qualifications and Benefits

- Basic understanding of SQL is a plus.
- Familiarity with Power BI and data visualization tools is considered an advantage.
- Experience with data exports and spreadsheet automation enhances candidacy.
- Monthly salary range is Rs60,000 to Rs80,000.
- This role requires willingness to work the night shift onsite in Lahore.

Candidates should be prepared to answer questions regarding their willingness to work night shifts, current and expected salary, and familiarity with advanced Excel functions. This position offers an excellent opportunity for professionals looking to develop their expertise in data management and advanced Excel within a dynamic work environment.