Enterprise Data Warehouse Engineer

1 month ago


Canberra, Australia Softtest pays pty ltd Full time
  • Contract start 06 March 2023 To 12 months, 12 months extensions.
  • Australian Citizen, Canberra, Sydney, Brisbane, Adelaide, Melbourne, Hobart, Hybrid(3 days in office 2 days at home) role.

Send your responses to jobs@softtestpays.com

Overview

Position Purpose

The Senior EDW engineer will advise, design, model and deliver strategic data assets to the data users and customers across NDIA. This includes updating data development documentation, providing technical guidance to developers and reviewing/approving data designs and data models.

The role will focus on collaborating with key business areas, solution architecture, and other governance committees in the development and implementation of consumable datasets to address key risks and emerging trends within these areas.

Key Responsibilities

Data Delivery

  • Develop data models based on existing modelling practice, data source and end user requirements.
  • Own the technical implementation of new data from analysis to delivery (designing and delivering data dictionary, defining the release steps, defining best practices of data modelling and review steps).
  • Provide technical leadership to the project delivery team through design reviews, advising on implementation best practices, defining and refining release process and technical workshops.
  • Review and refine the data delivery framework in order to enhance integration of new sources, performance of existing data delivery and rapid development of new subject areas.
  • Set peer review and data modelling, development and release standards.
  • Provide knowledge transfer sessions on best practices on development, data modelling, release process etc.
  • Facilitate continuous improvement measures in delivery principles, coding standards, documentation and provide training sessions to team.
  • Understand, analyse and articulate user requirements;
  • Development and maintenance of SQL analytical and ETL code;
  • Optimisation and tuning of SQL code to ensure optimal performance;
  • Development and maintenance of system documentation;
  • Collaboration with data consumers, database development, testers and IT support teams;

Technical Competencies

The Enterprise Data Warehouse Engineer must have 10+ years experience in similar roles, and is expected to have high level of competency:

  • SQL / Teradata Demonstrated competency in developing, auditing and reviewing code
  • SAS (preferred) or SQL (essential) or Python, R or Java (preferred)
  • DevOps - Ability to understand DevOps process and can use DevOps tools in accordance with the process
  • Programming High level of competency in Programming, including knowledge of supplementary programming languages such as Python
  • Version control - Ability to demonstrate knowledge of version controls and its appropriate uses
  • Excel - Competency with required systems, software and programs, including SAS and Excel
  • Other - Ability to read and interpret data models and specifications

Every application requires to address selection criteria as part of application submission.

Essential Criteria

1. The candidate should have 3+ years experience in similar roles

2. Tertiary qualifications in mathematics, statistical, computer sciences discipline or more than 3 years relevant work experience

3. Experience with updating data development based on approved data models, documentation, providing technical feedback to peers, and reviewing/creating data designs and data models

4. Experience in the review of data modelling, development and release standards



  • Canberra, Australia Hewlett Packard Enterprise Full time

    Enterprise Account Manager This role has been designated as ‘Edge’, which means you will primarily work outside of an HPE office. Open up opportunities with HPE. The Enterprise Account Manager will have one or several large accounts and act as the account lead for a substantial part of a top account. They will understands the customer’s IT and...


  • Canberra, Australia Hudson Australia Full time

    Excellent opportunity for Multiple Data Warehouse Test Analysts to join a large federal government organisation helping make positive change. - **Data Warehouse Test Analyst | Federal Government | Baseline Security Clearance**: - **Canberra location (preferred) | Some WFH - No Remote | Multiple roles**: - **Market Rates ($100-125/hour) | 12+12+12 month...

  • Data Analyst

    1 month ago


    Canberra, Australia Paxus Australia Pty Ltd Full time

    Posted 01 November 2023 - Salarypaxus pays weekly - LocationCanberra - Job type Contract - DisciplineBI + Data Analytics - Reference263575 **Job description**: **What we're looking for**: - Identify appropriate data sources and conduct thorough analysis for documentation. - Develop and validate access views for efficient business processes. - Manage...

  • Technical Lead

    4 weeks ago


    Canberra, Australia Experis Full time

    **Job Overview**: - ** Initial contract duration**:12 Months - ** Extension term**:12 months - ** Number of extensions**:2 - ** Location of work**:ACT - ** Security clearance**:Must have Baseline **Deliverables**: - Deliver detailed solution design, and technical design documentation as required understanding the solution architecture and data...


  • Canberra, Australia Australian Government Department of Defence Full time

    $108,195 - $122,044 (plus Super) - Brindabella Park - ACT, Sydney CBD - NSW **The Role** The Directorate of Maritime Engineering & Logistics (DMEL) is seeking a highly skilled and motivated EL 1 Business Intelligence Manager to join our dynamic data team. You will be responsible for overseeing the development and implementation of data driven strategies to...


  • Canberra, Australia Finite IT Recruitment Full time

    Canberra, ACT ( Interstate Candidates are encourage to apply)Long-term Contract (12 Months + 2 X 12 Months extension options) Must be Australian Citizen with minimum of Baseline Clearance FinXL is recruiting for talented and experienced Data Warehouse Test Analysts to join one of our clients in Canberra. This exciting opportunity will have you working as...


  • Canberra, Australia Hughes and Jones Consulting Full time

    Australia's leading cyber security intelligence consultancy continuing to expand cyber security operations, threat analytics, security integration and engineering capability for large enterprise projects. Fast-paced dynamic environment offering excellent career advancement opportunities and training structure to support ongoing certification and further...


  • Canberra, Australia Kinexus Australia Full time

    **ABOUT THIS ROLE** Data Centre Technician (Multiple) - RFQ-ASD-42-2023 - SOW 1 - Original Technology Foundation - High Side Infrastructure Group (TF-HSI) within the Australian Signals Directorate (ASD), will deliver cutting edge capabilities to support ASD's Signals Intelligence and Offensive Cyber Capabilities. These capabilities consists of a combination...


  • Canberra, Australia Unison Consulting Pte Ltd Full time

    Develop and implement data pipelines for ingesting and collecting data from various sources into a centralized data platform. Develop and maintain ETL jobs using AWS Glue services to process and transform data at scale. Optimize and troubleshoot AWS Glue jobs for performance and reliability. Utilize Python and PySpark to efficiently handle large volumes of...


  • Canberra, ACT, Australia Randstad Australia Full time

    12 month engagement + extensionsAbility to obtain a NV1 security clearance Candidate must be in CanberraCandidate must be an Australian citizen The role Seeking to engage suitably qualified and experienced Enterprise Integration (EI) Developers to deliver and support a range of ICT projects. The EI Developers will be required to develop efficient, scalable...

  • Project Engineer

    3 weeks ago


    Canberra, Australia Australian Government Department of Defence Full time

    The Role The Land Intelligence Surveillance and Reconnaissance and Electronic Warfare (LISREW) Program is seeking an engineer to support the capability management of the Intelligence and Information Warfare (I&IW) capability. In this role, the engineer will work closely with the program systems engineer and AHQ stakeholders to develop and propose...


  • Canberra, Australia SOS Recruitment Full time

    Job Description 12-month contract  | Canberra Location | $52.14 - $64.76 per hour plus 11% Superannuation  OVERVIEW Our Federal Government client is currently seeking an experienced Data Analyst and a Data Engineer to join their team at the APS5/6 level. The level will be determined based on skills and experience. Within the Data Analyst role you will...

  • Data Modeller

    4 weeks ago


    Canberra, Australia Experis Full time

    **DATA MODELLER** **Location**:Camnerra preferred **Contract**:12 months **Extension**: 2 x 12 months **Security**: Minimum Baseline **Responsibilities**: - Develop data management design artifacts, including developing mapping documents for builds in support of business processes and objectives. - Develop and/or direct the creation of efficient,...


  • Canberra, Australia Forescout Technologies Inc Full time

    What We Do Managing cyber risk, together – Today the modern enterprise is an Enterprise of Things. We are on a mission to secure the Enterprise of Things with active defense by identifying, segmenting, and enforcing compliance of every connected thing in a real-time and at scale. Our unified security platform enables enterprises and government...


  • Canberra, Australia Virtuoso Consulting Full time

    **Enterprise Computing Hybrid Cloud Specialist**: *** Australian Citizens with Baseline Clearance only ** No PR/Work Visa holders**: **RFQ closing date***: - Wednesday, 21 February 2024 11:59pm, Canberra time **Buyer** - Department of Health and Aged Care **Estimated start date***: - Monday, 11 March 2024 **Initial contract duration - **12...


  • Canberra, Australia Hughes and Jones Consulting Full time

    Australia's leading cyber security intelligence consultancy continuing to expand cyber security operations, threat analytics, security integration and engineering capability for Government and Defence projects. Fast-paced dynamic environment offering excellent career advancement opportunities and training structure to support ongoing certification and...

  • Data Analyst

    1 month ago


    Canberra, Australia Leidos Full time

    Company Description The first thing you learn at Leidos Australia is to leave current thinking at the door. Our aim is to make the world a safer, healthier and more efficient place, but we won’t get far using existing ideas. Due to our ongoing success, the Leidos family is growing rapidly across Melbourne and Canberra. This year is set to be an amazing...


  • Canberra, Australia CYOS Solutions Full time

    **Application closing date**: Friday, 28 July 2023 - 11:59pm, Canberra time **Estimated start date**: Monday, 04 September 2023 **Location of work**: ACT **Length of contract**: Until 30 April 2024 **Security clearance**: Must have Baseline **Rates**: $50 - $65 per hour (inc. super) In response to the recently passed Workplace Gender Equality Amendment...


  • Canberra, Australia Firesoft People Full time

    Senior Software Engineer (.Net/C#)Canberra/Sydney/Melbourne$180k + Super*Must be an AU citizen and have existing TSVA security  clearances to be considered Our client is well placed to provide a number of platform-related services covering a range of disciplines including networking, data centre, compute, core Internet services and cloud platforms....


  • Canberra, Australia Australian Signals Directorate (ASD) Full time

    Total Salary Package: $93,806.96 - $133,322.80 (plus 15.4% super) - Canberra - ACT **The Role** The Digital Workplace Services (DWS) section within Enterprise Technology Division is responsible for the delivery and support of corporate ICT platforms to ASD and its customers. This includes enterprise-scale collaboration tools, information and records...