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