Programmer Analyst (PA2)
Job Location:
Fredericton - Canada
Monthly Salary:
Experience Required:
Posted:
Application Deadline:
Vacancies:
Job Summary
- Design develop implement and maintain SSRS reports
- Develop and manage SSIS packages and ETL processes
- Support health analytics and reporting systems
- Develop .NET-based user interfaces
- Troubleshoot application database and reporting issues
- Collaborate with stakeholders including Business Teams DBAs and Architecture groups
- Ensure compliance with enterprise architecture privacy and security standards
- Maintain technical documentation and contribute to knowledge repositories
- Participate in release cycles incident resolution and system enhancements
- University degree in Computer Science or related discipline
- Equivalent combination of education and experience may be considered
- Minimum 10 years of IM/IT experience
- Minimum 2 years supporting health applications
- Must be within a Canadian Provincial Health Authority or Department of Health
- Minimum 6 years experience designing developing maintaining and troubleshooting SSRS reports
- Minimum 6 years experience with SQL Server Integration Services (SSIS)
- Must include creation and maintenance of SSIS packages
- Strong written and verbal communication skills in English
- Must be available to start immediately onsite in Fredericton NB
- Minimum 2 years (within last 5 years) as a Senior Programmer/Developer
- Experience in health analytics/reporting systems for Canadian provincial health organizations
- Minimum 6 years experience with:
- SQL Server (2012 or later)
- Oracle (preferred)
- Minimum 6 years experience designing developing implementing and maintaining SSRS reports
- Minimum 6 years experience designing implementing and troubleshooting SSIS packages
- Minimum 6 years experience with:
- Tables views stored procedures
- Functions indexes
- Performance tuning and troubleshooting
- Minimum 5 years experience designing and building user interfaces technologies
- Minimum 3 years experience analyzing troubleshooting and converting Cognos/Impromptu reports
- Minimum 7 years experience delivering and managing technical solutions in operational environments
- Primary work location: Fredericton NB (onsite)
- Limited remote work may be permitted with approval
- Occasional after-hours/weekend work (pre-approved)
- Functional and optimized SSRS reports and SSIS packages
- Stable and scalable health application solutions
- Technical documentation and knowledge transfer artifacts
- Timely completion of incidents service requests and project deliverables
Required Skills:
Mandatory Requirements (M1M8) Candidates must meet ALL of the following: M1 Education University degree in Computer Science or related discipline Equivalent combination of education and experience may be considered M2 IT Experience Minimum 10 years of IM/IT experience M3 Health Domain Experience Minimum 2 years supporting health applications Must be within a Canadian Provincial Health Authority or Department of Health M4 SSRS Expertise Minimum 6 years experience designing developing maintaining and troubleshooting SSRS reports M5 SSIS Expertise Minimum 6 years experience with SQL Server Integration Services (SSIS) Must include creation and maintenance of SSIS packages M6 Communication Skills Strong written and verbal communication skills in English M7 Availability Must be available to start immediately onsite in Fredericton NB Scored Requirements (S1S8) Candidates will be evaluated and scored based on the following: S1 Health Analytics Systems (Recent Experience) Minimum 2 years (within last 5 years) as a Senior Programmer/Developer Experience in health analytics/reporting systems for Canadian provincial health organizations S2 Database Technologies Minimum 6 years experience with: SQL Server (2012 or later) Oracle (preferred) S3 SSRS Development Minimum 6 years experience designing developing implementing and maintaining SSRS reports S4 SSIS Development Minimum 6 years experience designing implementing and troubleshooting SSIS packages S5 Database Development Minimum 6 years experience with: Tables views stored procedures Functions indexes Performance tuning and troubleshooting Development Minimum 5 years experience designing and building user interfaces technologies S7 Cognos/Impromptu Reporting Minimum 3 years experience analyzing troubleshooting and converting Cognos/Impromptu reports S8 Technical Solution Delivery Minimum 7 years experience delivering and managing technical solutions in operational environments
Required Education:
Mandatory Requirements (M1M8)Candidates must meet ALL of the following:M1 EducationUniversity degree in Computer Science or related disciplineEquivalent combination of education and experience may be consideredM2 IT ExperienceMinimum 10 years of IM/IT experience
