Job Abstract

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.

Job Summary: 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.

• 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

• 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

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 to support the whole person and to recognize their time, talents, and results. Along with base compensation, other compensation is offered such as a discretionary bonus, 401k plan, health insurance, and other perks. There are several factors taken into consideration in making compensation decisions including but not limited to location, job-related knowledge, skills, and experience. At Royce Investment Partners, we apply a total reward philosophy where all aspects of compensation and benefits are taken into consideration in determining compensation. We expect the base salary for this position to range between $85,000 - $105,000 per year. Actual salary offered will depend on the candidate’s experience level and skill set.

Royce Investment Partners are pioneers in small-cap investing who’ve been actively managing portfolios since 1972. 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. In 2020, Franklin Templeton acquired Legg Mason Inc, parent company to Royce Investment Partners. Learn more about our firm by visiting us online, Royce Investment Partners.

This position is located at 745 5th Avenue, NY 10151.

#LI-US