Database Developer

Database DeveloperWe 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/week in the office.Summary: 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.Essential Qualifications: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.Required Education:Bachelor's Degree in computer/information sciences or equivalentAdditional Requirements: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, DynamoDB, 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 MongoDB 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!