Sr. Analyst Clinical Report Writer

PURPOSE OF POSITION:

The Senior Analyst position is responsible for creating advanced reporting content by using industry standard analytics tools (see Requirements section.) for both clinical and financial operational divisions of Cape Cod Healthcare.

PRIMARY DUTIES AND RESPONSIBILITIES:

• Actively practices customer service by displaying flexibility, team spirit, open communication, effective listening, respect, honesty, courtesy, and accountability when dealing with all external and internal customers.
• Maintains confidentiality, integrity and ethics in work performance and relationships.
• Displays a team approach by communicating with others, integrating and accepting ideas and accepting and offering help to others.
• Using skills outlined in Requirements section:
• Write interpretive clinical reports relevant to the patients’ care and/or clinical operations.
• Work with the clinical IT group to design and modify queries and/or reports to the support the Clinical IT team as well as supporting clinical departments, both for ad-hoc and automated/scheduled reporting.
• Utilize the database software and structure of the key clinical application, which may be but not limited to Sybase, SQL, MS Access, etc.
• Analyze which report writer software is compatible with each application, so that the completed reports can be imbedded to the users’ front-end application for on-demand reports.
• Ensure an efficient and reliable environment through SQL standard, as well as custom monitoring processes; thus being proactive in identifying potential problems with automated processes and solutions.
• Expand or modify business intelligence and analytics system to serve new purposes or improve work flow.
• Provide Help Desk Services with documentation on any trouble shooting issues (access, accuracy, efficiency and functionality) that end users may encounter with running reports, to minimize calls to the on-call support staff.
• Retain documentation on all report requests, specifications, version history, and supply duplicate reports in both production and test where possible.
• Use the computer in the analysis and solution of Healthcare Organization’s business problems, such as development of integrated production and inventory control and cost analysis systems.
• Collaborate with clinical team, Clinical managers and Senior Clinical Managers to prioritize reporting requests according to the data governance principles of CCHC.
• Install new versions of report writing software as needed to insure effective support and operations of the application/database environment.
• Performs other analytics related work duties as assigned.
• Test, maintain, and monitor computer programs and systems, including coordinating the installation of computer programs and systems.
• Assess the usefulness of pre-developed application packages and adapt them to a user environment.
• Consult with management to ensure agreement on system principles like service excellence to all patients, family members, visitors, volunteers and co-workers in a manner that reflects Cape Cod Healthcare’s commitment to CARES: compassion, accountability, respect, excellence and service.
• Confer with clients on the nature of their current information processing or computation needs as they relate to the requested report/program.
• Challenges current working practices to; identify process improvement opportunities and presents recommendations and solutions to management.

EDUCATION/EXPERIENCE/TRAINING :

• 3+ years of experience in working with MSSQL Server
• 3+ years developing SQL Queries using Microsoft SQL Server 2016 and above.
• 3+ years of experience designing, writing, maintaining Epic Analytics reports, dashboards and metrics.
• 3+ years of experience designing, writing, maintaining Microsoft SQL Server stored procedures.
• Current Epic Cogito Analytics certifications Required : Caboodle Data Model, One or more subject matter Clarity Data Model, Cogito
• SlicerDicer (Preferred)
• Ability to use complex expressions to calculate, group, filter, parameterize, optimize and format custom reports
• Work effectively with all members of a clinical & technical project teams
• Demonstrated project estimation experience
• Strong verbal, written and interpersonal communication skills
• Excellent organizational and project management skills, including ability to organize time and work on multiple tasks and follow through to completion of task or project.
• Excellent analytical and problem-solving skills, including high degree of attention to detail and accurate processes.
• Self-motivated to be able to work independently and with a team.
• Bachelor's degree (B.S. or B.A.) from an accredited four-year college or university, or equivalent combination of education and experience.

Schedule Details:

Full Time, Monday-Friday, Core Hours 8a-4:30pm EST, Occasional Weekends and Holidays

Pay Range Details:

The pay range displayed on each job posting reflects the anticipated range for new hires. A successful candidate’s actual compensation will be determined after taking factors into consideration such as the candidate’s work history, experience, skill set, and education. This is not inclusive of the value of Cape Cod Healthcare’s benefits package (if applicable), which includes among other benefits, healthcare/dental/vision and retirement. For annual salaries this is based on full-time employment.