Senior Data Integration Developer
Annex Consulting Group
Greater Vancouver, CA
36d ago

Job ID : 11162 Senior Data Integration Developer Greater Vancouver, British Columbia

Our tourism and hospitality client is looking for a Senior Data Integration Developer who will be responsible for Data Integration (DI) design and development within the IM CoE and will function as the Developer for the Data Integration platform that supports enterprise applications, systems and business processes.

Additionally, this position will be responsible for the design, development and maintenance of data transformation and migration workflows for the enterprise data warehouse (eDW), operational data store (ODS), master data management and other enterprise applications, including relational and non-

relational repositories (SQL, JSON, XML, Rest APIs etc.) Our client has standardized on using Microsoft as the technology platform, this role will be focused on (but not restricted) the use and application of the Microsoft IM software stack including SQL Server and SQL Server Integration Services, exposure to the MS Azure data stack will be an asset.

Job Type : Contract

This role will be a mix between data warehouse development using SQL Server Integration Services, data architecture and modelling and IT support by defining and implementing Best Practices for data integration and troubleshooting IM related issues as part of day-

to-day operational and IT Help Desk activities.

The successful candidate must meet the following requirements :

  • At least 5 years’ experience with Data Integration / ETL design and development using MS SQL Server Integration Services.
  • Extensive experience using Python to perform data operations.
  • At least 1 year experience with MS SQL Server Master Data Services.
  • Master level experience on SQL language, SQL optimization and performance.
  • Experience with reporting tools, such as Cognos and Business Objects is an asset
  • Experience with visualization tools, such as Tableau and Qlik is an asset
  • Experience with other ETL tools is an asset.
  • Experience with APIs development / access is an asset
  • Experience with data integration with systems such as CRM (Salesforce), Marketo, Google Analytics and a CMS (e.g. Drupal) is an asset
  • Professional certifications such as MSCA or MSCE in Data Platform (SQL Server) or BI is an asset.
  • Professional certifications in IBM Business Analytics, preferably IBM Cognos Administration is an asset.
  • Experience with Jupyter Hub or Jupyter Notebook is an asset.
  • Annex Consulting Group is a full-service IT and management consulting firm, specializing in staff augmentation contracting, permanent staffing, and outsourced solutions.

    Candidates must be legally entitled to work in location advertised.

    Not interested but know someone who is a fit for this role? Check out the award-winning Annex Referral Program.

    Contact Hayley Dawson for further information.

    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.
    Application form