DATA ENGINEER

Minds United

Job Description:

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

At least 3 years experience:

-Experience in developing within a database and specifically Microsoft SQL Server and/or Oracle?

- 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)

-Hands-on 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)

-Programming experience in C# or Java (3+ years)

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

-Experince 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

Job 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 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.

Competencies

-Solving Complex Problems

-Testing and Troubleshooting

Skills

-Regulatory Compliance

-Financial Reporting

-ETL/ETT/ETM Tools and Process

-Risk Management

-Data Warehouses

-Data Marts

-Balance Sheet,Profit & Loss,Market Risk

-Data Modeling

Technology Tools Required SAS, SAS BI, MS SQL Server, T-SQL in data warehousing/batch