Statistics/Database Reporting Officer

Duties
Duties include, but are not limited to:
• Plans and develops processing, analysis and dissemination of information used to forecast resource requirements, enable decision making, identify trends, and support operational change at VAC.
• Conducts research and analysis to prepare and support all national reporting requirements for the assessment of the operational and program impacts of proposed program changes.
• Creates, develops and maintains datasets/databases for special projects (i.e. manually captured data/file reviews/internal survey data) used for national forecasting and reporting.
• Designs information management processes such as reports and multi-dimensional data applications, software or dashboards; validates and visualizes data; and conducts data cleaning and testing based on the corporate data warehouse.
• Consults with clients and interprets user requests to determine the nature, feasibility and methodology options for providing the information required.
• Participates as a member of multi-disciplinary teams and working groups.

Work environment
🏢 🏠 We have quickly adapted to the new reality and the majority of our employees are currently working based on a common hybrid work model. Employees can expect to work a combination of both remote and on site, with the frequency of each depending on the operational needs.PLEASE APPLY ONLY for locations where you have a genuine interest in working or where you would be willing to relocate.

Intent of the process
The intent of this process is to staff various positions within Veterans Affairs Canada with different tenures (indeterminate, deployment, acting, specified period, assignment).A pool of partially or fully qualified candidates may be established through this process and may be used to staff identical or similar positions at Veterans Affairs Canada, with varying tenures, language requirements, and security profiles.

Important messages
Candidates qualified in process 24-DVA-IA-CH-625196 do not need to reapply to this process.
----------------------------------------------------------------------------
If you have a completed GC Workplace Accessibility Passport, this can also be voluntarily provided to initiate the conversation about your accommodation arrangements for this assessment.
----------------------------------------------------------------------------
🌟Are you motivated to support the well-being of Veterans and their families? Are you a hard-working individual that is ready for a challenge? Are you looking for an employer that understands the importance of a healthy work-life balance and supports opportunities for growth and professional development? If so, then Veterans Affairs Canada (VAC), is looking for YOU!🌟
----------------------------------------------------------------------------
📢Ready to Apply? Here’s how to do it! 📢
1. Click on - apply online - at the bottom of the screen!
2. Give yourself the best chance to succeed! If you require any assistance, or for information on how to apply in an alternate format due to an accessibility/accommodation need, please contact the email address indicated in the "Contact information" section below prior to the Closing Date.
3. You will be prompted to answer screening questions concerning the essential education and experience qualifications and, other (non-essential) qualifications.
4. Tips for responding to screening questions:
▶ When responding please clearly demonstrate HOW, WHEN, and WHERE each qualification was met and provide examples.
▶ Choose examples with sufficient complexity, impact and degree of difficulty that will allow you to illustrate to what extent and depth you have shown the behaviors expected for each qualification.
▶ Each example should include when the example took place, background of the situation, what you did, how you did it, what your role was in the situation, and what was the outcome.
5. You will be asked to include your resume. Your resume may be used as a secondary source to validate the experience and education described in the screening questions, however you will not be solicited for incomplete or possible missing information.
6. How to Apply for Government of Canada Jobs
https://www.canada.ca/en/public-service-commission/jobs/services/gc-jobs/applying-government-canada-jobs-how-to-apply.html
7. Communication for this process will be sent via email and/or via your GC Jobs account. It is your responsibility to ensure accurate contact information is provided and updated as required.📢 What to expect after you submit your application 📢** You are entitled to participate in the process in the official language of your choice, and you will be asked to indicate your preferred official language of correspondence in your application.Step 1: Screening (Review of Applications)
▶ Effective Communication in Writing will be assessed at the screening stage.
▶ When you apply for this process, an initial screening will be done on education and experience by the answers you provide in your online application. As a result, please ensure you allow yourself a significant amount of time to complete this application.
▶ You must meet the essential education and experience qualifications to move forward to the assessment phase.Step 2: Assessment
▶ An interview and/or written exam may be administered.
▶ Reference checks may be conducted. The Assessment Committee may contact references other than those provided by the candidates (within the Public Service only) in order to adequately assess the candidates.
▶ Be prepared to provide proof of education credentials. If you were educated outside of Canada, you must have your certificates and/or diplomas assessed against Canadian education standards. For more information, please click on “Degree Equivalency” in the Education section above.
▶ Be prepared to provide proof of Canadian Citizenship or Permanent Residency.

---

Reliability Status security clearance

---

Willing and able to work overtime as required with short notice.

---

Education
ED 1 - Graduation with a degree from a recognized post-secondary institution with acceptable specialization* in economics, sociology or statistics.Candidates must always have a degree. The courses for the specialization must be acceptable and may have been taken at a recognized post-secondary institution, but not necessarily within a degree program in the required specialization. The specialization may also be obtained through an acceptable combination of education, training, and/or experience.*Specialization is defined as a degree from a recognized post-secondary institution with minimum of two courses in economics, sociology, or statistics, or a University degree and minimum one year work experience preparing, creating or managing statistical reports or creating reports from primary data using data query and retrieval tools.Proof of education and specialization (transcript) may be requested later in the recruitment process.

Experience:
EX 1 - Experience working with structured or unstructured data, for example in data extraction, validating, processing, cleaning, managing, categorizing, visualizing, or analyzing.
EX 2 - Experience in summarizing data and presenting insights in a report, dashboard, or other technical document.
EX 3 - Experience using spreadsheet software (such as Excel, Google Sheets etc.).

Abilities
AB 1 - Ability to review data and identify anomalies or errors.
AB 2 - Ability to think analytically.

Personal Suitability
PS 1 - Effective Interpersonal Relationships
PS 2 - Effective communication orally
PS 3 - Effective communication in writing*
PS 4 - Adaptability and Flexibility
PS 5 - Judgement*Effective Communication in Writing will be assessed at the screening stage.

---

Applied / assessed at a later date

Various language requirements - English Essential, Bilingual Imperative BBB/BBB, CBC/CBC

---

Asset Education
AED 1 - A degree or diploma from a recognized post-secondary institution in statistics, actuarial science, mathematics, data science, data analytics, business analytics, computer science, computer engineering, applied finance, software engineering, artificial intelligence, or machine learning.

Asset Experience:
AEX 1 - Experience as a member of the Canadian Armed Forces.
AEX 2 - Experience using Business Intelligence tools. Examples include software like Power BI, Tableau, SPSS, Stata, MATLAB, R or SAS; or programming languages like SQL, Ruby, Python, C++, R, MATLAB or JavaScript.
AEX 3 - Experience working in the VAC Reporting Database (RDB) / Enterprise Data Report Portal.
AEX 4 - Experience in preparing formal responses to ad hoc requests, such as: Parliamentary Written Questions, Access to Information and Privacy (ATIP) requests, media requests, etc.
AEX 5 - Experience reporting on VAC program delivery or performance.
AEX 6 - Experience using IBM Cognos Analytics.
AEX 7 - Experience developing model testing and validation frameworks.

Organizational Needs:
In support of achieving a diversified workforce, consideration may be given to candidates self-identifying as belonging to one of the following Employment Equity groups: Indigenous peoples, Persons with a disability, Visible Minorities, Women.

---

---

---

Preference will be given to veterans first and then to Canadian citizens and permanent residents, with the exception of a job located in Nunavut, where Nunavut Inuit will be appointed first.

Learn more about preference to veterans.

---

---

---