- Code solutions/enhancements for Sylvan, SS&C’s performance and attribution platform used throughout AGI
- Code solutions/enhancements for the Sylvan job stream that runs nightly to load IBOR and benchmark data in Sylvan
- Build stored procedures, views, and process to access data with the Sylvan database as well as IBOR data warehouse
- Work within a global IT team, supplying secondary support for Sylvan Job stream and IBOR Sylvan loads on running in Autosys platform
- Build Powerbase reports on top of the Sylvan platform to enhance existing Sylvan reporting capabilities.
- Detailed documentation of processes/solutions developed
- Extensive knowledge of ETL and other data loading solutions
- Extensive knowledge if Autosys platform and build automated solutions within platform
- Ability to support and problem solve existing AutoSys jobs
- Extensive experience with MS SQL Server development/support:
- SQL| T-SQL | architecture and database design
- Stored Procedure development
- Advance queries
- Performance tuning – indexing
- Database Architecture
- Working knowledge of Microsoft’s TFS platform
- Detailed experience on Visual Studio 2019, and PERL / Python
- Working knowledge of Software Development Life Cycle - SDLC
- Experience developing under Agile/SCRUM, Iterative, waterfall managed projects
- Good working knowledge of Data Analysis and financial formulas/equations
- Strong understanding of relational databases (SQL Server) including analytical functions
- Good understanding of investment instruments (stocks, bonds, derivatives.)
Experience with Sylvan platform an asset
- + 5 years development experience within financial sector
- Excellent oral & written communication skills