This job offer is not available in your country.

Data Assistant

Lotus InterworksTiruppur, IN

21 hours ago

Job description

Job Title : Data Assistant (Excel & Spreadsheet Expert)

Location : Remote

Shift Timings : 7pm - 4am IST

About Us :

At Simplia, we are committed to driving innovation, data-driven decision-making, and efficiency across all facets of our business. We are seeking a highly motivated and detail-oriented Data Assistant to join our dynamic team. If you are an Excel enthusiast, love working with spreadsheets, and have a keen eye for detail, we would love to hear from you!

Position Overview :

As a Data Assistant , you will play a key role in organizing, analyzing, and maintaining data through advanced Excel functions and spreadsheet tools. You will be responsible for creating and optimizing reports, managing data workflows, and ensuring data accuracy to support our data-driven strategies. Your expertise in Excel and spreadsheets will help streamline processes and contribute to the success of our data management systems.

Key Responsibilities :

Data Analysis & Reporting : Develop, maintain, and enhance reports using advanced Excel functions such as PivotTables, VLOOKUP, INDEX / MATCH, and complex formulas.
Data Management : Organize large datasets, perform data cleaning, and ensure that all data is accurate, up-to-date, and accessible for stakeholders.
Advanced Excel Functions : Leverage macros, Power Query, data validation, conditional formatting, and other Excel tools to automate processes and improve efficiency.
Data Visualization : Assist in creating visually appealing and insightful charts, graphs, and dashboards that convey data trends and insights clearly.
Spreadsheet Optimization : Ensure spreadsheets are well-organized, efficient, and scalable for future use. Create and optimize templates and workbooks.
Process Improvement : Collaborate with team members to identify areas for process improvements and implement automation solutions to save time and reduce errors.
Data Entry & Maintenance : Assist in regular updates and maintenance of key databases and ensure the consistency of data entries.
Documentation & Training : Document and share best practices for Excel-based processes and assist team members in learning new functions or troubleshooting issues.

Qualifications :

Proficiency in Excel : Must have advanced knowledge of Excel functions, including PivotTables, VLOOKUP, HLOOKUP, INDEX / MATCH, nested formulas, data validation, conditional formatting, and macros.

Experience with Spreadsheet Tools : Familiarity with spreadsheet software such as Google Sheets or similar tools, with the ability to quickly learn new features.

Data Management Skills : Strong organizational skills with the ability to handle large datasets and ensure accuracy and consistency.

Problem-Solving Abilities : Able to troubleshoot issues, offer solutions, and think critically about data management.

Attention to Detail : Highly detail-oriented and thorough in ensuring data integrity and quality.

Enthusiastic & Self-Motivated : A proactive attitude with a passion for working with data and learning new Excel techniques.

Team Player : Collaborative and willing to assist colleagues with data-related queries and challenges.

Time Management Skills : Ability to prioritize tasks and manage multiple projects simultaneously.

Preferred Qualifications :

Experience with Macros & VBA : Familiarity with creating and modifying macros to automate repetitive tasks.

Data Visualization Tools : Experience with Power BI, Tableau, or other data visualization platforms is a plus.

Basic SQL Skills : Knowledge of SQL for querying databases is a bonus.

Previous Experience in Data Roles : Previous work experience in a data-related role is a plus but not required.