Data Architect

Important messages

We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process. If you need to be accommodated during any phase of the evaluation process, please use the Contact information below to request specialized accommodation. All information received in relation to accommodation will be kept confidential.

Assessment accommodation

Duties

The data architect will have a crucial role in establishing and maintaining data management, integrations and data and analytics standards. The data architect will need to understand business data capabilities and ensure that IM/IT has the appropriate solutions, technologies and investments in place to support the business outcomes. The data architect will work closely with the enterprise architect as well as be integrated into project teams and act as the data lead to ensure that solutions and technologies adhere to FCAC’s and the Government of Canada architecture standards.

Work environment

FCAC is a small independent federal agency that offers a stimulating work environment. From regulating banks to educating consumers on managing their finances and researching the latest in consumer behaviour, our people are our strength. We are a knowledgeable, experienced and passionate group of approximately 180 professionals that draw on a diversity of skills and expertise to advance the agency’s mandate, and we’re looking for highly engaged and talented professionals to join our team!

Subject to the Public Service Employment Act (PSEA), we offer the same pension and benefits plans as the core public administration. In addition, you will benefit from a minimum of four (4) weeks of vacation leave per year, earn a competitive salary, and be eligible for performance pay. We have our own unique classification system (RE and REX) with relevant equivalences. We are also pleased to offer flexible work arrangements and a broad range of learning opportunities to help you grow and contribute your best. The designated workplace for this position is located in downtown Ottawa, Ontario. However, requests to telework from other parts of Canada may be considered. For information on our telework requirements and conditions, please contact us.

Intent of the process

We are seeking to staff one (1) indeterminate (permanent) position.

This selection process may be used to establish a pool of qualified candidates, which could be used to staff similar or identical positions with various linguistic profiles (BBB/BBB and CBC/CBC) and requirements, security profiles and various tenures.

Positions to be filled: 1

Information you must provide

Your résumé.

In order to be considered, your application must clearly explain how you meet the following (essential qualifications)

EDUCATION

Successful completion of an undergraduate degree in computer science, information technology, information technology, information management, mathematics, statistics, or another specialty relevant to the position to be staffed.

Degree equivalency

EXPERIENCE

Significant experience* with data architecture, data governance, and data management.

Significant experience* performing data modelling, data mapping, development, data extract, transformation and loading of transactional databases, data warehouses and data marts.

Significant experience* using Structured Query Language (SQL).

Significant experience* with Business Intelligence (BI) and Data Analytics, including data mart, reporting models (E.g., cubes, tabular models, datasets in Power BI), and visualization (i.e., reports and dashboards).

Experience analyzing and transforming data-related business requirements and change requests into technical specifications.

* Significant experience is defined as depth and breadth of experience normally associated with the performance of those duties for a period of three years or more.

If you possess any of the following, your application must also clearly explain how you meet it (other qualifications)

CERTIFICATION

Possession of more than one of the following certifications:
• DP-203, Azure Data Engineer Associate
• DP-100, Azure Data Science Associate
• DP-500, Azure Enterprise Data Analyst Associate

Experience using Microsoft SQL Server Integration Services (SSIS) or Azure Data Factory (ADF).

Experience on non-BI Microsoft cloud technologies and platforms such as Dynamics 365, Power BI, Power Apps, Power Automate, and other Azure services that are not related directly to data and analytics.

Experience working with REST API or OData in data solutions.

Experience using ERW in as a data modelling tool.

Experience leading date architecture, data management and data governance activities.

Experience providing functional leadership to a technical team in a matrix environment.

OPERATIONAL REQUIREMENTS

Ability and willingness to work overtime when required.

The following will be applied / assessed at a later date (essential for the job)

English essential

Information on language requirements

KNOWLEDGE

Advanced knowledge of Microsoft Cloud technologies relating to data engineering, data science or enterprise data analysis.

Advanced knowledge of data modelling, relational database design principles and SQL scription languages such as T-SQL.

Advanced Knowledge of Agile Software Development Lifecycle, and that applies to Data Analysis and Business Intelligence initiatives.

Note: The required knowledge will be validated by the possession of one of the three Microsoft Certifications below before the end of the written exam period (to be announced to candidates who are screened in for the written exam). FCAC will provide one Microsoft Exam Voucher to these candidates to write the exam and obtain the certification, as necessary. Candidates who already have the certification(s) are exempted from the written exam.
• DP-203, Azure Data Engineer Associate
• DP-100, Azure Data Science Associate
• DP-500, Azure Enterprise Data Analyst Associate

COMPETENCIES AND ABILITIES

Ability to communicate effectively in writing
Ability to communicate effectively orally

Demonstrating integrity and respect
Thinking things through
Working effectively with others
Showing initiative and being action oriented
Digital literacy and competency
Autonomy

The following may be applied / assessed at a later date (may be needed for the job)

Selection may be limited to members of the following Employment Equity groups: Aboriginal persons, persons with disabilities, visible minorities, women

Information on employment equity

Conditions of employment

Secret security clearance

Other information

The Public Service of Canada is committed to building a skilled and diverse workforce that reflects the Canadians we serve. We promote employment equity and encourage you to indicate if you belong to one of the designated groups when you apply.

Information on employment equity

Unless an accommodation has been granted, applications must be submitted through the jobs.gc.ca site. There are some benefits associated with applying on-line: Applicants can create a profile and retrieve stored application(s) (personal information and résumé) previously submitted and modify them, if necessary, before submitting the application.

Applicants can modify their application/résumé at any time BEFORE the closing date indicated on the job advertisement.

Candidates invited to an interview will be required to provide proof of their education credentials, in the form of a diploma or official transcript (original documents only).

Various assessment tools may be used in this selection process such as: written tests, performance assessments, interview, reference checks etc. All communication relating to this process, including email correspondence may be used in the assessment of qualifications identified on the Statement of Merit Criteria.

You must meet all essential qualifications in order to be appointed to the position.

Candidates may be required to meet some or all the asset qualifications, depending on the requirements of the specific position being staffed.

Persons are entitled to participate in the appointment process in the official language of their choice. Applicants are asked to indicate their preferred official language in their application.

Please clearly indicate this by including your substantive group and level in your CV.

Acknowledgment of receipt of applications will not be sent.

Depending on the number of applicants, volume management strategies such as random selection, top-down approach and/or establishing cutoff scores to determine who will continue in the staffing process, may be used for the purpose of managing applications. Please note that although you may attain the established pass mark on any of the assessments used in this staffing process, management may decide to use a higher cut off score.

Please add to your safe list or as needed to ensure this email will be received in your inbox versus junk/bulk/spam mail.

Preference

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.

Information on the preference to veterans

We thank all those who apply. Only those selected for further consideration will be contacted.