University of Waterloo

  • Information Systems Specialist (Business Intelligence (BI) Developer)

    Requisition ID
    2018-3722
    Job Category
    IT
    Department
    5170 - Information Systems and Techno
    Job Status
    Temporary Appointment (Contract)
    Hiring Range
    $64,718 - $88,329
  • Overview

    Term: 1 year 

     

    The Information Systems and Technology (IST) department's Enterprise Resource Planning (ERP) Systems group is looking for a skilled individual to join the Data, Integration and Analytics team to develop Business Intelligence (BI) Solutions for the University of Waterloo. 

    Responsibilities

    Reporting to the Manager of Data, Integration and Analytics, the successful candidate will be working in a small team to gather Business Intelligence (BI) requirements from various units across the University and then design and create complete BI solutions including data curation pipelines, warehouses, reports, dashboards, and cubes based on those requirements.

     

    The primary technology used is the Microsoft BI Stack (MSSQL, Analysis Services, and Reporting Services) and the Microsoft Web
    Application Development Stack (C#, .NET Core, ASP.NET, Dapper.NET) although other tools are used in some capacity to fill functional gaps in the main tooling.

     

    The successful candidate must be able to demonstrate an ability to effectively learn new tools and a desire to continuously update and improve their knowledge of current tools. Knowledge or experience in all of the areas listed is an asset but is not required to be a successful candidate. A technical skills assessment will be administered to screened candidates to help determine their ability to self-teach new concepts.

    Qualifications

    • Strong written as well as oral communication, presentation, prioritization and time management skills.
    • Be effective and equally conversant in business and technical environments.
    • Experience with industry standard RDBMS (Oracle, MSSQL).
    • Proven ability to learn new tools and concepts quickly.
    • Recent proven experience in several of the following areas:
    • Complex MSSQL query authoring
    • Data Conversions between systems and ETL strategies
    • Dashboard and Report Design Experience (Tableau, PowerBI, or SSRS)
    • User Experience Interface Design
    • Experience with Dapper.NET
    • .Net Web Development
    • Bash Shell Scripting
    • PowerShell Scripting
    • SSAS Multi-Dimensional or Tabular Development
    • SSIS Integration Development
    • Technical background in one or more of the following areas preferred: (application development, database administration, server administration)
    • Experience in data warehouse and business intelligence environments and tools such as SSRS, SSAS Development, Extract-Transform and-Load (ETL) and SQL Server
    • Experience with dimensional data models, data integration (SSIS), data quality (DQS) and general Data Warehouse ETL best practices
    • Knowledge of statistical procedures and applied data validation mechanisms
    • Thorough knowledge of BI/DW concepts, best practices, methodologies and iterative development methodology

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed