- 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.
Learn more about this Employer on their Career Site
