Data Engineer

Overview

VAM Systems is a Business Consulting, IT Solutions and Services company.

VAM Systems is currently looking for Data Engineer  for our Bahrain operations with the following skillsets and terms & conditions:

Qualification

 

·        BE Computer Science and Engineering

 

Professional Training

 

·       SQL Development, SAS EG, SAS DI, Object-orientated Programming (e.g. C#, Java)

 

Experience Required:

 

Experience in the following tools (3+ years)

 

o   SAS Management Console

o   SAS DI, SAS Enterprise Guide

o   Base SAS

o   SAS Web Report Studio, SAS Delivery Portal, SAS OLAP Cube Studio, – SAS Information Maps, SAS BI

o   SAS Stored Process, SAS Datasets & Library

 

·        Experience to configure/install applications in the servers(windows/Linux/Unix) and

basic knowledge of DNS, Ports, and Firewalls (3+ years)

·        Experience managing and further developing distributed systems and

clusters for both batch as well as streaming data (Hadoop/Spark and/or Kafka/Flink)

·        Experience in handling semi-structured data sets(eg. JSON,XML) (3+ years)

·        Experience in C# or Java (3+ years)

·        Banking and Finance, Financial accounting and Reporting Environment

·        Expertise in writing advanced SQL Query, Stored Procedures and functions

·        ETL Tools SAS platform Tools like SAS DI / SAS Enterprise Guide andMicrosoft SQL Server.

·        Sound understanding of Financial Reporting(Balance Sheet/Profit and Loss) and Risk Reporting.

·        Developing within database and specifically Microsoft SQL Server and/or Oracle (minimum of 3+ years required).

 

Responsibility

 

·        Consolidate and analyze financial data (budgets, income statement forecasts ,Balance Sheet, Profit and Loss) taking into account company’s goals and financial standing

·        Build Stored procedure and ETL Jobs to Reconcile transactions by comparing and correcting data

·        Contribute to data warehouse design and components, relational database management systems, and database design solutions

·        Develop SQL Server T-SQL procedures/functions for batch processing as well as reports, in line with user requirements

·        Build SAS EG,SAS DI jobs

·        Research and resolve discrepancies in financial data ,Manage the month-end close process.

Skills

 

·       Solving Complex Problems

·       Testing and Troubleshooting

·       Regulatory Compliance

·       Financial Reporting

·       ETL/ETT/ETM Tools and Process

·       Risk Management

·       Data Warehouses

·       Data Marts

·       Balance Sheet,Profit & Loss,Market Risk

·       Data Modeling

·       SAS, SAS BI, MS SQL Server, T-SQL in data warehousing/batch

 

Domain  : Bank

 

Years of Experience 5 + years

 

The selected candidates shall join VAM Systems – Bahrain and shall be deputed to one of the leading Banks in Bahrain.