We are looking for a Database Modeller/Information Management Modeller – Level 3 for Library and Archives Canada with a Security Clearance Level of Reliability.

1.The resource must meet the minimum requirements associated with the resource category, and level, as stipulated in the TBIPS SA.

The resource must hold a valid security clearance at the level of: Reliability Status.

2.Additional technical qualifications may be stipulated on a TA by TA basis and could include, but is not limited to:

• Experience in the delivery of an integrated Dashboard for an organization with drill down views based on Organization, Division and Team.
• Experience in gathering and analyzing BI requirements from clients.
• Experience in relational and dimensional data modelling
• Experience leading to the execution of dashboards, reports, BI and/or Database schema and structures
• Experience designing and developing reports using Power BI Experience with T-SQL Programming
• Experience DAX (Data Analysis Expressions) programming
• Experience in designing and scheduling packages for transferring data from Multiple data sources and Loading in data warehouse (ETL)