Educational requirements: Bachelor
English requirements: Competent English
Requirements for skilled employment experience for years: 1-3 years
Required residence status: Temporary visa, Permanent resident, Citizen
Accept remote work: unacceptable
The Role:
This position is working as a senior to develop and manage data workflow, pipelines, ETL processes and load assurance reporting across the organisations Data Platform. Working in close partnership with larger data teams, data stewards and technical and business stakeholders, this position ensures that the technology supports a scalable, relatable and manageable technical environment.
Responsibilities:
Development and migration of scalable data packages and pipelines using Microsoft on - premise and Azure technologies
Derive data management structures to support consistency of information retrieval, analysis and interpretation, throughout the organisation.
Develop alerting, reporting and dashboards to monitor ETL pipelines and resolve incidents as required to ensure the integrity of the platform
Maintain and apply up to date, specialist knowledge of data concepts, data modelling techniques and design principles.
Assisting to develop design standards and techniques and ensure enterprise reuse, consistency and compliance across the design, development, testing and ongoing support of the Data Platform.
Implement devops practises within the current environments to streamline development and deployment activities.
Undertake database performance tuning activities to ensure ETL processes complete within defined timeframes
Necessary Skills:
Understanding of Business Intelligence as well as other aspects of reporting/analytics is required
Microsoft Azure Certification is highly desired.
Demonstrated experience in implementing devops practices, including cloud automation, supporting and maintaining Azure DevOps functions such as CI/CD, ARM and pipelines.
Development experience, designing, developing and supporting various data technologies including, Azure Data Factory, Azure Databricks, MS SQL Server, Azure Synapse, SSAS, SSIS, SSRS, Power BI, Python or R.
Ability to work with a range of diverse data sets including operational databases, CDC, CSV, XML, JSON etc.
Experience working in big data environments and big data file formats including Parquet, Avro etc.
Demonstrated experience working on Business Intelligence platforms with related design and development tools is essential.
Strong experience building data marts using the Kimball methodology.
