SQL Database Analyst

The Compliance and Enforcement (C&E) Sector of the Canadian Radio-Television and Telecommunications Commission (CRTC) requires the services of a junior Database Analyst / IM Administrator to help our officers with SQL analysis. The Compliance and Enforcement staff are designated as Inspectors under section 71(1) of the Act and under section 14 of CASL (Canada's anti-spam legislation). Part of their work requirements entail managing and analyzing data held in for the purpose of investigating and proving alleged violations. In light of this, enforcement officers are challenged with data analysis and management specific information regarding and supporting alleged violations. On a part time basis (7.5 hours per week), the database Analyst / IM Administrator will be required to provide support to an investigation team with an analysis expertise and data management held in a relational database management system, or for stream processing in a relational data stream management system in accessing many records with one single command. This investigation team to be supported is responsible for enforcing the Unsolicited Telecommunications Rules (the Rules), per section 41 of the Telecommunications Act (the Act) and Canada's anti-spam legislation (CASL).