Description

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 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, 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

Key Skills

Education

Any Graduate