Systems and Analytics Specialist

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.
Brown University Health employees are expected to successfully role model the organization's values of Compassion, Accountability, Respect, and Excellence as these values guide our everyday actions with patients, customers and one another.

In addition to our values, all employees are expected to demonstrate the core Success Factors which tell us how we work together and how we get things done. The core Success Factors include:

Instill Trust and Value Differences
Patient and Community Focus and Collaborate

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.

MINIMUM QUALIFICATIONS:

• Bachelor’s Degree in Computer Science, Information Science, or related field.
• 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

Pay Range:

$78,416.00-$129,355.20

EEO Statement:

Brown University Health is committed to providing equal employment opportunities and maintaining a work environment free from all forms of unlawful discrimination and harassment.

Location:

Rhode Island Hospital - 593 Eddy Street Providence, Rhode Island 02903

Work Type:

M-F 8:00am-5:00pm

Work Shift:

Day

Daily Hours: 

8 hours

Driving Required:

No