Senior Consultant (SAS)
Core
Guide clients through the preparation, structuring, and validation of data sourced input from their enterprise Data Warehouse to support the integration of proprietary financial software.
Role type
Senior Consultant (Data Integration & SAS-to-SQL)
Builds
Data integration workflows for financial risk and regulation software
Domain
Financial Risk, Regulation, Data Warehousing
Required skills
Advanced SQL, SAS programming, Data Warehouse management, Data transformation, Data quality analysis, Client stakeholder management, Financial domain knowledge
Preferred skills
Python, Large-scale data ecosystem experience, Optimization of data logic
Technologies
SQL, SAS, Python, Data Warehouse
Responsibilities
Extract and transform data from client Data Warehouses using SQL; Analyze and adapt existing SAS code to align with project needs; Collaborate with client stakeholders to understand data requirements and business logic; Support the configuration and testing of data inputs for the internal financial software platform; Identify data quality issues and propose remediation steps; Produce clear documentation including data transformation rules and validation procedures.
Seniority
Senior, hands-on IC