Assistant Lead Analyst (Business Intelligence) (Ref 26210a)

Responsibilities
. Work with stakeholders to understand needs for data structure, availability and accessibility
. Support the translation of data needs into technical system requirements
. Advise on latest technologies, strategies, and products in database and data processing software
. Recommend types of data and data sources needed
. Support the building of data flow channels and processing systems to extract, transform, load and integrate data from various sources
. Develop complex code, scripts and data pipelines to process structured and unstructured data near real-time
. Develop prototypes and proof of concepts for the selected solutions
. Support the identification of data sources (both internal and external)
. Perform operational ad-hoc data provision to extract/load data based on stakeholders requirements using ETL tools such as Informatica
. Research hardware and software needs to support selected solutions
. Gather data from internal systems and external sources
. Enter information into data collection systems
. Clean databases from duplicated, outdated or irrelevant information
. Perform data validation and quality control checks
. Mine data to identify trends, patterns and correlations
. Develop solutions and recommendations to address information need
. Assist with integration of data systems into existing infrastructure
. Develop tools to improve data flows between internal/external systems and the data warehouse
. Automate data collection and analysis processes, data releasing and reporting tools
. Test data system configurations and perform regular tuning to increase efficiency
. Facilitate data cleansing, enrichment and data quality improvements
. Enable searching, data visualisation, and advanced analytics functionality

Requirements
. Degree, Information Technology, Computer Engineering or equivalent
. Seven (7) years experience in an IT Infrastructure / Operations Role
. Experience with Cloud platforms (IaaS, PaaS)
. Operating system administration and related services (Windows Server, Linux)
. Infrastructure-as-code and cloud automation (APIs, Cloudformation, Chef, Ansible, Puppet)
. DevOps development and platform support (Docker, Container Services)
. Experience with programming / scripting (Batch, VB, PowerShell)
. Networking experience and troubleshooting (TCP/IP, DNS, routing, switching, firewalls, LAN/WAN, DHCP)
. The ability to work towards strict and conflicting deadlines be able to plan and prioritise in an environment with multiple stakeholders.
. Good interpersonal skills, a detail-oriented & flexible person who can work across different areas within the team.

Licence no: 12C6060