Database Developer

We are looking for a Database Developer for a full‑time, direct‑hire position located in Philadelphia, Pa – this is a hybrid role with 1–2 days per week in the office.

A highly technical and motivated professional with expertise in designing and developing databases and creating complex reporting and analytical solutions for financial applications. 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 position is located in our Philadelphia, PA headquarters with an option for hybrid work with a minimum one day per week in the office;

based upon successful onboarding, performance, and manager's discretion.

• Advanced knowledge of SQL Server Application and Database and related tools (SSIS/SSRS).
• Profound knowledge and hands‑on experience in Snowflake Platform Architecture (this should include actual Snowflake Development/DBA experience).
• Strong understanding of on‑premise and off‑premise data architecture concepts and best practices, methodologies for design, development, testing, and development and testing tools.
• Minimum of Five (5) years’ experience as a Database Developer.

• Bachelor's Degree in computer/information sciences or equivalent.

• Experience using Snowflake Data Cloud required. Hands‑on development experience with Snowflake features such as Snow SQL;
  Snow Pipe;
  Python;
  Tasks;
  Streams;
  Time travel;
  Zero Copy Cloning;
  Optimizer;
  Metadata Manager; data sharing; and stored procedures.
• Experience with cloud data management platforms. AWS work experience preferred, including EC2, RDS, Dynamo
  
  DB, and Lambda, particularly in database and data management contexts.
• Experience in wealth management or financial services is preferred.
• Knowledge of additional database technologies such as Postgres, MySQL, and Mongo
  
  DB is a plus.
• Excellent technical documentation skills.
• Design, develop, and maintain efficient and reliable SQL code.

This role values innovation and collaboration, providing opportunities to work on various projects and technologies. This position is an excellent fit if you want to advance your SQL Server and Snowflake development skills in a dynamic and competitive environment!

If this is a role that interests you and you’d like to learn more, click apply now and a recruiter will be in touch with you to discuss this great opportunity. We look forward to speaking with you!