Reporting Specialist (Afternoon Shift)

Job Title:

Employment Type:

Shift:

Reporting Specialist

Key Responsibilities:

• Develop, maintain, and optimize complex Excel models, spreadsheets, and reports to support business operations and strategic initiatives.
• Design, build, and maintain interactive dashboards using Excel or other BI tools (e.g., Power BI, Tableau if applicable) to visualize key performance indicators (KPIs) and trends.
• Automate routine reporting tasks and data processes using advanced Excel functions, formulas, and basic VBA scripting.
• Perform data extraction, transformation, and loading (ETL) activities to ensure data accuracy and consistency.
• Analyze large datasets to identify patterns, anomalies, and opportunities for improvement.
• Collaborate with various stakeholders to understand reporting requirements and deliver tailored solutions.
• Ensure data integrity and confidentiality across all reporting activities.
• Provide ad-hoc data analysis and reporting as needed.
• Work effectively within an afternoon shift schedule (12:30 PM - 9:30 PM) to support global or specific time zone operations.

What We're Looking For:

• Exceptional Proficiency in Microsoft Excel:

  Advanced knowledge of pivot tables, VLOOKUP/HLOOKUP, INDEX/MATCH, conditional formatting, data validation, array formulas, and complex nested functions.

• Strong Dashboarding Skills:

  Proven ability to design and create clear, insightful, and user-friendly dashboards that tell a story with data. Experience with Excel-based dashboards is essential; familiarity with other BI tools is a plus.

• Foundational VBA Programming Knowledge:

  Ability to read, understand, modify, and write basic VBA macros to automate tasks and enhance Excel functionality.

• Analytical Mindset:

  Strong problem-solving skills with the ability to interpret data and present findings clearly.

• Attention to Detail:

  Meticulous in data handling and report generation to ensure accuracy.

• Communication Skills:

  Excellent verbal and written communication skills to collaborate with team members and present findings.

• Adaptability:

  Comfortable working in a dynamic environment and managing multiple priorities.

• Availability:

  Must be comfortable and available to work the afternoon shift (12:30 PM - 9:30 PM, Monday - Friday).