Data Engineer

Data Engineer
  
About Us
  
For over 60 years, Cancer Council Queensland’s pioneering work has helped save thousands of lives and has improved the quality of life for people living with cancer. Our mission is to lead Queenslanders in a partnership against cancer.
  
Cancer Council Queensland raises funds that are dedicated to improving the quality of life for people living with cancer through research to support prevention and early detection.
  
We are dynamic, outcome-focused, responsive to community needs, and committed to voluntarism and the pursuit of excellence.
  
Cancer Council Queensland employees and volunteers lead Queenslanders in a partnership against cancer by employing high-performing employees who live our values of being responsible, inclusive, equitable, and collaborative.  
  
Working at Cancer Council Queensland
  
Our greatest asset is our diverse team of talented, savvy people. Our awesome employees and volunteers tell us that Cancer Council Queensland is a meaningful, rewarding and fun place to work.
  
We provide a positive and supportive working environment where you will be a valued team member. We love to recognise and reward our team of superstars with employee benefits such as extra paid days off.  
  
About the role 
  
As a Data Engineer within the Applications team, you will be responsible for managing and optimising our data infrastructure ensuring its security, integrity and accessibility.
  
You will also be involved in designing and implementing data models, developing ETL pipelines and monitoring database performance to support our data-driven initiatives.
  
Additionally, you will be instrumental in data warehousing efforts, designing and maintaining a robust data warehouse to meet our analytics and reporting needs. Your expertise in database security, SQL development, and Azure services will be crucial in driving the success of our data initiatives.
  
This role is a Full-time (37.5 hours per week).     
  
About you  
   
To be successful in this role, you will be a seasoned Data Engineer with exceptional skillset and demonstrated experience in designing and maintaining a robust warehouse, expertise in database security, SQL development and Azure services.   
 
Communication and Interpersonal Responsibilities

• Work as part of a team and show professionalism
• Be punctual in both attendance at work and employee meetings
• Maintain high standards of presentation and personal grooming

  Responsibilities  

• Data Warehousing: Design, implement, and maintain a data warehouse to support our analytics and reporting needs
• Data Modelling and Mapping: Within our reporting systems such as Power BI, Google data studio and established SSAS models, collaborate with cross-functional teams to create and document data models and mappings that align with business requirements
• Security Measures: Implement and maintain robust security measures, including data security protocols, user access controls, and regular security assessments
• Data Governance: Enforce data governance policies and procedures to ensure compliance and data quality standards
• SQL Development: Utilise your expertise in SQL query and stored procedure development to extract insights from data efficiently
• ETL and Data Pipeline Development: Design and develop ETL processes and data pipelines to automate data ingestion, transformation, and loading tasks.
• Performance Monitoring and Optimisation: Monitor database performance metrics and optimize query performance and resource utilization as needed
• Documentation: Produce architecture diagrams, data flow diagrams, and relationship diagrams to communicate data infrastructure designs and configurations effectively  

Qualification/s and Experience
  
Essential

• Tertiary qualifications in Computer Science, Information Technology, or a related field  

Essential Knowledge and Experience  

• Data Warehousing and ETL/ELT: Excellent working knowledge of data warehousing and ETL/ELT principals, dimensional data modelling
• Database Security and Administration: Strong experience in database security implementation and administration
• Microsoft BI Stack: Experience using the Microsoft BI stack including Microsoft SQL Server, SSAS, SSRS, SSIS, and T-SQL
• Integration tools: Experience with integration tools (Ideally Azure Data Factory)
• Structured and Semi-structured Data: Experience in both structured and semi-structured data (JSON, Cosmos, XML)
• Communication Skills: Excellent verbal and written communication skills to collaborate effectively with cross-functional teams
• Problem Solving and Troubleshooting: Strong analytical and problem-solving skills to address data-related issues efficiently    

Desirable Knowledge and Experience  

• Power Platform: Familiarity with Microsoft Power Platform for building low-code applications and workflows
• Data Vault 2.0: Experience implementing Data Vault 2.0 methodology
• Microsoft Fabric: Knowledge of Microsoft Fabric   

Benefits 
  
Cancer Council Queensland has a collaborative, energetic, and supportive team culture, contributing to meaningful work with a tangible impact. By celebrating and fostering our individual strengths, we take on more challenging work. In turn, we lead more balanced, exciting and fulfilling lives. Our growing Non-for-Profit organisation offers employees:    

• Flexible work arrangements (Flexible Work Hours and Work from Home options) 
• ATO-Approved Salary Packaging up to the value of $18,549 per Fringe Benefit Tax year
• Recognition and Rewards Program
• Professional Development Allowance
• Corporate social events
• Team events, employee connectivity and Healthy Workplace Activities
• Cancer Council Retail shop discount  

Meet Our People
  
https://youtu.be/xQJ_HCnHXXs
  
How to apply  
  
Applications, including a current resume and cover letter, are required and should be addressed to: 

People and Culture Team
Cancer Council Queensland 
  
For your application to be considered, it is recommended that the following documentation is attached with your application:    

• Cover letter – Your cover letter should clearly indicate the position you are applying for and give a brief summary of your motivations for applying and your relevant skills and experience.
• Current Resume – Your resume should include your contact details, work experience, educational background and professional development.  

Applicants are encouraged to submit their application as early as possible as Cancer Council Queensland reserves the right to reduce the application period and/or remove the job advertisement early should a suitable applicant be found.

In line with our value of being inclusive, applications are strongly encouraged from Indigenous Australians, people from a range of cultural and linguistic backgrounds, people with disability and LGBTIQA+ individuals.

The successful applicant will be required to conduct a current National Police Certificate.
Please be advised, Cancer Council Queensland will need to collect personal information from candidates during recruitment and onboarding processes. Therefore, in submitting an application for this role, you are acknowledging that you have read, understood and agree to the terms and conditions in our Privacy Collection Statement: https://cancerqld.blob.core.windows.net/content/docs/EmployeePrivacyCollectionStatement.pdf