Developer (VBA and SQL)

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.

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 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.

Our Firm:

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

857606