What are the responsibilities and job description for the Report Writer position at Consociate Health?
Job Description
Job Description
Consociate Health, a leading Third-Party Administrator, offers an opportunity to grow and develop your career in an environment that provides a fulfilling workplace for employees, and creates continuous learning and embraces the ideas and diversity of others.
As part of our Mission to make Healthcare more accessible and affordable for our clients through innovation solutions and expert consultation, we value the inherent qualities that are foremost in our Mission, Vision, Values- Compassion, Humility and Impact, which allow us all to create authentic relationships with our team and our clients.
Position Summary :
We are seeking a detail-oriented Report Writer with advanced expertise in Microsoft Excel, Microsoft Access and PowerPoint. The ideal candidate will have strong technical skills in data analysis, reporting, and presentation creation, and will be responsible for compiling, analyzing, data in clear, actionable reports to inform decision-making across various departments.
Principal Duties & Responsibilities :
- Data Collection :
- Gather and analyze data from multiple sources, including internal databases, Microsoft Access, and Excel spreadsheets.
- Develop complex Excel formulas, pivot tables, and macros to process large datasets.
- Create reports and dashboards for real-time insights and data visualization.
- Build and maintain databases in Microsoft Access for report generation and data management.
- Report Creation & Presentation :
- Compile and structure detailed reports that summarize findings, trends, and insights.
- Create and automate recurring and ad-hoc reports based on specific business needs and requests.
- Present findings and trends through professional, high-quality PowerPoint presentations to management and other stakeholders.
- Ensure reports and presentations are visually compelling and easy to understand for non-technical audiences.
- Process Improvement :
- Identify and implement process improvements for reporting, ensuring accuracy, timeliness, and efficiency.
- Automate routine tasks and reporting functions using advanced Excel techniques (VBA, Macros).
- Work collaboratively with different departments to refine and enhance reporting processes to align with business objectives.
General Expectations :
Service Expectations :
Expertise in complex formulas (e.g., VLOOKUP, INDEX / MATCH, nested IF statements), pivot tables, macros, and data visualization techniques.
Strong working knowledge of database management, query design, and data manipulation within Microsoft Access.
Ability to create professional presentations that effectively communicate data insights, trends, and business recommendations.
Excellent attention to detail.
Physical and Mental Abilities :
Working Conditions :
Benefits : Benefits :