Data Entry & Advanced Excel Specialist

Core Edge Solutions is looking for a detail-oriented and organized Data Entry & Advanced Excel Specialist to join their team in Gulberg, Lahore. This is an on-site role requiring night shift availability from 7:00 PM to 4:00 AM. The ideal candidate will have between six months to one year of experience in data entry, data management, and advanced Excel reporting. Strong expertise in Microsoft Excel, including advanced functions and automation, is essential. The position involves managing large datasets with accuracy, preparing detailed reports, and creating dashboards to support business needs.

Key Responsibilities
- Accurately enter, update, organize, and maintain data within Excel spreadsheets and databases.
- Prepare, format, and maintain Excel reports, dashboards, and data summaries.
- Utilize advanced Excel formulas and functions to analyze and manage data effectively.
- 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 while identifying missing values, duplicates, and inconsistencies.
- Maintain structured records to ensure data accuracy and confidentiality.
- Automate repetitive data entry and reporting tasks using VBA macros.
- Collaborate with internal teams to collect, verify, and update information as needed.

Required Qualifications
- Advanced proficiency in Microsoft Excel, including Pivot Tables, Power Query, and Data Validation.
- Expertise with conditional formatting, dynamic arrays, and complex formulas such as VLOOKUP, XLOOKUP, INDEX/MATCH, nested IF, SUMIF, COUNTIF, and IFERROR.
- Strong skills in data sorting, filtering, formatting, and overall spreadsheet management.
- Experience in creating Excel dashboards, reporting, and consolidating data from various sources.
- Accurate and efficient data entry capabilities with a keen eye for detail.
- Proficiency in data cleaning, deduplication, and handling missing or NULL values using tools like Flash Fill and Text to Columns.
- Ability to manage large volumes of data and meet strict deadlines.
- Basic knowledge of VBA for macros and task automation.
- Strong written and verbal communication skills.
- 6 months to 1 year of relevant experience in data entry, Excel reporting, or data management.
- 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 other data visualization tools is an advantage.
- Experience with data exports, reporting, and spreadsheet automation enhances candidacy.
- Competitive monthly salary ranging from Rs60,000 to Rs80,000.
- Opportunity to work in a dynamic environment focused on data accuracy and process improvement.

Candidates must be willing to work the night shift onsite in Lahore from 7:00 PM to 4:00 AM. This role requires a strong commitment to data accuracy, analytical problem-solving skills, and the ability to efficiently manage repetitive tasks while meeting deadlines.