• 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.

REQUIREMENTS:

(EDUCATION/EXPERIENCE/TRAINING/SKILLS)

• 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.
  • 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.