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 pharmacys 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: Bachelors 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 As Rhode Island's largest health system and private employer, Brown University Health is the state's premier provider of health services and includes the only Level I Trauma Center for southeastern New England. Today, more than 20,000 people work at Brown University Health and bring their unique skills, experiences, and compassion to their jobs every day. Formed in 1994, Brown University Health is a not-for-profit health system based in Providence, RI comprising three teaching hospitals of The Warren Alpert Medical School of Brown University: Rhode Island Hospital and its Hasbro Children's; The Miriam Hospital; and Bradley Hospital, the nations first psychiatric hospital for children; Newport Hospital, Saint Anne's Hospital and Morton Hospital, community hospitals offering a broad range of health services; Gateway Healthcare, the states largest provider of community behavioral health care; and Brown Health Medical Group, the largest multi-specialty practice in Rhode Island. Brown University Health is an equal opportunity employer that values diversity of cultural background, race, gender, age, religion, identity, ability, and perspectives - we are actively committed to a diverse workforce that represents the patients and community that we serve. We are invested in creating a respectful, inclusive, and equitable environment that supports the holistic well-being of our employees and their families. Join us and help build a healthier future for our patients - and for yourself. Company Location Belonging and Engagement Nursing Our Mission