The BI specialist will be a techno functional support team member for the Business Intelligence cluster under IT BAU team.
He / she is responsible for ensuring system availability and timely deliverables for BI applications like SAS and Hadoop.
The BI specialist, as the admin cum analyst expert within the IT team, will be the support staff who needs to closely co-
ordinate and work with various team like Tech Infra, application services, solutioning, project and Business units in bank.
He / she follows up to resolve issues reported by users and performs impact analysis on projects / enhancements that will impact the BI applications.
This role is based in Singapore.
Roles / Responsibilities
Contribute to business requirement review for technical implementation as a subject matter expert for IT to ensure SDLC standards are met
Translate user requirements into functional and technical solutions for technical design team and developers
Conduct review of technical and functional solutions from enhancement / project team to ensure they conform to IT standards
Respond to and resolve issues by finding the root cause of the problem
Respond on time to the queries raised by various business units
Provide timely updates regarding production status and progress of issue resolution
Perform impact analysis of enhancements / projects that will impact supported systems
Responsible to provide BAU support for BI platforms SAS and Hadoop
Responsible to provide BAU support for financial fraud surveillance system in bank
Responsible to provide operational support and ensure SLI of system availability, online and batch deliverables.
Responsible for development, administration and troubleshooting on Hadoop technologies like HDFS, MapReduce, Hive, Sqoop, HBase, Kafka, Spark, etc.
Responsible to Monitor, Administrate and manage the Cloudera CDH Hadoop cluster in the bank
Fine tune applications and systems for high performance and higher volume throughput
Preferably 5 years of relevant experience in IT Finance within a banking / financial services industry
Experience in Financial Fraud Surveillance modules like SAS-ESP or Mantas is a must
Experience with Hadoop and SAS required
Experience in SAS tools Base SAS, Enterprise Guide, Data Integrator, Enterprise Miner, SMC are required
Experience with Hadoop Ecosystem including Spark, Storm, HDFS, Hive, HBase and other NoSQL databases
Familiar with programming paradigms such as distributed architectures and multi-threaded program design
Understanding Partitions, Hive Query optimization, Bucketing etc.
Experience in Sqoop for moving data between RDBMS and HDFS
Solid understanding of BigData, Datawarehousing, DataLake, Teradata, Oracle or other relational databases required
Has working knowledge in Unix / Unix scripting
Knowledge of .NET, Python, Scala, and Java programming and development experience a plus
Experience with MQ technologies (TIBCO EMS, Kafka, RabbitMQ) is a plus.
Understanding of ETL design using ETL tools or native scripts to extract data from heterogeneous data sources strongly preferred
Incident, problem and service outage management
Data Source Configuration and Maintenance
Experience with additional Business Intelligence tools a plus
Experience in developing dashboards and reports required
Strong system and application administration knowledge required
Experience building data visualization to user specification
Server Performance, capacity, utilization monitoring and Health monitoring
Strong analytical and statistical knowledge preferred