CSIS Careers – Business Intelligence Developer

Website CSIS

Job Description:

The Canadian Security Intelligence Service (CSIS) is looking for a Business Intelligence Developer to transform our business solutions as part of our mission to keep all Canadians safe. Are you a person who likes challenges? Does the opportunity to work with the brightest Canadians to seize unique data opportunities excite you?

As part of the CSIS Business Intelligence team, we believe in the possibilities of our big data. We dive into our data to extract crucial metrics that will allow the SCRS to make data-informed decisions. You will be part of a dynamic and growing team that will meet our current and future data needs, including data integration, visualization and management. As a Business Intelligence Specialist, you will be able to help support, improve and maintain CSIS’s business intelligence program. We are currently looking to fill roles that include BI platform administration, ETL design and data modeling.

Job Responsibilities:

  • Provide professional-grade ETL data and process analysis to ensure robust error handling.
  • Build data warehouses using industry best practices and making ETL code changes to enable changes in business processes or changes in requirements.
  • Create interactive dashboards and reports to meet current and future business needs.
  • Ensure issues are identified, tracked, reported and resolved in a timely manner.
  • Installation, maintenance and configuration of business intelligence platforms.
  • Work with customer groups to understand their business processes and data requirements and effectively translate the requirements into a workable data model.
  • Maintain and modify existing templates.
  • Managing user access and licenses.
  • Perform and support daily tasks such as task scheduling, monitoring, troubleshooting and remediation.
  • Collaborate with business analysts, SMBs in the line of business, and BI team to create ETL solutions.

Job Requirements:

  • Collaboration
  • Adaptability and flexibility
  • Communication
  • Development of policies and procedures for data collection and analysis
  • Initiative
  • Innovation and creativity
  • Strong querying and data manipulation skills, including using SQL.

Qualification & Experience:

  • Experience using collaboration tools such as Jira
  • Three (3) years of recent experience using SSIS and creating/modifying database objects.
  • Experience working with Oracle, DB2 or MySQL
  • Three (3) years of recent experience designing and building BI dashboards and models using BI data analysis and visualization tools such as Cognos, PowerBI or Tableau.
  • Three (3) years of recent experience administering BI platforms such as Cognos, PowerBI or Tableau.
  • College diploma and six (6) years of relevant experience**; Where
  • Experience with C#
  • Experience researching and applying current trends, methods, standards, practices and products in an IT environment.
  • Experience with versioning tools and concepts such as Git or Motio CI
  • Undergraduate or master’s degree and three (3) years of relevant experience**; Where
  • Experience in the design and development of data warehouses or data marts.
  • Technologist diploma and four (4) years of relevant experience**; Where
  • High school diploma and seven (7) years of relevant experience**.
  • Experience developing policies, procedures or standards that relate to IT or technical concepts and communicating them to non-technical clients.
  • Equivalent professional technologist designation and four (4) years of relevant experience**; Where
  • Training or experience in machine learning and/or artificial intelligence.

Job Details:

Company: CSIS

Vacancy Type: Full Time

Job Location: Ottawa, Ontario, Canada

Application Deadline: N/A

Apply Here