Senior Technical Analyst

Job content

Minimum ten (10) years as a Technical Analyst or Programmer Analyst.

Demonstrated experience with SSRS reports in a development environment.

Demonstrated experience with Provincial Regional Health Authority and/or Department of Health applications in Canada.

Demonstrated experience with designing, developing, implementing, migrating, and maintaining SSRS reports.

Demonstrated experience in developing and managing the implementation of technical solutions in an operational environment.

Demonstrated experience with SQL Server Integration Services (SSIS) including designing, implementing, and troubleshooting SSIS packages.

Demonstrated experience with creating, maintaining, and troubleshooting database tables, views, functions, stored procedures, and indexes.

Demonstrated experience with analyzing, troubleshooting, and converting Cognos/Impromptu reports.

Demonstrated experience with troubleshooting SQL-based reports.

Demonstrated experience in security related to data confidentiality and client privacy issues in application design and development.

Demonstrated ability to translate business requirements into report designs.

Demonstrated experience with relational database concepts and software development lifecycles (SDLC).

The successful candidate must deliver the following, in order to successfully complete the engagement:

• Participate in the analysis, development, implementation, integration and configuration of SSRS reports;
• Lead/participate in the development of SSIS packages;
• Ensure that report design requirements are being met for ongoing release maintenance and support;

§ Troubleshoot problems and propose solutions;

§ Work with the various stakeholders (Business Teams, Application Support Teams, DBAs, other development teams, etc.) to ensure successful implementation;

• Work with the Enterprise Architecture group representatives to ensure that the system architecture conforms to the Enterprise Architecture Framework, including privacy, security, operational and quality assurance controls;
• Completion of all assigned maintenance, support, and development activities (service requests, releases, incidents, problems, projects, etc.).
• Updating of team knowledge sites and documentation as applicable.
• Other duties as assigned, such as update team documentation as required, participate in team scrums as required, etc.