Reports developer - 20173 - onsite

internal and external stakeholders to set strategic direction and policies for publicly funded drug plans and initiatives,
and managing the Prescription Monitoring Program (PMP).
New Brunswick is a member of the pan-Canadian Pharmaceutical Alliance (pCPA) www.pcpacanada.ca. The pCPA is
an independent organization whose membership includes the provincial, territorial and federal governments.
Member jurisdictions collaborate on a range of public drug plan initiatives to increase and manage access to clinically
effective and affordable drug treatments.
pCPA conducts joint negotiations for brand name and generic drugs in Canada to achieve greater value for publicly
funded drug programs. For successfully negotiated agreements, rebate calculations must be performed and invoices
issued to drug manufacturers.
The Pharmaceutical Services Branch is seeking to contract a Reporting and Analytics Analyst to support the rebate
process and the Branch’s data and reporting requirements using the drug claims database.


SERVICES SOUGHT
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 individual will be required to sign a non-disclosure agreement and complete DH’s Privacy Training prior to
commencing the assignment.




DELIVERABLES
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.

Advantages

BACKGROUND
The Pharmaceutical Services Branch (PSB) is responsible for the development and delivery of pharmaceutical policies,
programs and services for the New Brunswick Department of Health (DH). The branch works closely with multiple
internal and external stakeholders to set strategic direction and policies for publicly funded drug plans and initiatives,
and managing the Prescription Monitoring Program (PMP).
New Brunswick is a member of the pan-Canadian Pharmaceutical Alliance (pCPA) www.pcpacanada.ca. The pCPA is
an independent organization whose membership includes the provincial, territorial and federal governments.
Member jurisdictions collaborate on a range of public drug plan initiatives to increase and manage access to clinically
effective and affordable drug treatments.
pCPA conducts joint negotiations for brand name and generic drugs in Canada to achieve greater value for publicly
funded drug programs. For successfully negotiated agreements, rebate calculations must be performed and invoices
issued to drug manufacturers.
The Pharmaceutical Services Branch is seeking to contract a Reporting and Analytics Analyst to support the rebate
process and the Branch’s data and reporting requirements using the drug claims database.


SERVICES SOUGHT
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 individual will be required to sign a non-disclosure agreement and complete DH’s Privacy Training prior to
commencing the assignment.




DELIVERABLES
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.

Responsibilities

BACKGROUND
The Pharmaceutical Services Branch (PSB) is responsible for the development and delivery of pharmaceutical policies,
programs and services for the New Brunswick Department of Health (DH). The branch works closely with multiple
internal and external stakeholders to set strategic direction and policies for publicly funded drug plans and initiatives,
and managing the Prescription Monitoring Program (PMP).
New Brunswick is a member of the pan-Canadian Pharmaceutical Alliance (pCPA) www.pcpacanada.ca. The pCPA is
an independent organization whose membership includes the provincial, territorial and federal governments.
Member jurisdictions collaborate on a range of public drug plan initiatives to increase and manage access to clinically
effective and affordable drug treatments.
pCPA conducts joint negotiations for brand name and generic drugs in Canada to achieve greater value for publicly
funded drug programs. For successfully negotiated agreements, rebate calculations must be performed and invoices
issued to drug manufacturers.
The Pharmaceutical Services Branch is seeking to contract a Reporting and Analytics Analyst to support the rebate
process and the Branch’s data and reporting requirements using the drug claims database.


SERVICES SOUGHT
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 individual will be required to sign a non-disclosure agreement and complete DH’s Privacy Training prior to
commencing the assignment.




DELIVERABLES
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.

Qualifications

BACKGROUND
The Pharmaceutical Services Branch (PSB) is responsible for the development and delivery of pharmaceutical policies,
programs and services for the New Brunswick Department of Health (DH). The branch works closely with multiple
internal and external stakeholders to set strategic direction and policies for publicly funded drug plans and initiatives,
and managing the Prescription Monitoring Program (PMP).
New Brunswick is a member of the pan-Canadian Pharmaceutical Alliance (pCPA) www.pcpacanada.ca. The pCPA is
an independent organization whose membership includes the provincial, territorial and federal governments.
Member jurisdictions collaborate on a range of public drug plan initiatives to increase and manage access to clinically
effective and affordable drug treatments.
pCPA conducts joint negotiations for brand name and generic drugs in Canada to achieve greater value for publicly
funded drug programs. For successfully negotiated agreements, rebate calculations must be performed and invoices
issued to drug manufacturers.
The Pharmaceutical Services Branch is seeking to contract a Reporting and Analytics Analyst to support the rebate
process and the Branch’s data and reporting requirements using the drug claims database.


SERVICES SOUGHT
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 individual will be required to sign a non-disclosure agreement and complete DH’s Privacy Training prior to
commencing the assignment.




DELIVERABLES
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.

Summary

BACKGROUND
The Pharmaceutical Services Branch (PSB) is responsible for the development and delivery of pharmaceutical policies,
programs and services for the New Brunswick Department of Health (DH). The branch works closely with multiple
internal and external stakeholders to set strategic direction and policies for publicly funded drug plans and initiatives,
and managing the Prescription Monitoring Program (PMP).
New Brunswick is a member of the pan-Canadian Pharmaceutical Alliance (pCPA) www.pcpacanada.ca. The pCPA is
an independent organization whose membership includes the provincial, territorial and federal governments.
Member jurisdictions collaborate on a range of public drug plan initiatives to increase and manage access to clinically
effective and affordable drug treatments.
pCPA conducts joint negotiations for brand name and generic drugs in Canada to achieve greater value for publicly
funded drug programs. For successfully negotiated agreements, rebate calculations must be performed and invoices
issued to drug manufacturers.
The Pharmaceutical Services Branch is seeking to contract a Reporting and Analytics Analyst to support the rebate
process and the Branch’s data and reporting requirements using the drug claims database.


SERVICES SOUGHT
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 individual will be required to sign a non-disclosure agreement and complete DH’s Privacy Training prior to
commencing the assignment.




DELIVERABLES
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.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.