Data Intelligence Business Lead

5 days ago

Ottawa, ON, Canada canadacouncil.ca Full-time $90,000 - $120,000/year

Under the direct supervision of the Manager, Intelligence and Data Strategy, the Data Intelligence Business Lead supports the development and implementation of the Council’s Client Customer Relationship Management (CRM) and Grant Management Systems (CGMS) in alignment with the roles and responsibilities related to the Council data reporting capacity.

The incumbent will be integrated into the project team working on the CGMS & other initiatives of the New Delivery Model and will collaboratively closely with the Granting Program Operations team, as well as the Office or the Chief Information Officer, Finance and RDMA teams The incumbent will also support and provide strategic advice to the RMDA Director and CGMS Business Data Owner on the development and implementation of the Data Intelligence as a corporate transformation initiative.

Key Responsibilities

  • Advise and guide business clients on technical data tables issues used for reporting from CGMS and Salesforce;
  • Participate in planning and coordination activities to support the delivery of Council data analytics projects;
  • Oversee data analysts, quality assurance staff and consultants, ensuring alignment with project objectives;
  • Develop and implement best practices in data intelligence to enhance efficiency and support the Council’s strategic goals;
  • Provide strategic advice to the RMDA Director on the development and implementation of the Data Intelligence as a corporate transformation project;
  • Collaborate with software Programmer Analysts and Database Administrators to diagnose, correct, and retest problems related to the Research database and data tables used for Council legislatives requirements and any other reports;
  • Perform hands-on analysis of existing system functions and data;
  • Analyze, synthesize, and document business requirements related to the Research data and reporting tools;
  • Leads Quality Assurance (QA) efforts, including the development and execution of database and reporting test plans;
  • Develop and implement training support processes to enhance customer satisfaction;
  • Producing and assessing support statistics and preparing detailed reports on the findings;
  • Managing cross-functional project teams in a matrix organization structure;
  • Define and develop ad hoc reports, for internal and external stakeholders, including federal government departments and agencies;
  • Perform other related duties as required.

  • University degree in data, computer science or an equivalent combination of education and professional experience related to the responsibilities of the position

  • Five (5) years of experience related to the principal responsibilities of the position including three (3) years progressive experience in research methodology, statistical and quantitative analysis, principles and methods, impact studies and electronic data processing methods, and three (3) years of experience working with grant management systems
  • Experience in extraction, validation and analysis of quantitative and qualitative data using surveys, data extraction and data visualization software
  • Experience in data results, impact and or performance indicators
  • Experience analyzing and presenting financial and statistical data using a computerized system
  • Experience coordinating and supervising others
  • Experience using ‘Agile’ methodologies such as Scrum or Kanban is an asset

  • Solid knowledge of legislation, regulations and the Council and the Government policies relevant to the data, confidentiality, and privacy
  • Ability to lead meetings and communicate ideas or positions effectively in a persuasive and authoritative manner, building support and commitment.
  • Flexibility and the ability to deal with conflicting timelines
  • Ability to communicate complex technical concepts clearly to non-technical users
  • High level of autonomy, strategic thinking, problem-solving, judgment, tact and creativity
  • Strong self-motivation balanced with a desire to achieve team goals
  • Academic, applied, or policy research experience, particularly involving quantitative or mixed-methods analysis, is an asset
  • Knowledge of or experience in the arts and culture sector, economics, public policy, social sciences, or other fields relevant to data analysis and research is an asset

  • Advanced proficiency in Microsoft Office applications, particularly Excel, Word, and PowerPoint; strong knowledge of business intelligence and data visualization platforms, including Power BI and familiarity with Tableau; and a solid understanding of data architecture, data modelling, relational databases, SQL, and data visualization principles.
  • Experience working with databases, machine lea