- LOCATION:NONE
Royce Investment Partners, an affiliate of Franklin Templeton, is hiring a VBA/SQL Programmer. In this position, you will work on a small team which maintains and supports in-house software used by portfolio managers, traders, and others at the firm. You will also do support for and code interfaces to our order management system.
This VBA/SQL Programmer position is responsible for developing and maintaining VBA/SQL scripts and applications to automate tasks and enhance efficiency within various departments. The position also involves supporting the daily activities of the portfolio managers and trading desk.
Job Summary
Key Responsibilities
- Develop interfaces to custodian banks for data transmission and reconciliation
- Field requests from portfolio managers and traders for enhancements and fixes
- Provide phone and email support to equity trading desk using Charles River
- Maintain our in-house accounting software
- Support monthly and quarterly reporting cycles
- Monitor alerts on daily automated batch jobs and respond to issues
- Create documentation to accompany assigned software projects
Technologies Used
Below are among the technologies Royce uses
- SQL (MS SQL Server)
- MS Access VBA
- MS Office programming using VBA (Excel, Outlook)
- SSRS
- C#
- Charles River OMS
- Equity Trading, FX Trading, ETF,
- SMA
- FIX and SWIFT protocols
- Windows shell
- programming
- Unix shell utilities
- (sed/awk/grep/etc)
- Python
- AutoHotKey
- Tableau
- Bloomberg Data License (Bulk Data, Per Security) and Bloomberg Excel AddIn
Ideal Qualifications and Skills Desired
Job Requirements
- Bachelor's Degree in Computer Science, Information Technology, or related field
- 1-3 years' experience in a technology role
- Experience in VBA and strong grasp of SQL preferred must have some prior programming or coding experience
- Proficiency in some of the other technologies mentioned in the previous section desired
- Ability to pick up new programming languages quickly
- Excellent problem-solving skills and attention to detail
- Strong communication and collaboration skills with the ability to work effectively in a team environment with other programmers
- Ability to manage multiple priorities and meet deadlines in a fast-paced environment
- Ability to read and write in a professional manner and interact with senior leaders
- Ability to work out of our New York City office in Midtown with 3 days in the office per week (hybrid, partially remote)
Royce Investment Partners offers employees a competitive and valuable range of total rewards-monetary and
non-monetary-designed
Our Firm
We specialize in actively managed strategies that invest in the broad and diverse small-cap universe with unparalleled knowledge and experience gained through more than four decades of investing.
Royce Investment Partners are pioneers in small-cap investing who've been actively managing portfolios since 1972.
In 2020, Franklin Templeton acquired Legg Mason Inc, parent company to Royce Investment Partners.
This position is located at 745 5th Avenue, NY 10151.
#LI-US