Job Description

JOB SUMMARY
The Business Intelligence (BI) Analyst for the Specialty Reporting Services team will turn data into information, information into insight and insight into business decisions. The team member will have the ability to develop complex and appealing visualizations using a variety of BI Tools based on tightly established client turnaround times.

DUTIES AND RESPONSIBILITIES
• Implementation of new reporting processes and procedures as required such as moving to automated reporting methods
• Interpret data and develop actionable recommendations for business leaders
• Design and prepare monthly, bimonthly or quarterly business reports including metrics/volumes and significant case summaries to clients using a variety of tools, including Excel, Power BI, SSRS, PowerPoint
• Ability to respond to customer inquiries and reporting needs efficiently as well as adapt to rapidly evolving client requirements
• Act as the subject matter expert for specific Bayshore Specialty Rx Ltd data sets and act as a liaison with internal management and clients as required
• Test and debug reporting and analysis using standard tools including but not limited to Excel, Access, CRM and other database management tools/systems
• Analyze reports for trends and variances across the programs and communicate findings
• Identify, analyze, and interpret trends or patterns in complex data sets
• Locate and define new process improvement opportunities
• Convert data to usable information to drive growth, individual contract KPI’s and increased productivity
• Knowledge of SQL queries to acquire data from primary and secondary data sources is desirable
• Formulating and communicating meaningful and actionable process plans
• Participate in ongoing internal and/or external continuing education activities
• Adhere to Bayshore Policies and Procedure
• Participate in quality activities and continuous improvement initiatives in keeping with the company’s Quality Management System
• Participates in proactive Health & Safety activities while performing all duties. Is responsible to notify immediate Supervisor of any health and safety risks or concerns. Responsible for completing Accident Reports for all direct reports who injure themselves on the job, within 24 hours of the incident.
• Maintains confidentiality of client and corporate information and discusses same only with appropriate Bayshore personnel.

QUALIFICATIONS
EDUCATION
• Bachelor’s degree in information technology, statistics or data analysis
EXPERIENCE
• Minimum 2 years of experience in analyzing and presenting results to stakeholders and clients
• Minimum 2 years of experience working with complex data sets
• Expert level Power BI, Excel, and Dashboarding Skills
• Minimum 2 years of experience with SQL and VBA is an asset
• Data mining and in-depth knowledge of Data Science techniques is an assent
• Experience working with pharmaceutical data is an asset
OTHER SKILLS AND ABILITIES
• Strong written and verbal communication skills