18 Nov
|
Empnéo ICT
|
Bengaluru
18 Nov
Empnéo ICT
Bengaluru
Key Responsibilities
• Design, build and maintain ELT pipelines that ingest data into Snowflake from Azure Synapse, on-premises SQL Server and enterprise applications (e.g. Dynamics 365, ERP and clinical/rostering platforms as they are onboarded).
• Develop and maintain dbt models (staging, intermediate and mart layers) that form BaptistCare's national data model, applying sound dimensional modelling practices and consistent business definitions across the merged entities.
• Support the migration and consolidation of existing Azure Synapse and SQL Server workloads into Snowflake, including refactoring logic, reconciling outputs and validating data against legacy reports.
• Build and schedule data orchestration using Azure Data Factory and/or native Snowflake and dbt scheduling.
• Deliver curated, well-documented datasets and semantic models that feed Power BI reporting across residential aged care, home and community services, retirement living and corporate functions.
• Prepare trusted, AI-ready data to support BaptistCare's AI use cases on Azure OpenAI within its own tenancy, in line with BaptistCare's data sovereignty, privacy and responsible AI principles.
• Implement data quality tests, documentation and lineage in dbt, and contribute to data governance, role-based access control and Snowflake performance and cost optimisation.
• Follow Git-based version control, code review and CI/CD practices for all data assets.
• Collaborate with BaptistCare's onshore data, analytics and architecture teams across time zones, participate in agile ceremonies and maintain clear technical documentation and handover material. Skill Summary Data Platforms: Snowflake (warehouse design, RBAC, performance tuning,
cost management); Azure Synapse Analytics Transformation & Modelling: dbt (Core and/or Cloud); dimensional modelling (Kimball); enterprise data model design Languages: Advanced SQL (T-SQL and Snowflake SQL); Python desirable Integration & Orchestration: Azure Data Factory; dbt scheduling; Snowflake tasks and streams Cloud: Microsoft Azure (storage, networking and security fundamentals) Reporting & BI: Power BI datasets and semantic models DevOps: Git, CI/CD (Azure DevOps or GitHub Actions) Security & Governance: Data quality frameworks, lineage, access controls, handling of sensitive personal and health-related data Experience & Attributes
• 5+ years of data engineering experience, including at least 2 years delivering production workloads on Snowflake and dbt.
• Demonstrated experience migrating data warehouse workloads from Azure Synapse and/or SQL Server to Snowflake.
• Experience building enterprise data models that integrate multiple source systems, ideally in a post-merger or consolidation context.
• Exposure to healthcare, aged care, not-for-profit or other regulated sectors is highly desirable.
• Robust written and verbal English, with proven experience working remotely with Australian stakeholders.
• A security-conscious, detail-oriented approach and the ability to work autonomously while keeping stakeholders informed. Certifications (Preferred)
• Snowflake SnowPro Core Certification (SnowPro Advanced: Data Engineer highly regarded)
• dbt Analytics Engineering Certification
• Microsoft Certified: Fabric Data Engineer Associate (DP-700) or Azure Data Engineer Associate (DP-203)
• Microsoft Certified: Power BI Data Analyst Associate (PL-300) – desirable
📌 Data Engineer (Bengaluru)
🏢 Empnéo ICT
📍 Bengaluru