Technical Specialist

Toronto, ON M5V 3J1 | Contract

Job ID: 56653 Industry: Other Area(s)

Technical Specialist

Location: Toronto

Positions: 2

Type: 20-Month Contract

Our client, a major organization within the public sector, has asked Bagg Technology Resources to assist them in finding 2 Technical Specialists to join their esteemed organization on a long-term contract in Toronto. Provide technical expertise to maximize the value of the clients information assets. This will include the creation of reporting and analytic solutions, gathering and eliciting requirements from business, documenting business and functional requirements for reporting and other analytical solutions, performing business and technical analysis related to information management (IM) architecture, data mapping and lineage. Other work includes extracting, transforming and consolidating data using multi-platform programs, applications and Business Intelligence tools This work is critical for the client to advance our IM strategy, and deliver efficient and effective reporting and analytical solutions to the business.

Why Join?

This is an excellent opportunity to work for a large government organization that can help maximize your potential and develop your career while helping the people of Ontario.

Key Responsibilities:


  • Coordinate and facilitate in-depth workshops with the clients IT department and business areas to elicit review, confirm and document functional specifications, business process re-engineering, information management architecture, data mapping, business models, and transformation rules and user interface design
  • Conduct impact analyses and assessments including AS-IS and TO-BE analysis and provide recommendations of options/solutions based on analysis
  • Deliver new reporting and analytic products based on requirements provided using a wide range of BI tools such as Cognos, Tableau and SAS
  • Facilitate and document the ETL process, including translating system design into program design specifications and its documentation
  • Responsible for the creation of data validation processes to ensure reliability and integrity of data solutions provided to the business

Business Transformation

  • Coordinate and facilitate in-depth workshops with the clients business areas to elicit review, confirm and document business requirements for reporting solutions
  • Create mapping and data lineage documentation from Source to Landing
  • Remediate existing analytical products to meet business needs
  • Prepare briefing materials and provide status updates to management
  • Identify opportunities and solutions to automate and streamline reporting and analytical solutions delivered to the business
  • Applications Specialist activities
  • Perform work on application enhancements or modifications
  • Create information solutions required by the clients business areas in various applications and platforms
  • Ensure and implement solutions to extract and consolidation data across different applications and platforms
  • Data Warehousing and BI
  • Investigate, analyze and resolve data model and ETL code issues
  • Research and analyze potential data acquisition processes for the clients data repositories



  • 5+ years’ of professional experience in Information Technology or Information Management
  • 5+ years’ experience with Business Intelligence methodologies, and Technologies like Relational databases (e.g. Oracle, MySql, DB2) , OLAP , Visualization Business Intelligence Tools (e.g. Tableau, Qlikview), Enterprise Business Intelligence Tools (e.g. Cognos, SAS) and ETL (e.g. SQL, Information, Datastage)
  • 5+ years’ experience with different Programming languages e.g. Java, SQL, VBA
  • 5+ years’ experience in designing, customizing and developing operational and analytic reporting solutions
  • Communication and relationship skills
  • Experience being a senior member of a design, development project team building Business Intelligence and reporting solutions


To apply, please click Apply Online or submit your resume by email to:

View all of our job postings at

Accommodations are available upon request to support your participation during all stages of the recruitment process.

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: