The Azure Data Warehouse Developer (Systems Analyst) will be responsible for modeling, designing and developing data warehouse and business intelligence solutions.
Description of Duties / Scope of Work Designing, developing and maintaining the enterprise data warehouse and associated data marts Responsible for designing, developing and documenting SSIS and/or Azure Data Factory (ADF) packages to integrate data from multiple systems Responsible for building ADF code to integrate data from SAP S4/HANA, SAP ECC and SAP SuccessFactors with Azure Synapse Responsible for designing, developing and documenting complex T-SQL, stored procedures, views, triggers, indexes, etc. Responsible for designing and implementing data quality processes Assist in the data modelling of the data warehouse/data mart solutions as required for the Azure Synapse solution Work closely with the business analysts, and other team members, to understand requirements Convert business requirements to technical specifications. Research, document and share knowledge with the project team. Provide accurate time estimates for work to be undertaken Work on other project tasks as assigned.
Mandatory Skills / Certification 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 Services Expert understanding of Microsoft Azure Services Administration Expert understanding and enterprise scale experience working with Data Warehouse (DW) and Business Intelligence (BI) implementations Extensive 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 DW Expert in Microsoft Transact-SQL programming with the ability to optimize, analyze and improve database SQL performance as well as built robust 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 techniques Ability 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