ETL Developer
Traffic Tech Inc.
Kirkland, QC, CA
3d ago
source : PostJobFree

We are Traffic Tech, the hardest working team in transport. We have one mission : to deliver the extraordinary, every time.

We are proud of our hard working and dynamic corporate culture. We believe that inspiring our employees and giving them opportunity for growth translates into better service for our clients.

Each and every Traffic Tech employee is personally invested in ensuring you receive the most innovative, efficient and cost-effective solution available.

Your next challenge : ETL DEVELOPERWe are looking to expand our Business Intelligence environment, and the first (and most critical) step is to build our data warehouse.

Therefore, we are in need of an ETL developer in Montréal, QC to help us grow. We value teamwork and sharing knowledge, so the candidate needs to be a strong team player, with self-motivation, integrity, and attention to detail.

The candidate must have experience working in a Microsoft environment, and decidedly have an important interest for databases / SQL.

While we use SSIS to manage the ETL workflow, the transform phase is mostly handled by T-SQL code. Therefore, SQL skills are essential, while SSIS skills are secondary.

  • Primary Responsibilities : Understand the source data being loaded;Work closely with the Team Lead to discuss database design and requirements, and implement the required ETL changes;
  • Create tables, SQL objects, database indexes and SSIS objects for ETL processes;Responsible for applying best practices for development code and source code control of the ETL process, in order to maintain an incremental load ETL process that is quick and robust;
  • Responsible to create and update lean’ documentation on the ETL process and the tables;Perform unit testing on the ETL code before handing off to testers;
  • Respond to and resolve bugs and errors identified by testers or business users;Stay up-to-date on new versions of software used (e.

    g. changes in a new version of SQL Server), and latest technology trends;Design SSRS or other BI reports when required;Generate ad-hoc reports (Excel) when business requests have a higher complexity than usual.

  • Requirements and Competencies : Minimum 2 years of experience in a position focused on T-SQL;Some experience with SQL Server Integration Services (SSIS);
  • University Degree or equivalent experience in computer science, programming or related field;Understanding in relational database design and implementation;
  • Understanding of Kimball’s data warehouse design;Solid grasp of XML and JSON;Experience with Microsoft Visual Studio.The following would be considered assets : SQL Server Reporting Services (SSRS);
  • SQL Server Analysis Services (SSAS);Python;Knowledge of full product development cycle;Agile development methodologies;Transportation-related software development.

    What we offer!Robust industry with training and mentorshipCompensation package that include Medical and Dental benefitsFree parking, employee training center, full-service bistro and a health club!Dynamic environment and can-do’ cultureShuttle Bus from / to Terminus FairviewIf this challenge sounds appealing to you, please apply now!

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form