Analytic Reporting Developer

Job Description

Description

PeaceHealth is seeking a Analytic Reporting Developer for a Full Time, Day position.

JOB SUMMARY

Responsible for analyzing data in enterprise wide systems that are critical to clinical care and operational processes within PeaceHealth. Provide consulting service for data analytics and visual representations of information for decision support.

ESSENTIAL FUNCTIONS

1. Lead information gathering sessions with customers across PeaceHealth and incorporate the results into project scope documents and solution designs. Conduct interviews, surveys, etc. to determine requirements for data, analysis, metadata, training, data quality, performance and reporting. Serve as a liaison between customers and other teams as needed.

2. Extract data from data warehouse and source systems to develop comprehensive measures of operational and clinical performance.

3. Develop solutions to information gaps for sound business decision making including the coordination of prototype reviews to eliminate redundancy in the collection and distribution of data. Analyze data structure and process workflows, recommend changes to improve the use of resources and accuracy of available information.

4. Act as liaison to oversight committees, counterpart groups, system level collaboratives and other management groups using appropriate methods of communication.

5. Collaborate with system level leadership, providers and other caregivers to develop standardized system wide metrics as well as coordinating the development of standardized data extracts to meet external regulatory reporting requirements of private and publicly disclosed information.

6. Analyze data and reporting solutions to understand business impact, correlations/discrepancies, and to propose changes/alternate solutions.

7. Develop SQL Stored Procedures, reporting solutions, delivery schedules using Crystal Reports, Business Objects Enterprise, SQL-Server as well as SQL Server Reporting Services, SAS, SPSS, PIMD and others as deemed necessary to meet the need.Works with enterprise applications data from Epic’s Clarity Data Model and other independent sources.

8. Develop the necessary written or interactive reports as well as analyzing the results in order to identify trends and relevant artifacts associated with the data. Prepare and issue instructions concerning generation, completion and distribution of reports according to new or revised processes, procedures or policies within operations and the analytic reporting standards.

9. Recommend the establishment of new or modified methods and procedures to improve information content, completeness and presentation to optimize actionable business decision making.

10. Prepare reports and analyze existing portfolio for trends and performance including SQL optimization and automation; and extract existing data to manipulate/calculate/format into presentable forms, including charts, and graphs tables, etc.

11. Use current knowledge of clinical processes, tools, data warehouses, operational data stores, non-warehoused databases and systems to enhance work product with state of the art data extraction, analytic tools, and statistical analytics.

12. Perform other duties as assigned.

QUALIFICATIONS

EDUCATION:

• Bachelor's degree or in informatics, computer science, programming, mathematics, finance, health care administration or business. Equivalent knowledge and skills obtained through a combination of education, training, and experience may meet this requirement.

EXPERIENCE/TRAINING:

• Minimum of 3 years experience as a hands-on analyst in a similar organization demonstrating strong analytical and problem-solving skills is required.
• Minimum of 3 years experience in a programming language such as SQL or similar toolset is required.
• Minimum of 5 years experience in healthcare analytics or Information Technology is preferred.
• Experience with EPIC’s Clarity Data Model preferred.
• Hospital healthcare experience preferred.
• Experience working with EMR preferred.

LICENSE/CERTIFICATION:

• Certified Health Data Analyst (CHDA) Certified Coding Specialist (CCS) and/or Certified Coding Specialist – Physician Based (CCSP), Project Management, EPIC Reporting, RN or other health care professional certification is preferred.

OTHER SKILLS:

• Excellent verbal and written communication skills
• Strong organizational and analytical skills
• Ability to manage multiple priorities, projects and display flexibility in a fast paced and changing work environment.
• Advanced skills in report development using Crystal Reports, SSRS or equivalent enterprise reporting tool.
• Advanced proficiency in MS Office and working knowledge of data warehousing
• Ability to understand sophisticated mathematical models and concepts.
• Demonstrated ability to interpret data and effectively present highly sophisticated analysis and findings.
• Demonstrated flexible mindset by adapting to and helping drive change.
• Advanced capabilities with SQL or similar analytical toolset.
• Ability to allocate time efficiently and handle multiple demands on competing priorities in a fast passed work environment.
• Demonstrated experience in writing stored procedures, statistical analytic tools such as SAS SPSS, PIMD or equivalent.
• Experience writing data-driven reports, working with data created reports and familiarity with ETL processes.

PHYSICAL/COGNITIVE REQUIRMENTS:

• Work requires fairly light physical exertion from up to 65% of the time.
• Ability to lift objects weighing 30 lbs. or less.
• Work is performed under normal working conditions with adequate lighting and ventilation.
• Job duties frequently require intense concentration and attention to detail (up to 65% of work time).

About PeaceHealth

PeaceHealth, based in Vancouver, Wash., is a not-for-profit Catholic health system offering care to communities in Washington, Oregon, and Alaska. PeaceHealth has approximately 16,000 caregivers, a multi-specialty medical group practice with more than 900 providers and 10 medical centers serving both urban and rural communities throughout the Northwest. In 1890, the Sisters of St. Joseph of Peace founded what has become PeaceHealth. Today, PeaceHealth is the legacy of its founding Sisters and continues with a spirit of respect, stewardship, collaboration and social justice in fulfilling its Mission. 

We offer competitive compensation, a robust benefits package and a collaborative, Mission-driven work environment! To learn more about working at PeaceHealth and the community please visit our homepage: www.careers.peacehealth.org

Get a feeling for the Spirit of PeaceHealth through this three-minute video, and visit us on Facebook or LinkedIn!

Questions? Review our Employment FAQ or email [email protected]. Please note this email does not accept resumes or applications.

See how PeaceHealth is committed to Inclusivity, Respect for Diversity and Cultural Humility.

For full consideration of your skills and abilities, please attach a current resume with your application. EEO Affirmative Action Employer/Vets/Disabled in accordance with applicable local, state, or federal laws.