Reporting Analyst

Position Summary
Amada Senior Care – East Bay is seeking a detail-oriented, analytical, and technically proficient Reporting Analyst to support operational reporting, performance monitoring, data management, dashboard development, and selected business process automation projects.

The role will focus on ensuring that company leadership has access to accurate, timely, and actionable information to evaluate business performance, identify operational gaps, monitor Key Performance Indicators (KPIs), and support data-driven decision-making.

In addition to regular reporting responsibilities, the Reporting Analyst may support specialized technical projects, including workflow automation and the development of an automated lead-response and call-routing system.

The position will initially operate under a flexible, hourly, project-based arrangement, with the potential to transition into a full-time role depending on business needs, workload, and individual performance.

2. Key Responsibilities

A. Data Collection and Reporting

• Collect, consolidate, organize, and maintain operational data from various departments and reporting platforms.
• Prepare and update daily, weekly, biweekly, monthly, and ad hoc operational reports as assigned.
• Ensure that reports are accurate, complete, consistent, and submitted within established deadlines.
• Maintain organized reporting databases, spreadsheets, historical records, and supporting documentation.
• Identify discrepancies, missing information, and inconsistencies across data sources.
• Coordinate with relevant departments to validate reporting information and resolve data issues.
• Ensure that reports are presented in a clear and understandable format for management review.

B. Dashboard Development and Management

• Develop, maintain, and improve operational dashboards, KPI trackers, and reporting templates.
• Create and manage spreadsheet formulas, calculations, charts, PivotTables, and visual summaries.
• Ensure that dashboard formulas, filters, reporting periods, and data references are accurate and functioning properly.
• Troubleshoot spreadsheet errors, formula inconsistencies, and reporting discrepancies.
• Maintain standardized KPI definitions and calculation methodologies.
• Identify opportunities to automate repetitive reporting processes and reduce manual work.
• Continuously improve dashboard functionality, usability, and reporting efficiency.

C. Cross-Departmental Reporting Support

• Collaborate with company departments to support reporting requirements.

3. Specialized Projects: Workflow Automation and Lead Response System

In addition to reporting responsibilities, the Reporting Analyst may be assigned specialized automation projects designed to improve business processes, communication efficiency, and operational responsiveness.

A. Automated Lead Response and Call Routing
The Reporting Analyst will support the evaluation, development, testing, and potential implementation of an automated lead-response system using a comparable communication automation platform.

4. Qualifications and Technical Skills

Education and Experience

• Bachelor's degree in Business Administration, Information Systems, Statistics, Accounting, Finance, Computer Science, or a related field preferred.
• Previous experience in reporting, data analysis, dashboard development, or operational analytics preferred.
• Experience supporting multiple departments or business functions is an advantage.

Core Competencies

• Strong analytical and critical-thinking abilities
• High attention to detail and accuracy
• Excellent organizational and time-management skills
• Ability to work independently with minimal supervision
• Proactive communication and problem-solving
• Ability to manage multiple projects and deadlines
• Strong written and verbal communication
• Professionalism, integrity, and confidentiality