Developer to join team responsible for developing new, enhancing and supporting existing ETL surrounding on premise third-party vendor Accounting application used by multiple line of business. Minimal but possible report writing off of SQL Data Warehouse.
Translate function/nonfunction requirements into system requirements/design specs.
Design, develop ETL using SSIS.
Design, develop extracts using Geneva RSL a plus.
Design, develop workflow automation.
Help team support and maintain existing application, service and reporting architecture for lines of business.
Have a good understanding of SQL using either PL/SQL or TSQL for complex logic within stored procedures and/or user functions.
Integration testing of complex systems
Collaborate with team members on best practices, and provide recommendations on technology as well as process improvements.
Geneva RSL, preferred
Working experience in developing systems for capital markets and asset management.
Minimum 5 years of experience using SQL, SSIS, SSRS. More experience preferred
Strong troubleshooting and analysis skills
Experience with Advent Geneva and or other investment management systems preferred.
Geneva / RSL experience, preferred but not required
Experience in system conversions/migrations a plus
Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required 7-9 years of experience in software development required; experience in the securities or financial services industry is a plus. Job holder must have understanding interdependencies and business impact of future IT plans. S/he must have prior lead experience selecting and implementing vendor-specific methodologies and prior consulting experience with structured methodologies. Extensive experience with developing and supporting mainframe applications required. Job holder must have broad experience with multi-platform development tools and toolkits.