DATA ANALYST

---

The Office of the Chief Electoral Officer, Chief Electoral Office division, is seeking a detail-oriented individual within the Project Management Office to develop and maintain data tracking tools, processes and reports in support of the Event Readiness Program (ERP). You will:

---

About the job

• elicit, analyze, validate and communicate quality data management requirements and recommendations into documentation and conceptual design;
• perform analysis of new and existing data sources;
• identify ERP data quality problems and participate in the development and implementation of corrective action;
• identify, develop and customize standard reports and reporting formats;
• conduct trend analysis and identify patterns by comparing multiple datasets;
• create tracking tools that compile large amounts of data into smaller datasets that allows for quick extraction of relevant data into executive-level reports; and
• contribute to the design, development and delivery of new ERP data systems.

---

What you bring to the team

Knowledge

• strong understanding of relational database concepts, database management software (i.e. Microsoft SQL Server, Oracle, Microsoft Access) and database tools;
• intermediate Excel programming skills including macros, tables and visual basic programming to automate the transfer of large datasets from Excel into other MS products such as Visio, Word;
• intermediate skills in the use of Microsoft Office (i.e. Word, PowerPoint, Visio)
• familiarity with web-based survey tools (e.g. Fluid Surveys) to create online surveys, set up mailing lists and administer survey data;
• self-starter that is able to listen to requirements, translate into action and implement with little supervision;
• ability to work with rapidly changing requirements and very tight timelines;
• strong business analysis, documentation and communication skills; and
• ability to work individually and within a team environment.

Note: If you require a disability-related accommodation to participate in the recruitment process, please email us. We will accommodate your needs under the Ontario Human Rights Code.

---

Additional information:

---

Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.

Exigences en matière de langue et évaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichées en français et en anglais. Consultez la section « Langue du ou des postes » en haut de chaque offre d'emploi pour connaître les exigences linguistiques. Pour tous les postes, les candidats sont évalués en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/français), vous devrez également passer un test de compétences linguistiques en français.

All external applicants (including former employees of the Ontario Public Service) applying to a competition in a ministry or Commission public body must disclose (either in the cover letter or resume) previous employment with the Ontario Public Service. Disclosure must include positions held, dates of employment and any active restrictions as applicable from being rehired by the Ontario Public Service. Active restrictions can include time and/or ministry-specific restrictions currently in force, and may preclude a former employee from being offered a position with the Ontario Public Service for a specific time period (e.g. one year), or from being offered a position with a specific ministry (either for a pre-determined time period or indefinitely). The circumstances around an employee's exit will be considered prior to an offer of employment.

Information collection notice

We are collecting your personal information to assess how well you meet the qualifications for employment with the Ontario Public Service, and for related recruitment purposes. The collection of personal information is necessary to the proper administration of OPS Careers, which is an authorized common service in accordance with s. 6 of the Ministry of Government Services Act, R.S.O. 1990, c. M.25.

Please do not include any more personal information than is needed for your application (for example, do not include your photograph or social insurance number).

If you have any questions about how your information is collected, used, shared or saved, please contact us.