Job Search

Data Engineer

Job Title: Data Engineer
Contract Type: Permanent
Location: Sydney
Reference: 30849081
Job Published: January 30, 2020 09:16

Job Description

Globally recognised organisation are looking for a full stack DW/BI Developer to work on Enterprise DW Data Migrations, Integrations and BI Reporting. Working on the latest and greatest technologies delivering multiple complex greenfield initiatives. As the BI Specialist you will take over and establish the function, setup, own and manage the Information Management Landscape for hundreds of distributor sites across Australia.

The BI Specialist plays a critical role in the successful development and delivery of the BI Function. The role will identify where data science can create value for the business, developing and implementing BI solutions across the business.
In this role you will:
  • Work with the team to ensure the successful execution of the enterprise strategy.
  • Ensure optimal business outcomes and systems performance for all systems and applications including SAP (PI/PO), Data lake, reporting, Identity management and security and middleware etc which are the remit of this position.
  • Own the on-going enhancement, support and IT related budgetary requirements for the identified enterprise systems and technologies.
  • Support the business to maximise the value generated from such enterprise assets.
  • Accountable for identifying where data science can create value or solve problems for the business  
  • Work with the business to uncover problems, understand their data needs and implement data science solutions and data architecture to support those needs and create value
  • Develop, implement, maintain and support the newly created data lake and data warehouse on Azure landscape. 
  • Collaborate with software partners and database administrators to analyse data requirements and complex source data and data models. 
  • Implement data validation procedures, security and controls to ensure accuracy and integrity of data. Prepare data workflows and documentation. 
  • Create automated ETL routines/processes to transform source data into a standardized format ready for analysis and reporting consumption. 
  • Own the end-to-end data process; addressing areas such as data quality, data mining, machine learning and advanced modelling  
  • Create and manage entities, business rules and strategies for master data and metadata management
  • Engage with the business reporting team to help deliver concise reporting and dashboards  
  • Building Reports, Visualisations and Dashboards using MS and SAP Analytics Cloud.
To be successful for this role you will:
  • Bachelor's degree in Data Engineering, Big Data Analytics, Computer Engineering, or related field. 
  • Proven experience as a Data Engineer, Software Developer, BI Developer, ETL Developer or similar. 
  • Proficient in Python, R, and PL/SQL. 
  • Experience in Enterprise Data Warehousing, Data Store on Azure, Data Architecture for Enterprise cloud
  • Experience with SAP HANA DataWarehouse and SAP Analytics Cloud advantageous
  • Experience in Azure Data Factory (ADF), Data bricks and Spark creating multiple pipelines and activities using both Azure and On-Prem data stores for full and incremental data loads into a Cloud DW 
  • Should have experience working with Azure Data Factory V2. 
  • Experience managing Azure Data Lakes and Data Lake Analytics and an understanding of how to integrate with other Azure Services 
  • Experience with Azure SQL DW and other Azure Services pricing models. Understanding of when to use Azure SQL DW vs Azure SQL Server/DB and loading patterns to move data from blob or Azure Data lake into Azure SQL DW 
  • Understanding of the Overall solution design of how Power BI and Azure Analysis Services fits into Azure Architecture 
  • Experience in Design EDW Data Models and make optimization/improvement recommendations 
  • Experience in Power BI, Tableau , SAP Analytics Cloud
  • Excellent analytical and problem-solving skills. 
  • Capacity to successfully manage a pipeline of duties with minimal supervision. 
  • Complex problem solving abilities and advanced leadership/communication skills. 
If this role is of interest please apply or contact

Get similar jobs like these by email

By submitting your details you agree to our T&C's