Developer (Vba and SQL) - New York, United States - Franklin Templeton Investments

Franklin Templeton Investments

Verified Company

New York, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

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.

Key Responsibilities:

Develop interfaces to custodian banks for data transmission and reconciliation
Field requests from portfolio managers and traders for enhancements and fixes
Maintain our inhouse 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 13 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 problemsolving 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 fastpaced 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)

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