Key skills
ETLMS SQL ServerOracleSQLSQL Server
About this role
Role Overview
- Implement, configure, and customize the Vermilion Reporting Suite (VRS)
- Design and manage data integrations between VRS and external systems (e.g., SQL Server, Oracle, Markit EDM, Aladdin, APIs, XML/JSON)
- Develop, test, and maintain automated reporting workflows and batch processes
- Create high-quality reports and templates (PDF, MS Office, HTML) for different asset classes
- Perform system testing, data validation, and troubleshooting
Requirements
- 8 to 10 years of experience implementing enterprise software
- Strong knowledge of SQL (MS SQL Server and/or Oracle)
- Experience with ETL processes and database debugging
- Experience with APIs and data formats (XML, JSON)
- Deep knowledge of the Vermilion Reporting Suite (VRS), including modules, APIs, and report development
- Understanding of performance measurement, client reporting, and portfolio data
Tech Stack
- ETL
- MS SQL Server
- Oracle
- SQL
Benefits
- At Capco we promote an inclusive culture
- We value diversity in all its forms
- We participate in a variety of inclusion initiatives and social responsibility activities