Reporting and Analytics Analyst

The Reporting and Analytics Analyst contributes to the PSB under the guidance of the Director, Drug Utilization and Prescription Monitoring Program. This work includes, but is not limited to:

• Extract drug data to support rebate calculations;
• Perform rebate calculations as described in the negotiated agreements;
• Support the tracking and documentation of rebates submitted;
• Develop analytic and financial reports and reporting tools to ensure accountability and measure program performance;
• Analyze data to identify trends and patterns that can be used to make business decisions;
• Conduct specific ad hoc requests for analysis (e.g., annual updates to analysis/indicators) and completes exploration of data for indicator development;
• Collaborate with team members to automate standard Reporting and develop the reporting landscape;
• Gather and translate business requirements from team members for building accurate reports and dashboards that drive decision making;
• Work with a variety of data sources, identify incomplete or inaccurate data, perform root cause analysis on data issues, escalate discrepancies, fix data where possible and partners with various stakeholders to deliver solutions;
• Review the current rebate processes and provide recommendations to improve efficiency;
• Develop and maintain Standard Operational Procedures, user documentation and procedures based on contractual and operational requirements;

This will require working with team members and using various data analysis methods and tools. The Analyst may also be required to support other initiatives within the PSB.

The language of work is English. The language of service is English.

The duties of the Research and Analytics Analyst will include but are not limited to the following:

• In coordination with the Manager, develops the tools, templates and processes required to execute the research and analysis activities;
• Support data management activities to ensure quality and stewardship;
• Ensure accuracy and completeness of reported data, figures, and tables;
• Support operationalization of new processes, recommend system, and process adjustments;
• Responsible for the delivery of reporting services, leveraging both automation techniques and manual reporting;
• Understand and deliver complex, monthly, quarterly and ad-hoc report analytics requests leveraging analytics expertise;
• Ensure compliance with government policies, procedures and security standards;
• Assist in the training of new branch resources;
• Work with existing team members to ensure a knowledge transfer at end of the assignment;
• Attend and participate in team and project meetings;

· Other duties as assigned.

Job Type: Fixed term contract
Contract length: 12 months

Salary: $60.00-$65.00 per hour

Expected hours: 40 per week

Benefits:

• Dental care
• Paid time off
• Vision care

Schedule:

• 8 hour shift

Application question(s):

• What is your work authorization?
• Are you comfortable working on W2?
• What is your current location?
• Are you comfortable working Onsite?
• How many years of experience do you have as a Reporting and Analytics Analyst?
• How much experience do you have using large datasets for large enterprises or organizations?
• What is your pay rate expectations?

Experience:

• Power BI: 1 year (required)
• SQL: 1 year (required)
• Python: 1 year (required)

Ability to Relocate:

• Fredericton, NB: Relocate before starting work (required)

Work Location: In person