Sql Full Stack Bi Engineer/ Data Engineer

Location: Perth (candidate must be Perth based or willing to relocate)

Preferred start date: ASAP

End date: 6 months with a option of extension

Working hours per week: 37.5

Our 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.

ADF Cloud Solutions: (Desirable)

• 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.

API Integration: (Desirable)

• 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.

Programming Languages: (Desirable)

• 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.

Power Shell Scripting: (Desirable)

• Utilise PowerShell scripting for automation tasks related to Power BI, SSIS, and ADF (if applicable).