Core Purpose: 

The Technical Advisor is a senior resource with strong IT background who assumes leadership and provides governance for a specific IT field under his/her responsibility. Although, the technical advisor has no staff, he/she gives technical directions to colleagues working in the same IT field.

Within his/her field of expertise, the technical advisor:

• Insures quality and coherence of the solutions that are designed
• Eases the evolution of the systems by selecting solutions that are aligned with the exiting system design
• Defines system architecture in collaboration and under the leadership of the Aimia architecture group and the IT Data Architect
• Defines, documents, communicates and enforces internal best practices, standards, guidelines and templates
• Defines work methodology in collaboration and under the leadership of his/her manager
• Maintains system documentation up to date. This documentation must be structured and manage to be easily retrieved
• Defines and documents high level solutions for major initiatives and projects
• Defines and documents testing and deployment strategies for major systems changes and for every required environments
• Performs impact analysis for upcoming changes
• Estimate the work effort required to deliver BI solutions (Back-end and Front-end)
• Approves deliverables produced by the client technical analysts and external IT suppliers (i.e. Approval of solution design documents  and  approval of actual system coding by conducting walkthroughs)
• Provides support and direction to colleagues working in the same IT field
• Assumes the role of a Technical Analyst, Functional Analyst or Business Analyst him/herself
• Responsible to define processes and internal controls to insure compliance to IT control within the BI technology
• Act as a leader to improve problem resolution by guidance and methodology
• Define and trace benchmarks for system change or implementation
• Perform requests review with manager in order to identify,  matches and prioritize the requests
• Act as a 1st point of technical contact for the BI team

Not limited to the list below, IT fields requiring technical advisors are:

• ETLs
• Web services
• Data modeling
• Reporting tools

Key Performance Indicators:

• The direction provided by the technical advisor (i.e internal best practices, standards, guidelines and templates) must be aligned with best practices in the industry
• Solutions deployed in production must be aligned with the direction documented
• Rework caused by inadequate system design must be limited to its minimum
• Number of production bugs must be limited to its minimum
• System documentation and communication material must be accurate, relevant and up to date
• Functional and non-functional (i.e. performance, usability, …) requirements must be fulfilled
• The technical advisor must be perceived by his/her colleagues as the ultimate reference in his/her it field.
• Ultimately, system users must be satisfied by the IT solutions that are deployed

Required Skills and Competencies:

• Bachelor’s degree in Computer Science with at least ten years of work experience or equivalent combination of different education/work experience.
• Minimum five years’ experience in the IT field specific to this job
• Must be bilingual (French and English)
• Strong communication and interpersonal skills. Capability to clearly communicate ideas and concepts. Capability to work in collaboration with others. Capability to influence and persuade others.
• Capability to understand and resolve complex problems and challenges
• Flexibility and willingness to work extended hours when required.
• Strong knowledge of Datastage
• Knowledge of BI tools (Microstrategy is a +, SAS, UNICA, BO)
• Knowledge of DB2 recommended

Knowledge of other BI and ETL tools would be an asset 

Core Purpose: 

The Technical Advisor is a senior resource with strong IT background who assumes leadership and provides governance for a specific IT field under his/her responsibility. Although, the technical advisor has no staff, he/she gives technical directions to colleagues working in the same IT field.

Within his/her field of expertise, the technical advisor:

• Insures quality and coherence of the solutions that are designed
• Eases the evolution of the systems by selecting solutions that are aligned with the exiting system design
• Defines system architecture in collaboration and under the leadership of the Aimia architecture group and the IT Data Architect
• Defines, documents, communicates and enforces internal best practices, standards, guidelines and templates
• Defines work methodology in collaboration and under the leadership of his/her manager
• Maintains system documentation up to date. This documentation must be structured and manage to be easily retrieved
• Defines and documents high level solutions for major initiatives and projects
• Defines and documents testing and deployment strategies for major systems changes and for every required environments
• Performs impact analysis for upcoming changes
• Estimate the work effort required to deliver BI solutions (Back-end and Front-end)
• Approves deliverables produced by the client technical analysts and external IT suppliers (i.e. Approval of solution design documents  and  approval of actual system coding by conducting walkthroughs)
• Provides support and direction to colleagues working in the same IT field
• Assumes the role of a Technical Analyst, Functional Analyst or Business Analyst him/herself
• Responsible to define processes and internal controls to insure compliance to IT control within the BI technology
• Act as a leader to improve problem resolution by guidance and methodology
• Define and trace benchmarks for system change or implementation
• Perform requests review with manager in order to identify,  matches and prioritize the requests
• Act as a 1st point of technical contact for the BI team

Not limited to the list below, IT fields requiring technical advisors are:

• ETLs
• Web services
• Data modeling
• Reporting tools

Key Performance Indicators:

·         The direction provided by the technical advisor (i.e internal best practices, standards, guidelines and templates) must be aligned with best practices in the industry

·         Solutions deployed in production must be aligned with the direction documented

·         Rework caused by inadequate system design must be limited to its minimum

·         Number of production bugs must be limited to its minimum

·         System documentation and communication material must be accurate, relevant and up to date

·         Functional and non-functional (i.e. performance, usability, …) requirements must be fulfilled

·         The technical advisor must be perceived by his/her colleagues as the ultimate reference in his/her it field.

·         Ultimately, system users must be satisfied by the IT solutions that are deployed

Required Skills and Competencies:

·         Bachelor’s degree in Computer Science with at least ten years of work experience or equivalent combination of different education/work experience.

·         Minimum five years’ experience in the IT field specific to this job

·         Must be bilingual (French and English)

·         Strong communication and interpersonal skills. Capability to clearly communicate ideas and concepts. Capability to work in collaboration with others. Capability to influence and persuade others.

·         Capability to understand and resolve complex problems and challenges

·         Flexibility and willingness to work extended hours when required.

·         Strong knowledge of Datastage

·         Knowledge of BI tools (Microstrategy is a +, SAS, UNICA, BO)

·         Knowledge of DB2 recommended

Knowledge of other BI and ETL tools would be an asset