Colorado Hospital Association (CHA) is the leading voice of Colorado’s hospital and health system community. Representing more than 100 hospitals and health systems throughout the state, CHA serves as a trusted, credible and reliable resource on health issues, hospital data and trends for its members, media, policymakers and the general public. Through CHA, Colorado’s hospitals and health systems work together in their shared commitment to improve health and health care in Colorado. For more information on CHA, visit www.cha.com.

Essential Job Duties and Responsibilities:

The Program Manager of Data Analytics will manage the data architecture, development and administration of the data platform. This position reports to the Director of Analytics.

The program manager will have access to cutting-edge data tools and software packages that enable use of massive datasets rapidly. The program manager is expected to:

• Develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions
• Create rapid analytics using Alteryx, Tableau, Power BI, Excel, and/or SQL.
• Support all CHA departments (Policy, Finance, Patient Safety, Communications, Rural) with data requests, analyses, visualizations and reports.
• Work with the Data Quality Program Manager and others to collect and review Discharge and other datasets.
• Administer internal databases, and create new tables and views as necessary for analytical work.
• Maintain and improve weekly, monthly, quarterly and annual data processing and reporting processes, including regular digital reports and datasets for purchasers.
• Provide ad-hoc datasets and analyses for members and external parties.
• Help manage and maintain the Data Center digital platform, ODHIN, through database management, visualization development and member training/support.
• Support the productivity and development of other team members by helping problem solve, sharing analytic skills and providing training as needed.
• Stay up to date on the needs of data team, government, hospital members, or vendors and how they translate to new application features.
• Develop software solutions to meet needs of application users.
• Create, test and implement programing codes and documents of new applications.
• Evaluate existing applications and perform updates and modifications.
• Follow and ensure all security, HIPAA and internal policies for appropriate use and protection of PHI and sensitive data.
• Review Power BI access requests (using Row Level Security settings) and create user accounts on Azure Active Directory assigning proper level of access based on requestor’s role and HIPAA guidance.
• Optimize background data process and manage dataset refresh schedules for faster data loading and better user experience.
• Perform and generate access and usage reports to ensure everything in the database system works correctly as designed for auditing.
• Participate in meetings with members and other stakeholders to understand needs.
• Complete other duties as assigned by supervisor.

Supervisory:

• None

Knowledge, Skills and Experience required (unless otherwise noted):

• At least an MA/MS in health-related sciences or analytics such as, Public Health, Epidemiology, Biomedical, Data Analytics, Business Intelligence, Behavioral Economics
• Demonstrated proficiency in analytics software, such as SPSS, R, SQL, Alteryx, Python, XML/HTML or SAS
• Ability to build and maintain reports in business intelligence tools such as Tableau or Power BI
• 3-5 years of data analytics or related experience required, work with healthcare related data is preferred
• Experience in a healthcare setting strongly preferred
• Analytical and statistical training or experience
• A broad familiarity with healthcare issues and an interest in healthcare policy and analysis
• Strong critical thinking and stellar communication skills (both written and verbal)
• Experience with database management and developing applications

This position presents a unique opportunity for a self-starting, adaptable and intelligent individual to further develop a valuable skill-set and innovate in a rewarding work environment.

Qualifications and Competencies:

• Strong attention to detail and accuracy
• Ability to work in collaboration with other teams
• Demonstrated customer service orientation
• Demonstrated organizational skills and personable positive attitude
• Strong written, verbal, and interpersonal communication skills
• Ability to work well under pressure and within short deadlines
• Analytical problem-solving ability
• Ability to handle confidential or proprietary information and situations discreetly and professionally
• Ability to work independently with limited supervision and to complete tasks on time
• Professional telephone and email etiquette, professional appearance and demeanor, able to interact with all levels within the organization
• Self-starter with a strong desire to learn
• Maintains prompt and regular attendance

Physical Demands / Work Environment:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Working conditions are normal for a fast-paced office work environment.
• Presentation of technical material in group settings required occasionally.
• Individuals may need to sit or stand as needed.
• Occasional weekend or evening work may be needed.
• May include lifting up to 25 pounds for files on a regular basis. Proper lifting techniques required.

Material and Equipment Directly Used:

• Personal computer with Microsoft Office 365 software applications.
• Software applications including Tableau, Power BI, Alteryx, SQL
• Facsimile
• Multi-line telephone with voice mail
• Copy machine
• Printer

Hiring salary range: $80,000 – $90,000 annually, benefits eligible

The hiring salary range represents a targeted hiring range based on candidate’s experience, education, and/or skill level. The actual starting salary may be more or less depending on qualifications and does not represent the full salary range.

NOTE:  This job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job.  The employee will be required to follow any other instructions and to perform any other duties requested by their supervisor.  Nothing in this job description shall create or is intended to create, or shall be construed to constitute a contract of employment, express or implied. Employees are held accountable for all duties of this job.