PostgreSQL Database Developer

Skills

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.

Description

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

Responsibilities

• 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.
• Key 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.