Database Developer

A highly technical and motivated professional with expertise in designing and developing data solutions for financial applications, reporting, and analytics. This role involves developing and maintaining data transformation processes for Janney's Data Warehouses, and enhancing data movement between on-premise and cloud-based data stores to ensure seamless and efficient data integration and accessibility.

This role offers a hybrid work model with a minimum of one day per week in our Philadelphia headquarters, subject to onboarding, performance milestones, and manager's discretion.

What you are good at:

• Proficiency in PostgreSQL database development, including database design and implementation of data storage systems.
• Advanced knowledge of SQL Server applications, databases, and related tools.
• Strong understanding of on-premise and cloud data architecture concepts, best practices, and methodologies.
• Experience with Snowflake cloud-based data warehouse is a plus.
• Excellent technical documentation skills.
• Clear and efficient communication skills, both with technical peers and management.

 What you have:

• Bachelor's degree in computer/information sciences or related fields.
• Minimum of five (5) years of hands-on experience as a Database Developer, with a proven track record of designing, developing, and maintaining high-performing and reliable database systems.
• Strong proficiency in PostgreSQL database development, particularly in areas such as database design, query optimization, and implementation of robust data storage systems tailored to application needs.
• Advanced knowledge of SQL Server, including in-depth experience with tools like SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
• Experience with Snowflake cloud-based data warehouse, leveraging its architecture for scalable and efficient data management preferred.
• Familiarity with AWS or similar cloud services and understanding how to utilize them for modern data solutions.
• Proficiency in at least one programming language like C#, Java, or Python for data analytics and scripting tasks is a significant advantage.
• Strong technical documentation skills to create clear, concise, and comprehensive documentation for systems, processes, and data flows.
• A demonstrated ability to stay current with emerging technologies, industry trends, and best practices to continuously enhance the organization’s data capabilities.
• Clear and efficient communication both with technical peers and management.
• Previous experience working in the wealth management or financial services sector is preferred, with an understanding of industry-specific data challenges and requirements.

Why work for us?

Benefits: Janney believes that its employees are the key to what makes a great company. Although work makes up a large portion of an employee’s life, we believe that a balance between work and non-work activities is essential to maintain quality performance and a positive work atmosphere. We offer a competitive package including Paid Paternal Leave, generous Paid Time Off, eligibility for a $2,000 referral bonus and Professional Development Assistance Plan designed to help you make the most of your life at work and at home—today and in the future. Explore further.

Janney is an award-winning full-service financial services firm committed to understanding our clients' needs and providing advice beyond investments. We are equally committed to building a diverse workforce and inclusive culture where employees can use their talents to thrive and grow professionally with the firm. Fostering a positive workplace experience remains a top priority. We’ve earned the Great Place to Work® certification, which recognizes employers that create an outstanding employee experience. Based entirely on what current employees say about their experience working at Janney, this prestigious recognition underscores our commitment to our people and culture.  People are our strongest asset. We recognize that when our team members thrive, our firm is more successful.