Data Engineer - SAS

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

Qualifications

• BE Computer Science and Engineering

Professional Training

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

Experience Required

• 3+ years experience in 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 configuring/installing 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 and streaming data (Hadoop/Spark and/or Kafka/Flink)
• Experience handling semi-structured data sets (e.g. JSON, XML) (3+ years)
• Experience in C# or Java (3+ years)
• Knowledge of Banking and Finance, Financial accounting and Reporting Environment
• Expertise in writing advanced SQL Queries, Stored Procedures, and functions
• Proficiency in 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 databases, 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 company’s goals and financial standing
• Build Stored Procedures 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

Location
Bahrain