Request a consultation

Senior Warehouse/BI Technical Architect

South Yarra VIC

Our Company

The world of healthcare is evolving.  At Alcidion, we are playing our part.  Every day, we help healthcare organisations to embrace smart technology.  We make a positive difference to patient outcomes and we have a simple purpose, that is, to transform healthcare, together with our customers.  We are a focussed team of like-minded people with a set of skills and products that create a unique offering in the global healthcare market.  The Alcidion Group of companies brings together the very best in technology and health sector knowledge to deliver solutions that make healthcare better for everyone.

The Role

We are growing and so is our team. We are looking for a Senior Warehouse/BI Technical Architect to drive the delivery, enhancement and maintenance of our core Clinical Data Warehouse solution and associated Business Intelligence (BI) offerings. You will work on customer projects to implement and extend our solutions, as well as lead on technical and architectural components of the Data Warehouse and Business Intelligence solutions utilising Microsoft tools. This role requires an experienced warehouse technical lead who has an aptitude for leading others to deliver complex solutions.


The main responsibilities include:

  • Leading a small team in aspects of technical warehouse & BI solution delivery
  • Leading in the delivery of complex solution architecture & design for our warehouse solution
  • Support customers in discussions regarding optimal architecture and infrastructure to run our solutions (including on premise and Azure hosted architectures)
  • Pre-sales support including providing responses to tender questions based on the architecture of our solution, as well as demonstrating the benefits of our solution
  • Attending customer meetings to discuss architecture, design and technical issues
  • Initial project planning, design and architecture, including establishing work break down structures and tasks required to implement
  • Senior technical lead in project delivery to ensure successful implementation
  • Supporting the team in resolving technical issues as they arise in project, or during support
  • Undertaking a lead role in data migration and bulk load activities
  • Understanding the underlying data models and business processes and assisting in delivering SQL queries as required
  • Assisting with clinical or research requests for data extraction and analysis
  • Developing and maintaining supporting solution documentation
  • Providing ongoing support to the data warehouse platform

Skills and Experience 


  • Significant experience working with customers to plan and architect complex warehouse solutions (e.g. 15+ years)
  • Experience in leading a technical team to deliver warehouse/BI solutions to customers
  • Bachelor’s degree in Computer Science or IT, or equivalent experience in healthcare IT
  • Hands-on experience as an ETL developer using Advanced Integration tools e.g. SSIS
  • Microsoft BI Stack (SSIS, SSAS (Tabular), Data Warehouse)
  • Building DAX queries using Power BI or SSAS Tabular model
  • SQL Server 2017 and above – TSQL
  • Experience with writing complex queries on MS SQL databases
  • Strong DAX skills
  • Microsoft Power BI


  • Experience with Electronic Medical Record (EMR) software such as Cerner Millennium, Epic or InterSystems
  • Experience in using data replication technologies (Goldengate, StarQuest etc)
  • Knowledge of Microsoft Power BI or similar BI tools
  • Microsoft Developer Certification
  • Use of Python, R Studio
  • Knowledge of HL7, FHIR
  • Knowledge of Microsoft MDM, DQS.

Statement of Posting

  • You must have the right to live and work in Australia to be considered for this position
  • Prospective employees will be required to undertake pre-employment checks, which may include referee, criminal record and employment history checks as required
  • Alcidion is an equal opportunity employer. We are committed to a diverse and inclusive culture and encourage all interested applicants to apply

How to Apply

If you are excited by the idea of working with a great team of like-minded individuals and believe you fit the criteria above, please apply by submitting your application including your resume to To be considered you must also include a covering letter addressing why you would love to work for Alcidion in this role.