This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

previous arrow
next arrow


MODIS: Azure Data Warehouse Developer


This is a Contract position in Montreal, QC posted February 21, 2021.

Our client is looking for Azure Data Warehouse DeveloperWho will be Working under the supervision of the Enterprise Data Technical Team Lead, the Azure Data Warehouse Developer (Systems Analyst) will be responsible for modeling, designing and developing data warehouse/ and business intelligence solution(s).He/she will follow design & development methodologies and documentation standards.

Description of work :Work with the Enterprise Data project team in designing, developing and maintaining the enterprise data warehouse and associated data martsResponsible for designing, developing and documenting SSIS and/or Azure Data Factory (ADF) packages to integrate data from multiple systemsResponsible for building ADF code to integrate data from SAP S4/HANA, SAP ECC and SAP SuccessFactors with Azure SynapseResponsible for designing, developing and documenting complex T-SQL, stored procedures, views, triggers, indexes, etc.Responsible for designing and implementing data quality processesAssist in the data modelling of the data warehouse/data mart solution(s) as required for the Azure Synapse solution.

Work closely with the business analyst(s), and other team members, to understand requirementsConvert business requirements to technical specifications.Research, document and share knowledge with the project team.Provide accurate time estimates for work to be undertakenWork on other project tasks as assigned.

Skills Required A university degree in Computer Science, or the equivalent, combined with directly related experience in a business or computer related discipline.

Minimum of 5 years’ experience working as a Data Warehouse or Data Integration developer.Extensive hands-on experience working with Microsoft Azure Synapse and/or SQL Data Warehouse and SQL Server 2016 or later.Extensive hands-on experience working with Microsoft Azure Data Factory and other related Azure ServicesExpert understanding of Microsoft Azure Services AdministrationExpert understanding and enterprise scale experience working with Data Warehouse (DW) and Business Intelligence (BI) implementationsExtensive hands-on experience building data integration solutions to move data between SAP systems (SAP S4/HANA, SAP ECC, SAP SuccessFactors) and Microsoft Azure Synapse/SQL DWExpert in Microsoft Transact-SQL programming with the ability to optimize, analyze and improve database SQL performance as well as built robust performant SQL Server Integration Services packages.Strong understanding of data modelling techniques as relates to data warehouse design.

Experience with data quality, data cleansing and data stewardship processes and techniquesAbility to solve complex data problems by analysis, develop appropriate solutions and clearly communicate those solutions to the team.

Ability to work efficiently and provide accurate time estimates for work to be undertaken.Well-developed interpersonal, oral and written communication skills, strong analytical and problem-solving skills.You must have or rapidly acquire a comprehensive knowledge of the Ontario Human Rights Code and Related Orders including disability accommodation and accessibility requirements pertaining to passengers and employees.Experience working in an Agile project development environment