Data Engineer
Rakesh KumarRemoteMIDPosted 5h ago
SnowflakedbtAdvanced SQLT-SQLSnowflake SQLELT pipelinesAzure Synapse AnalyticsSQL ServerDimensional modellingEnterprise data modellingAzure Data Factorydbt schedulingSnowflake TasksSnowflake StreamsPower BIPythonGitCI/CDAzure DevOpsGitHub ActionsData qualityData lineageRBACData governance
About the Role
We are looking for a Data Engineer to join our team, focusing on building and maintaining Snowflake ELT pipelines and developing dbt models.
Key Responsibilities
• Build and maintain Snowflake ELT pipelines
• Develop dbt staging, intermediate and mart models
• Migrate Synapse and SQL Server workloads to Snowflake
• Build data orchestration using ADF and Snowflake
• Deliver curated datasets for Power BI reporting
• Implement data quality, governance, security and performance optimisation
Requirements
• 5+ years of Data Engineering experience
• Minimum 2 years of hands-on experience with Snowflake and dbt (Core/Cloud)
• Strong experience in Advanced SQL, T-SQL and Snowflake SQL
• Experience building and maintaining ELT pipelines
• Hands-on experience with Azure Synapse Analytics and SQL Server
• Experience migrating data warehouse workloads from Synapse / SQL Server to Snowflake
• Strong knowledge of dimensional modelling (Kimball) and enterprise data modelling
• Experience with Azure Data Factory (ADF), dbt scheduling, Snowflake Tasks and Streams
• Experience with Power BI datasets and semantic models
• Knowledge of Python, Git, CI/CD and Azure DevOps / GitHub Actions
• Understanding of data quality, lineage, RBAC and data governance
Good to Have
• Healthcare, aged care or other regulated industry experience
• Snowflake SnowPro Core / Advanced certification
• dbt Analytics Engineering certification
• Azure Data Engineer (DP-203), Fabric (DP-700) or Power BI (PL-300)
• Experience working with Australian stakeholders