The NFB is committed to respecting your privacy

We use cookies to ensure that our site works efficiently, as well as for advertising purposes.

If you do not wish to have your information used in this way, you can modify your browser settings before continuing your visit.

Learn more

Analyst, Data Modeling and Architecture

Posted: Sep 13, 2023 Closing date of the competition: Sep 27, 2023 Location: Montreal (Balmoral) Flexibility Profile: Mostly Remote Salary Range: 10 – $81,693 to $104,457 (under review) Position Status: Continuous - Full-time Position Number: 00021322 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.


In charge of defining, designing, developing and maintaining the data warehouse holding shared data sets required for NFB reporting, KPIs and dashboards. Works with key stakeholders, subject matter experts, business intelligence (BI) analysts, ETL developers and report developers to document, gather and present required data sets; oversees data integrity and compliance to regulations when sharing data, seeks to adapt data sets to meet evolving business users’ needs. Contributes to the skills development of other staff by sharing knowledge and best practices; may participate in end-users’ training initiatives.


  • Designs, implements and maintains the information architecture of the enterprise data warehouse.
  • Identifies, analyzes and documents data required for BI dashboards and reporting needs; meets with key stakeholders and application data owners to define detailed specifications; seeks to obtain required approvals for the proposed changes.
  • Collaborates with BI analysts and departmental application data owners to make sure critical data sources are properly documented and that the data is made available for various business needs.
  • Participates in continuous improvement initiatives, together with developers, business leaders and other key stakeholders, to identify data-improvement opportunities, recommend system changes and develop related data-governance 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 change-management activities for implemented solutions; maintains and updates global data warehouse documentation, communicates changes and provides end-user 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.


  • 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 data-management 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 data-governance 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 on-premises or Cloud infrastructure;
  • Experience with NoSQL DBMS such as Elasticsearch, MongoDB, Redis;
  • Experience with data lakes, API-based data-ingestion technologies, Dataedo or similar data-cataloging tools;
  • Bilingualism in the official languages (French and English), both orally and in writing.


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

Interested candidates with the above qualifications are invited to apply in writing, including a copy of their résumé to, BY SEPTEMBER 27, 2023, citing competition number: MC-00021322.

The NFB is committed to building a skilled, diverse workforce that’s reflective of Canadian society. It promotes initiatives such as employment equity and encourages candidates to voluntarily indicate in their cover letter if they are a woman, a member of a First Nations group, Inuk, Métis, a person with a disability, or a member of a visible-minority group.

The NFB is also committed to developing inclusive, barrier-free 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.