Skip to Main Content

Job Title


Reporting Specialist (Afternoon Shift)


Company : Hogarth Studios India


Location : Salem, Tamil Nadu


Created : 2025-08-01


Job Type : Full Time


Job Description

Job Title:Reporting Specialist Employment Type:Full-time Shift:Afternoon Shift (12:30 PM - 9:30 PM, Monday - Friday)We are seeking a highly skilled and detail-orientedReporting Specialistto join our team. This role is critical in transforming raw data into actionable insights, supporting various departments with robust reporting, and developing intuitive dashboards. If you have a passion for data, exceptional Excel proficiency, a knack for visual storytelling through dashboards, and a foundational understanding of VBA, we encourage you to apply!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).