Analyst, Data Modeling and Architecture - Montréal, Canada - National Film Board of Canada

National Film Board of Canada

Verified Company

Montréal, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Posted:
May 17, 2024 Closing date of the competition: May 31, 2024

Location:
Montreal (Balmoral)
Flexibility Profile: Mostly Remote
Salary Range: 10 - $81,693 to $104,457 (under review)
Position Status: Continuous - Full-time
Position Number:
Division: Technologies
Department: Information Technology & Infrastructure
Union Category: PIPSC

Are you passionate about great storytelling, about exploring the issues that matter, about pushing the boundaries in new audiovisual experiences? So are we.

As Canada's public producer and distributor, the National Film Board has been telling the country's stories and pioneering breakthroughs in virtually every field of audiovisual content since 1939.

But to do this, we need a team that truly reflects the richness and diversity of Canada.

If you'd like to be a part of this team—and part of the NFB's incredible legacy—we'd love to hear from you.

SUMMARY OF DUTIES:

MAJOR RESPONSIBILITIES:

Designs, implements and maintains the information architecture of the enterprise data warehouse.
Participates in continuous improvement initiatives, together with developers, business leaders and other key stakeholders, to identify dataimprovement opportunities, recommend system changes and develop related datagovernance standards.
Applies data modelling and dimensioning techniques to ensure development and implementation support efforts meet integration and performance expectations.
Proposes solutions for simplification or optimization of data structures within the data warehouse environment.
Establishes naming conventions and data standards to ensure consistency across reference data sets.
Defines and implements data quality checks and validation rules in collaboration with data owners, to ensure that master data is accurate and consistent.
Elaborates and implements a transactional data retention and archiving policy in collaboration with key stakeholders and their leadership, to ensure that data is retained for the appropriate length of time and can be easily accessed if needed.
Supports changemanagement activities for implemented solutions; maintains and updates global data warehouse documentation, communicates changes and provides enduser support and training related to these.
Keeps own skills up to date, performs technology watch and stays abreast of recent developments in the industry on a technical level, and actively participates in discussions about adopting them within the NFB.

REQUIRED QUALIFICATIONS:

Bachelor's degree in Computer Science, Information Technologies or equivalent;
Minimum of eight (8) years' experience in role with data architecture, business intelligence solutions or database administration responsibilities;
Certification in a recognized analytics and datamanagement field is an asset;
Experience working as part of multidisciplinary teams and leading data process improvement initiatives, making recommendations to management related to system changes and datagovernance standards;
Understands distinctions between reference data, master data and transactional data and specific ways to manage them;
Ample experience in normalization and dimensional modelling;
Experience in managing historical data and slowly changing dimensions;
Experience using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) or similar technologies;
Serious experience with SQL RDBMS such as SQL Server, MySQL, Oracle within onpremises or Cloud infrastructure;
Experience with NoSQL DBMS such as Elasticsearch, MongoDB, Redis;
Experience with data lakes, APIbased dataingestion technologies, Dataedo or similar datacataloging tools;
Bilingualism in the official languages (French and English), both orally and in writing.

PERSONAL QUALITIES:

Strong propensity for collaboration;
Active listening, ability to understand needs and support people;
Initiative, autonomy, adaptability, good judgment and a sense of responsibility;
Ability to build good interpersonal relationships, be effective in professional interactions and advise others;
Excellent ability to manage multiple projects simultaneously, in accordance with changing priorities and evolving timelines, using an organized approach to work;
Ability to analyze technical concepts and convey complex or technical ideas while adapting to the audience (e.g., presentations);
Focussed on results and seeking solutions.
The NFB is also committed to developing inclusive, barrierfree selection processes and work environments. Feel free to advise us of any accommodation needs._
Please note that only applicants selected for an interview will be contacted._