AddressWith more than several thousand employees in New-Zealand and main offices in Wellington, our Government customer are on the lookout for a solid BI/Data Integration Specialist with strong technical skills across Cognos, SSIS, SSRS, SSAS and Azure API management to join a team of highly skilled professionals.
About the Role:
The Data Integration Specialist is responsible for deploying, supporting and maintaining application and Data Integration layers.The Data Integration Specialist will also support enterprise business intelligence and information processing such as Data Integration, reporting and analysis utilising tools such as Azure API Management, SQL Server Integration Services, SQL Reporting Services and SQL Server Analysis Services.
Contributing to and/or leading integration work in line with the agreed system and service design. Assessing risks and taking preventative action. Measuring and monitoring applications of standards.
Managing and undertaking the administration of Oracle and SQL database servers (e.g., integrity, security, backups, resource capacity, performance and configuration) through an effective considered combination of self, in-house Database Administrators (DBA) and outsourced contracts.
Candidate:
- Good experience with SQL Server and services including SQL Server Integration Services, SQL Reporting Services, SQL cloud services and SQL Server Analysis Services and processes such as Extra Transform Load (ETL) Change Data Capture (CDC)
- Experience in other Development and Languages: .NET (C# & VB), Transact-SQL, JavaScript Object Notation (JSON), XML, JavaScript, PowerShell, HTML.
- Technical expertise in IBM Cognos business intelligence solutions.
- Demonstrated technical knowledge of Business Intelligence tools e.g., Microsoft BI Solutions, IBM BI solutions such as COGNOS and Planning Analytics, and Oracle BI solutions.
