Systems and Analytics Specialist

Brown Medicine

1d•$78,416 - $129,355•Remote

About The Position

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

Requirements

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.

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.