Data Engineer-Bahrain (Onsite)

Experience: 3-6 yrs

Qualification: BE Computer Science and Engineering

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

Requirement

• Knowledge in banking and Finance, Financial accounting and Reporting Environment
• Expertise in writing advanced SQL Query, Stored Procedures and functions
• Hands on experience with ETL Tools SAS platform Tools like SAS DI / SAS Enterprise Guide and Microsoft SQL Server.
• Sound understanding of Financial Reporting(Balance Sheet/Profit and Loss) and Risk Reporting.

Roles & Responsibilities

• Configure/install applications in the servers(windows/Linux/Unix) and basic knowledge of DNS, Ports, and Firewalls
• Developing within database and specifically Microsoft SQL Server and/or Oracle
• Managing and further developing distributed systems and clusters for both batch as well as streaming data (Hadoop/Spark and/or Kafka/Flink)
• Handling semi-structured data sets(eg. JSON,XML) 
• 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.

Experience in the following tools

• SAS Management Console
• SAS DI, SAS Enterprise Guide
• Base SAS
• SAS Web Report Studio, SAS Delivery Portal, SAS OLAP Cube Studio, SAS Information Maps, SAS BI
• SAS Stored Process, SAS Datasets & Library

Skills

• Experience in C# or Java 
• 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

Location: Bahrain onsite

Candidates willing to move to Bahrain can apply