Technical Specialist-11 Month Contract

Toronto, ON M5V 3J1

Employment Type: Contract Industry: Other Area(s) Job Number: 62073

Technical Specialist-11 Month Contract

Location: Toronto


Our client, a leader in the insurance industry, has asked Bagg Technology Resources to assist them in finding a Technical Specialist to provide technical expertise to maximize the value of organizational information assets. This will include assisting in 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.

 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

Information Management

  • Coordinate and facilitate in-depth workshops with the Client’s 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
  • Assist in the design and development and delivering new reporting and analytic products based on requirements provided using a wide range of BI tools such as Cognos, Power BI, SAS
  • Conduct impact analyses and assessments including AS-IS and TO-BE analysis and provide recommendations of options/solutions based on analysis
  • Assist in the delivering of new reporting and analytic products based on requirements provided using a wide range of BI tools such as Cognos, Tableau and SAS
  • Assist in the facilitation and document the ETL process, including translating system design into program design specifications and other technical artifacts
  • Assist in the creation and execution of data validation processes to ensure reliability and integrity of data solutions provided to the business
  • Provide support to the project Quality Assurance framework and processes (e.g. requirements traceability matrix)

Business Transformation

  • Coordinate and facilitate in-depth workshops with the Client business areas and IT to elicit review, confirm and document business and technical requirements for reporting solutions
  • Construct data mapping and data lineage documentation from Source to Landing
  • Participate in Functional system workshops and Business Process Workshops to assist in the identification of data, reporting and analytical requirements and gaps
  • Remediate existing analytical products to meet business needs
  • Construct 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
  • Participate in technical design workshops, support options analysis and selection of appropriate technical solutions
  • Construct information solutions required by the business areas in various applications and platforms
  • Ensure and assist in the implement of 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 data repositories
  • Assist in the planning and coordinate testing activities including developing test strategies, test plans, identification of test scenarios and test cases to ensure successful implementation of deliverables
  • Review and provide input on IM architecture and infrastructure required to support an integrated data platform Construct new and efficient ETL processes for data provisioning and data integration required for new reporting and analytic products.


  • 5+ years’ experience in 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), Guidewire and datawarehousing
  • 5+ years’ experience in constructing operational and analytic reporting solutions
  • 5+ years’ experience in Information Technology or Information Management
  • 5+ years’ experience with different Programming languages e.g. Java, SQL, VBA
  • 5+ years’ experience in Business Transformation skills
  • 5+ years’ experience in Application Specialist Skills
  • 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.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.