Business Systems Analyst/Programmer

Information Technology
Direct Hire
Ancaster, Ontario
Job ID:

#153761 – Business Systems Analyst/Programmer


Ancaster, Ontario

Duties and Responsibilities:  

  • Responsible for the administration and design of information systems technologies and information centers as directed
  • Responsible for design, maintenance and administration of internal business applications using various programming technologies.
  • Extract, Transfer, Load (ETL) required data between systems
  • Design, implement and maintain reports using Microsoft Analysis Services (OLAP), Debug and Fix all reoccurring errors in current information applications
  • Redesign existing information applications to reduce duplication effort and resources as requested
  • Provide training for all systems in this area of responsibility
  • Responsible for administration and maintenance for database servers (SQL, DB2) 
  • Perform other related duties as required

Qualifications & Requirements:

  • A degree in computer engineering or equivalent
  • Ability to work under pressure, with minimal supervision and on multiple projects, and within multiple time constraints is required
  • Excellent computer skills (hardware, software and programming knowledge required)
  • Must possess exceptional organizational, interpersonal and strong verbal and written communication skills, as well as a demonstrated ability in problem solving. 
  • Expert in programming languages including .Net, (VB/C#), T-SQL, VBA, Java Script, HTML/CSS
  • Expert in administration and maintaining SharePoint
  • Basic Windows server 2012, Active Directory, Exchange experience is an asset
  • Basic AS400 (iSeries 7.x) experience
  • Basic knowledge in content management systems including DNN and WordPress
  • Experience with Microsoft Business Intelligence (SSIS/SSAS)
  • ERP, especially CMS and Infor EAM knowledge is an asset


1. Exceptional organizational, interpersonal and strong verbal and written

2. Expert in .Net, (VB/C#), T-SQL, VBA, Java Script, HTML/CSS – more the better

3. Expert in SharePoint

4. ERP data extraction (any database but DB2 preferred.