Data Analyst - Temporary Reporting Project - autoMHatic Financial

Data Analyst for Reporting Project

Position Overview: We are seeking a detail-oriented Excel Data Analyst to assist in a project aimed at consolidating data from three distinct Excel files. The goal is to identify common factors across these files and create a comprehensive report for each year.

Key Responsibilities:

1. Data Review and Preparation:

   • Analyze three provided Excel files to understand the structure and content of the data.
   • Identify relevant data points and common factors across the files.

2. Data Consolidation:

   • Utilize Excel functions (e.g., VLOOKUP, INDEX/MATCH, pivot tables) to merge data from the three files based on identified common factors.
   • Ensure data accuracy and consistency throughout the consolidation process.

3. Report Creation:

   • Create a detailed report for each year based on the consolidated data.
   • Summarize findings and highlight key insights relevant to the project objectives.

4. Quality Assurance:

   • Conduct thorough reviews of the consolidated data and reports to ensure accuracy and completeness.
   • Make necessary adjustments based on feedback and additional data checks.

5. Documentation:

   • Document the methodologies used for data analysis and consolidation for future reference.
   • Provide clear explanations of findings in the reports.

Qualifications:

• Proficiency in Microsoft Excel, including advanced functions and data analysis tools.
• Strong analytical skills with attention to detail.
• Experience in data consolidation and reporting.
• Ability to work independently and meet deadlines.

Preferred Skills:

• Familiarity with data visualization tools is a plus.
• Previous experience in a similar data analysis role.

Duration: This project is expected to last 2-4 weeks with a possibility of extension based on project needs.

If you are a proactive individual with a strong background in Excel and data analysis, we encourage you to apply for this opportunity!