Postgre SQL Developer

Job Title: PostgreSQL Database Developer

Location-Type: Hybrid (1 day a week onsite in Philadelphia, PA 19013)
Start Date: ASAP
Duration: 3-6 month contract to hire (Must be a US Citizen or Greencard Holder)

Must Haves

• Biggest focus is PostgreSQL(subject matter expert)
• Writing scripts, managing scripts - not just being a DBA for security
• #1 language: Python
• #2 language: C# (if no python experience)

Nice to Haves

• Experience with the cloud for strategic planning
• Financial background preferred

Job Description

Summary:
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.
Essential Qualifications:

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

Required Education:

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

Required skills/competencies:

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

This role values innovation and collaboration, providing opportunities to work on various projects and emerging technologies. This position is an excellent fit if you are passionate about advancing your expertise in PostgreSQL, SQL Server, and Snowflake while contributing to a dynamic and forward-thinking environment!