Location: Perth (candidate must be Perth based or willing to relocate)Preferred start date: ASAPEnd date: 6 months with a option of extensionWorking hours per week: 37.5Our client are after a SQL fullstack BI Engineer/ Data Engineer with Experience in the MS BI stack and Azure Data tools, for a 6 month+ engagement for an Immediate start.Requirement:SSIS Integration: (Considerable Experience)
- Design, develop, and maintain SQL Server Integration Services (SSIS) packages for efficient ETL processes.
- Integrate and transform data from various sources into SQL Server databases.
- Integrate external data sources by consuming APIs and implement data pipelines for seamless data flow.
- Leverage Azure Data Factory (ADF) for orchestrating and automating end-to-end data workflows in the cloud.
- Implement best practices for deploying and managing data solutions in Azure.
- Interact with Power BI RESTful APIs and other external APIs for seamless data extraction and integration.
- Implement authentication methods, such as OAuth, to securely connect to various APIs.
- Use JavaScript, Node.js, Python, or C# to interact with Power BI APIs, SSIS, ADF, and other integration tasks.
- Apply scripting and automation for enhanced efficiency.
- Utilise PowerShell scripting for automation tasks related to Power BI, SSIS, and ADF (if applicable).