Finance Data Engineering Analyst

VAM Systems

Key Objectives

• Support the finance team on data and analytics activities and Dataware House (DWH) based on a profound knowledge of banking, financial reporting, and data engineering.

Analytical/Technical Skills:

• Understanding finance and risk reporting systems/workflow with previous experience participating in system implementation is desirable.
• Hands-on experience on MS Excel
• Prior project management/stakeholder management is desired

Responsibilities

• Coordinate and Interact with the finance business partner to support daily finance data analysis, hierarchical mappings, and understanding (root cause analysis) of identified data issues.
• Exceptional comprehension of finance, risk, and data warehousing to guarantee accurate and reconciled reporting (e.g., balance-sheet exposure, profit and loss).
• Mastering the Intersection of Finance, Data Analysis and Data Engineering.
• Conduct review of data quality and reconciliations for finance reports and maintenance of reporting logic/programs.
• Support the finance team in ad-hoc requests and organizing data for financial/regulatory reports, data mapping and performing UAT.
• Ensuring the consistency of bank's data architecture, data flows, and business logic in accordance with Data Management guidelines, development standards, and data architecture by working closely with Finance and data Engineering teams to identify issues and develop sustainable data-driven solutions.
• Expertise in writing and documenting complex SQL Query, Procedures, and functions creating algorithms that automate important financial interactions and data controls.
• Experience in handling SAS ETL jobs, data transformation, validation, analysis and performance tuning.
• SAS skillset, with Strong 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