NOTE: There will be an assessment test covering both SQL and Python.
Job Description:
Ability to understand the business drivers related to variety of financial products and translate the business rules requirements to data requirements and work with data provides to source the data from source systems, transform the data from sourced data to data Mart with complex transformation and enrich the data using reference and market data.
Qualifications: • Customer Facing skills • Data Analysis • Python • Strong SQL • Data profiling to establish the Data Quality Rules • Data Integration Mapping experience and the ability to define the data requirements • Ability to develop data lineage spreadsheets from existing system/tactical solution. • Excellent SQL sills to write the data queries to test and validate the transformations and Business rules • Excellent Business Analysis skills
Financial product knowledge experience to source the data for: • Equities • Securities • Repos • Reverse Repos • Mortgage Instruments • Wholesale and retail Deposits • Debt • Any Basel Implementation Experience