Role: Azure Data EngineerLocation: Toronto, ON (4 days onsite per week)Term: Full TimeNote: The L1 and L2 interview will be conducted in person at the clients location.Data Modelling & ArchitectureStrong understanding of semantic models used in enterprise reporting and analytics.Expertise in dimensional modelling, including star and snowflake schema design.Practical experience implementing Slowly Changing Dimensions (SCD) Type 1 and Type 2.Ability to translate business requirements into scalable data models.Advanced Spark SQLProficiency in Spark SQL, including complex joins, aggregations, and transformations.Strong command over window functions, ranking functions, and analytical queries.Ability to troubleshoot performance issues and optimize Spark SQL queries.PySpark DevelopmentWorking knowledge of PySpark for data ingestion, transformation, and workflow orchestration.Ability to write and understand basic pyspark functionsBasic understanding of Spark architecture, including executors, partitions, and caching.Data Engineering SkillsExperience building ETL/ELT pipelines using Azure Databricks and load to Synapse.Familiarity with Delta Lake, data versioning, and ACID transactions.Independence & CollaborationAbility to work independently with minimal oversight.Strong communication skills to collaborate with cross-functional teams and business stakeholders.Proactive in identifying issues and proposing data-driven solutions.Please let me know if you would like to refine this further or add any additional requirements.
Job Title
Azure Data Engineer