Assistant Lead Analyst (Business Intelligence)

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.