Sr SQL Developer - New York City, NY(Hybrid)

SoftPath Technologies - New York, NY

Full-time - Senior

New York, NY

Web Search Portals, Libraries, Archives, and Other Information Services

About the position

The Sr SQL Developer will be responsible for designing, developing, and optimizing database solutions that support investment banking operations. This role involves collaboration with cross-functional teams to ensure that data architecture aligns with business needs and regulatory requirements, particularly in financial reporting.

Responsibilities

• Design, develop, and optimize complex SQL scripts, stored procedures, packages, and functions.
• Develop and maintain conceptual, logical, and physical data models that support business requirements and regulatory standards.
• Implement and manage data integration processes using cloud-based tools and services.
• Utilize expertise in investment banking to ensure financial reporting requirements are met efficiently and accurately.
• Collaborate with stakeholders to understand reporting needs and translate them into technical specifications.
• Optimize database performance and troubleshoot issues to ensure high availability and reliability.
• Stay updated with emerging technologies and best practices to improve data management processes.
• Document data models, integration processes, and reporting methodologies for future reference.

Requirements

• 10+ years of experience in database development.
• Extensive experience with SQL development.
• Proven experience in data modeling and database design.
• Experience in investment banking financial reporting is required.
• Experienced in Reporting tool QuickSight.
• Experienced in messaging (near real-time) data processing tools like Kafka, other tools are fine.
• Strong analytical and problem-solving skills.
• Excellent understanding of database management systems (DBMS).
• Proficient in database performance tuning and optimization.
• Ability to work in a fast-paced, dynamic environment.
• Strong communication and interpersonal skills.