Data Engineer - SAS

VAM Systems is currently looking for a Data Engineer - SAS for our Bahrain operations with the following skillsets and terms & conditions.

Location
Bahrain

Qualifications

• BE Computer Science and Engineering

Professional Training

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

Experience Required

• Experience in the following tools (3+ years):
  • 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
• 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 (e.g. 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 and Microsoft 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)

Responsibilities

• Consolidate and analyze financial data (budgets, income statement forecasts, Balance Sheet, Profit and Loss) taking into account the 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