Job Type: Remote [Full Time]
Time Slots: Morning: (8:00 am to 5:00 pm)
Night: (12:00 am to 9:00 am)
Requirements:
1. Proficiency in using complex formulas, functions (such as VLOOKUP, INDEX, MATCH, and array formulas), and the ability to create and modify pivot tables and pivot charts in Excel and google sheets.
2. Experience in analyzing large datasets and presenting data in a clear, concise manner using advanced charting and graphing techniques, conditional formatting, and data validation tools.
3. Experience with VBA (Excel) and Google Apps Script (Google Sheets) to automate tasks, customize functionality, and integrate with other Google services (e.g., Google Forms, Google Drive).
4. Ability to organize, clean, and efficiently manage data from various sources, ensuring accuracy and reliability in data processing and reporting.
5. Expertise in designing user-friendly and efficient Excel models, templates, and dashboards that adhere to best practices in spreadsheet development.
6. Strong analytical skills with the ability to troubleshoot and resolve complex issues within Excel spreadsheets.
7. A commitment to staying updated with the latest features, best practices, and advancements in Excel and data analysis methodologies.
8. Familiarity with integrating Google Sheets with other APIs and third-party services for enhanced data manipulation, reporting, and dashboards.