Educational requirements: Bachelor
English requirements: Competent English
Requirements for skilled employment experience for years: 3-5 years
Required residence status: Temporary visa, Permanent resident, Citizen
Accept remote work: unacceptable
We are looking for a Microsoft Azure Data Engineer responsible for developing and maintaining the data architecture, models and standards for various Data Integration & Data Warehouse projects in Azure. Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view. In addition, to develop and maintain the documentation of the data architecture, data flow, and data warehouse data models appropriate for both technical and business audiences.
Responsibilities:
Design and develop ETL pipelines in and out of a data warehouse using Azure Data Factory (ADF) Ability to write SQL queries against Azure SQL Database / Synapse. Provide production support for Azure SQL Database / Synapse issues such as data load, transformation, and translation problems. Integration of on-premises infrastructure with cloud (Microsoft Azure) infrastructure. Effectively translate business intelligence, reporting and analytics requirements to database modelling and design. Ability to understand data pipelines and modern ways of automating data pipelines using cloud-based and on-premises technologies. Actively test and document implementations, so others can easily understand the requirements, implementation, and test conditions. Partner with the Data Architects, Product Managers and Scrum Masters to deliver data integration solutions required for various projects. Ensure effective technical and project documentation across all phases of delivery.
Required:
Comprehensive, hands-on experience working as a Microsoft Azure Data Engineer. Ideally, at least 3 years in Data Warehousing, ETL/ELT, BI, and Analytics projects. Must have experience with at least one (1) end-to-end implementation of an Azure Cloud Data Warehouse and two (2) end-to-end data warehouse implementations. Expertise in data modelling, ELT using ADF, implementing complex views, stored procedures and standard DWH and ETL/ELT concepts. Extensive design and implementation experience in Azure cloud data platform and modern data warehousing. Including aspects such as Security, Azure Logging and Monitoring, Azure Databricks, Synapse, Azure Blob Storage, Azure Data Lake, Azure Data Factory, Azure SQL Database, Azure Analysis Services, Power BI Deep understanding of relational and NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling). Experience with data security and data access controls and design. Proficiency in RDBMS, complex SQL queries, database performance tuning and troubleshooting. Commercial experience with full-stack MS Power BI modelling (M code), Dax, data storytelling, report publishing, security, and knowledge of how people make decisions with data. Provide resolution to complex data pipeline-related problems proactively and as issues surface. Must have experience with Agile development methodologies. Experience working directly with technical and business teams. Strong written communication skills. Effective and persuasive in both written and oral communication.
