PCAS21-043 - Programmer/Analyst (2 Year Contract)
Peel Children’s Aid
Capston Drive, Mississauga, ON, CAN
5d ago

PCAS21-043 - Programmer / Analyst (2 Year Contract)

The Children's Aid Society of Peel Region, 25 Capston Drive, Mississauga, Ontario, Canada Req #677 Thursday, August 26, 2021 At Peel CAS, our mission is to protect children and strengthen families & communities through partnership.

We are currently seeking the following professional to join our team :

Reporting to the Manager, Business Information and Innovation, the Programmer / Analyst is responsible for the development and maintenance of applications for various department functions as well as developing data capture solutions (forms, databases and reports etc.

Information captured will support a variety of requirements including Ministry reporting, accountability and monitoring outcomes as well as assisting with various ad hoc requests to support key agency projects.

Duties includes applications system analysis and design, coding, user acceptance testing, implementation, production support, and documentation as well as design, development and maintenance of high quality Power BI dashboards and reports.


  • Uses strong analytical, data, database, and Microsoft SQL-Server skills to design and develop applications, databases, queries and reports that meet a variety of internal business requirements, such as data-based decision-making.
  • Develop and build solution in Power BI using advanced development techniques to deliver high quality dashboard with excellent User Experience.
  • Conceptualize business needs into insightful / interactive dashboards. Query data, perform analysis, and present findings through clear and innovative visualizations using Power BI.
  • Participate in system analysis and design, coding, user acceptance testing, implementation, production support, and documentations on applications assigned.
  • Extracts data and transforms it to fit business needs.
  • Develops, enhances, refines, and continually improves information resources and data essential for evaluation, planning and effective decision-making.
  • Regularly reviews and where necessary, revises and / or creates statistical queries and reports to ensure that information is accurate.
  • Maintains current knowledge of technology platforms and development methodologies, particularly as they relate to data analysis, transformation and reporting.
  • Advises on best practices with respect to applications, dashboards and reports development
  • Performs all levels of testing to ensure applications, dashboards and reports are error free and in accordance with report specifications and business requirements.
  • Performs ad hoc requests for data.
  • Carries out other duties as assigned.

    1. Excellent technical knowledge in developing applications, queries, dashboards and reports utilizing various software including but not limited to :

    a. Visual Studio, .NET, ASP.NET, IIS, HTML, XML and Team Foundation Server

    b. MS SQL Server (SSRS, SSIS, SSAS) 2016 and higher

    c. IBM Cognos, Power BI, Tableau

    d. MS Office (including Access)

    e. Datawarehousing (ETL)

    2. IT tech support skills with strong troubleshooting skills and knowledge of current technologies

    3. Ability to write well designed, testable, efficient code by using best software development practices and a good documentation skills

    4. A solid understanding of how applications work including security, session management, and software development life cycle

    5. Excellent data analysis, dashboard and reporting skills

    6. Strong analytical and problem solving skills, as well as being logical and efficient

    7. Excellent organizational skills, along with the ability to set priorities and schedule work accordingly, in order to successfully complete tasks and meet deadlines.

    8. Ability to interact co-operatively and professionally with peers, agency staff and members of various stakeholder groups, continuously building productive working relationships.


    Education : Degree in Computer Science, Computer Engineering or a related field

    Experience : Five years' experience in application, database, dashboard and report development with increasing scope and responsibility

    Other educational and personal qualifications together with progressive experience, which in the opinion of the Director, Strategic Data Intelligence, constitutes adequate and suitable preparation for the position.

    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form