Systems and Analytics Specialist Pharmacy

Summary:

Reporting to the Team Lead Pharmacy Business Operations and Clinical Intelligence is intricately involved in the day to day technology integrated within all areas of pharmacy services across Brown University Health (i.e. clinical operational safety quality financial regulatory accreditation supply chain retail academia). Develops custom reports and data visualizations. Maintains a data warehouse along with associated Extract Transfer and Load (ETL) processes. Monitors and improves existing business practices through use of technology and data.

Responsibilities:

PRINCIPAL DUTIES AND RESPONSIBILITIES:

* Utilize technical analytical and programming skills to support all areas of pharmacy services (i.e. clinical operational safety quality financial regulatory accreditation supply chain retail academia).
* Maintain the pharmacy*s data warehouse.
* Design build and troubleshoot data Extract Transfer Load (ETL) processes.
* Design build and troubleshoot highly functional data visualizations utilizing Microsoft PowerBI or similar tools.
* Collaborate with pharmacy clinical and operational staff to understand health system needs and devise possible solutions.
* Keep up to date with the latest technology trends.
* Collaborate in the design on business processes to allow for appropriate and efficient data collection.
* Work jointly with stakeholders through the healthcare organization.
* Take part in and complete technological project work.
* Maintain and troubleshoot internal webpages both interactive and static
* Maintain and troubleshoot Microsoft Excel Microsoft Access and Filemaker solutions.
* Design and/or implement solutions to security vulnerabilities and concert with Brown University Health information systems security.
* Serve as an expert in the functionality and troubleshooting of pharmacy technology systems.
* Responsible for weekly rotating on call coverage.

Other information:

BASIC KNOWLEDGE:

Bachelor*s Degree in Computer Science Information Science or related field.
EXPERIENCE:

Minimum 3 years experience with SQL data analytics and programming.
Strong background in writing SQL.
Able to understand various data structures and common methods in data transformation.
Proven analytic and process redesign skills.
Highly proficient in Microsoft Office tools such as Work Excel and Access.

WORK ENVIRONMENT AND PHYSICAL REQUIREMENTS:

Work is performed in a typical office environment requiring extended periods of sitting standing and walking.
Requires the visual and manual dexterity to operate a computer.

INDEPENDENT ACTION:

Functions independently within broad scope of department policies and procedures.

Refers specific complex problems to Team Lead and when clarification of departmental policies and procedures may be required.

SUPERVISORY RESPONSIBILITIES:

None

Brown University Health is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race color religion sex national origin age ethnicity sexual orientation ancestry genetics gender identity or expression disability protected veteran or marital status. Brown University Health is a VEVRAA Federal Contractor.

Location: Rhode Island Hospital USA:RI:Providence

Work Type: Full Time

Shift: Shift 1

Union: Non-Union