Career Opportunities Contact Us Français Italiano
Home Services Solutions Profile
In order to meet the growing needs of our customers, we are constantly searching for dynamic, qualified individuals to join the CTC resource team. Currently, there are several career opportunities available at CTC. If you feel you satisfy the qualifications for one of the positions listed on this page, please send your CV to resources@ctcinc.ca identifying the position(s) you are interested in. Qualified individuals will be contacted by our human resources department.
CTC005696 : ETL / Software Developer
Location : Toronto, Ontario
Field : ETL
Position Type : Contract
Starting : January 25, 2021
Ending : July 23, 2021
Resources Required : 1
Position Description

Language: English only (French is an asset)

Job location: Remote for now until things change; potentially back in the Toronto office

Must have skills:

SSIS

.Net, C#

Application development

Experience with Git, GitHub

What you’ll do

- Design and develop innovative solutions for managing data integration between various data systems, platforms and file types

- Design, build, deploy and maintain small to medium sized applications with focus on automation and efficiency

- Load target databases using complex transformations that come from multiple systems

- Lead data warehouse architecture design and build robust analytical data models for downstream reporting and analytics

- Monitor and optimize ETL processes and data performance to ensure the stability of NBIN’s BI environment

- Perform data analysis and data modelling to create functional design documents and source to target mappings

- Be involved in discussing and collecting business requirements from stakeholders and translate to design and development specifications

- Build reusable code and libraries

What you bring to the team

- University degree in Computer Science or any equivalent work experience

- Minimum 7 years experience in a BI / ETL role or similar position

- Minimum 5 years experience developing ETL solutions using SSIS

- Extensive experience in SQL programming

- Experience with .Net, C#, JavaScript, PowerShell programming languages

- Experience with Microsoft Access DBs and VBA programming

- Experience with application development (i.e. middleware, application design and backend development)

- Experience using code repositories (Git, Github, CVS)

- Extensive experience in the design of structures and data models

- Experience in optimizing SQL queries

- Experience working with cloud technologies such as AWS, Azure is preferred

- Experience with big data technologies is an asset (i.e. Hadoop, Spark, Kafka)

- A desire to learn new technologies, innovate and be creative in achieving goals