Database Developer

Janney Montgomery Scott • Philadelphia, PA

425d • Hybrid

About The Position

The Database Developer at Janney Montgomery Scott LLC is a highly technical role focused on designing and developing data solutions for financial applications, reporting, and analytics. This position involves maintaining data transformation processes for the company's Data Warehouses and enhancing data movement between on-premise and cloud-based data stores to ensure efficient data integration and accessibility. The role supports a hybrid work model, requiring at least one day per week in the Philadelphia headquarters.

Requirements

• Bachelor's degree in computer/information sciences or related fields.
• Minimum of five (5) years of hands-on experience as a Database Developer.
• Strong proficiency in PostgreSQL database development, including database design and query optimization.
• Advanced knowledge of SQL Server, including experience with SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
• Experience with Snowflake cloud-based data warehouse is preferred.
• Familiarity with AWS or similar cloud services.
• Proficiency in at least one programming language like C#, Java, or Python.

Nice To Haves

• Experience in the wealth management or financial services sector is preferred.
• Strong technical documentation skills.

Responsibilities

• Design, develop, and maintain high-performing, reliable database systems and efficient SQL code.
• Build and improve data integration processes between on-premise and cloud data stores.
• Analyze and resolve database performance issues, ensuring data integrity and security.
• Lead efforts to optimize database performance.
• Work closely with cross-functional teams to understand data needs and deliver innovative solutions.
• Provide off-hours production support on a rotational basis.

Benefits

• Paid Paternal Leave
• Generous Paid Time Off
• Eligibility for a $2,000 referral bonus
• Professional Development Assistance Plan

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Securities, Commodity Contracts, and Other Financial Investments and Related Activities
• Education Level: Bachelor's degree