Technical Analyst

ALTEN Canada; Fredericton; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading technology consultancy is seeking a Technical Analyst Level 2 for their Client Service Delivery System in Fredericton. The ideal candidate will have 15+ years of IM/IT experience, with proficiency in SQL and PL/SQL. Responsibilities include support for SSRS reports and development work. This contract role emphasizes a collaborative work environment and values diversity and professional growth.

Qualifications

• 15+ years in IM/IT roles.
• 10+ years as a Senior Programmer Analyst.
• 5+ years working with Provincial Health Care applications.

Responsibilities

• Provide production support for SSRS reports.
• Assist business teams with training and user acceptance testing.
• Develop and maintain PL/SQL stored procedures.

Skills

Production support for SSRS reports

Troubleshoot issues

Maintain technical documentation

Develop PL/SQL stored procedures

Support incident resolution

Education

University degree in Computer Science or equivalent

Tools

Oracle

SQL Server

Java

Linux

Job description

About ALTEN:

In just three decades, ALTEN has emerged as a global leader in Research and Development, Engineering, Information Technology Services, Life Sciences, and Network Services. Our footprint spans across 30 countries, with over 60,000 consultants driving innovation and technical excellence. Trusted by industry giants, we have become synonymous with pioneering solutions and unwavering expertise.

ALTEN CANADA, a proud subsidiary of ALTEN headquartered in France, is committed to serving the Canadian market. With local offices in Montreal and Toronto, we bring our global expertise to the forefront of Canadian innovation.

At ALTEN CANADA, our consultants thrive on tackling complex and highly technical projects across a diverse range of industries. From Manufacturing to Information Systems, IT Automation to Life Sciences, Energy to Automotive, Rail and Transportation to Telecommunications, Aerospace and Defense, our commitment to excellence knows no bounds.

Job Title: Technical Analyst Level 2 – Client Service Delivery System (CSDS)

Location: Fredericton, NB

Language of Work: English

Start Date: 17-Sep-2025

Type: Contract

About the Role

The client is seeking a highly experienced Technical Analyst Level 2 to support the Client Service Delivery System (CSDS). CSDS is a critical case management system used by Mental Health and Addiction Services, as well as Public Health staff. This role involves both steady-state support and project-based development efforts.

Key Responsibilities

• Provide production support for SSRS reports and troubleshoot issues.
• Assist business teams with training and user acceptance testing.
• Maintain and create technical documentation, standards, and procedures.
• Develop and maintain PL/SQL stored procedures and scripts.
• Support application release activities and incident resolution.
• Participate in team scrums and update knowledge documentation.
• Perform after-hours and weekend support as required (pre-approved).

Mandatory Requirements

• Education: University degree in Computer Science or equivalent combination of education and experience.
• Experience:
• 15+ years in IM/IT roles.
• 10+ years as a Senior Programmer Analyst.

Scored Qualifications

• 5+ years working with Provincial Health Care or Regional Health Authority applications.
• 10+ years developing, documenting, coding, testing, and implementing technical solutions.
• 10+ years with Oracle and SQL Server databases.
• 5+ years maintaining and creating PL/SQL stored procedures.
• 2+ years with Java and Linux batch jobs.
• 5+ years with SSIS and SSRS.
• 3+ years using version control software.

Deliverables

• Timely completion of assigned maintenance, support, and development tasks.
• Resolution of incidents and problem management tickets.
• Participation in application release activities and operational support.
• Documentation updates and knowledge sharing within the team.

ALTEN Canada fosters a dynamic and collaborative work environment where team members are empowered to unleash their full potential. We believe in investing in our talent, offering stimulating experiences, and supporting professional growth and development at every turn.

ALTEN CANADA is committed to promoting diversity, equity, and inclusion. We strive to provide a work environment where every individual feels welcomed, valued, and respected, allowing them to thrive to their full potential. This includes our dedication to offer accessibility measures to those who require them. Should you require any accommodation during our recruitment process, please reach out to us.