Data Engineer I Modernisation & Data Analytics

Why join us at SCC?

We have a long history of providing exceptional care that empowers older people to live a full life. When you join us, you will be provided with not-for-profit salary packaging benefits and the support of an experienced leadership team.

About the Role:

We are seeking an experienced Data Engineer to join our team and support the delivery of Data & Analytics Modernisation program using Microsoft Fabric. You will design, develop, and maintain scalable data pipelines, Lakehouse and Warehouse solutions, and data integrations that enable trusted insights and better decision-making across the organisation.

Microsoft Fabric Data Engineering

• Design, build and maintain data pipelines using Microsoft Fabric Data Factory.
• Build and manage Fabric Lakehouse, Warehouse and OneLake data structures.
• Develop ingestion, transformation and orchestration processes using notebooks, Spark and SQL.
• Implement scalable, layered (medallion-style) data architectures - raw, curated and consumption-ready.
• Monitor pipeline performance and troubleshoot data processing issues.

Data Integration

• Integrate data from clinical, workforce, payroll, finance, risk, quality and operational systems.
• Build integrations using APIs, databases, files, Azure services and vendor-supported interfaces.
• Work with application owners and vendors to understand source systems and constraints.
• Implement incremental loads and change data capture where appropriate.

Data Modelling and Analytics Enablement

• Develop dimensional, relational and analytical data models that support reporting.
• Create curated datasets and data products for Power BI developers, analysts and business users.
• Assist with the development and optimisation of Power BI semantic models.
• Translate business reporting and analytics requirements into technical data solutions.

Data Migration and Modernisation

• Assist with migrating existing data warehouse, ETL, SSRS and reporting solutions into Fabric.
• • Analyse existing data flows, stored procedures and dependencies, and rebuild them using Fabric.
• Support reconciliation and validation between legacy and replacement solutions.
• Identify opportunities to simplify data flows and retire unsupported technologies.

Data Quality, Security and Governance

• Implement automated data validation, reconciliation and quality monitoring controls.
• Investigate data quality issues with system owners, data stewards and business teams.
• Support master data management and golden-record principles.
• Apply role-based access, least-privilege and security controls within Microsoft Fabric.
• Support data classification, lineage and cataloguing using
• Ensure sensitive, personal, health and financial information is handled per policy and regulation.

Development Practices and Operational Support

• Use source control and CI/CD practices through Azure DevOps, Git or equivalent.
• Maintain technical documentation - solution designs, source-to-target mappings, data dictionaries.
• Monitor production data solutions, investigate incidents and perform root-cause analysis.
• Support scheduled data processing and regulatory submission deadlines.

What You Will Bring

Education and Experience

• Tertiary qualification in Information Technology, Computer Science, Data Engineering, or a related discipline, or equivalent practical experience.
• Demonstrated experience designing, developing, and supporting data pipelines and ETL/ELT processes.
• Strong hands-on experience with SQL, relational databases, and cloud-based data platforms.
• Experience developing data models, reporting solutions, and analytics platforms by integrating multiple data sources.
• Experience implementing data reconciliation, validation frameworks, and data quality controls.
• Microsoft Certified: Fabric Data Engineer Associate or equivalent Azure Data Engineering certification (desirable).

Personal Attributes

• Builds effective relationships across technical teams, stakeholders and vendors.
• Investigates complex data issues methodically and finds sustainable solutions.
• Takes ownership of deliverables, production issues and agreed outcomes.
• Explains technical concepts to audiences with varying data knowledge.
• Produces accurate, tested and well-documented data solutions.
• Works effectively as platforms, priorities and capabilities evolve.

Technical Skills and Capability

• Practical experience with Microsoft Fabric - Data Factory, Lakehouse, Warehouse, OneLake, notebooks and Spark - or strong equivalent Azure Data Factory / Azure SQL experience.
• Experience developing Power BI datasets or semantic models.
• Experience with Microsoft Purview, data lineage and cataloguing.
• Experience with Python, SQL, DAX or Power Query.
• Experience with APIs, JSON, REST services and secure file-transfer methods.
• Experience with Git, Azure DevOps and CI/CD processes.
• Experience in aged care, healthcare or another highly regulated environment (Desirable).

What’s in it for you?

• Salary Packaging ($15,900), plus meal and entertainment benefit package to the value of $2,650
• Heart HQ - our Southern Cross Care (NSW & ACT) People Platform, packed with exclusive retail discounts, and features designed to help you celebrate, connect and succeed
• Fitness Passport - Discounted workplace health and fitness program available to you and your family. Gain full access to nominated gyms, pools, health and leisure centres across NSW & ACT
• Discounted private health insurance
• Wellbeing initiatives such as Reward and Recognition Program, Employee Assistance Program
• Annual leave loading
• Ongoing Training and Development
• Linkedin Training - SCC's Senior Leaders and Support Office teams can access a digital library of over 6000 courses
• Genuine Career Progression Pathways – Buddy Program, New Grad Elevate Program, Study Support
• Referral Bonus Program

About Southern Cross Care (NSW & ACT)

At SCC (NSW & ACT), people are at the heart of everything we do! We are a purpose-led, not-for-profit organisation empowering older people to ‘live life to the full’. We have a passion for providing the best care with clinical excellence and offer person-centred care services to meet individual needs and preferences in residential aged care, retirement living and in-home care.

Join us at SCC (NSW & ACT), where your work is not just a job, but a journey filled with meaningful moments to make a tangible difference in the lives of those we support. Our commitment to your development is unwavering, and we work hard to ensure you are given ample opportunities to continually learn and grow.

SCC is an equal opportunity employer. Creating a diverse and inclusive workplace, where employees feel valued and heard in a safe and respectful workplace, is a priority. All employment is decided based on qualifications, merit, and business need. We welcome people of Aboriginal and Torres Strait Island identity, as well as people of culturally diverse backgrounds, to apply.