Senior Consultant for Structured Products Development team - US - Tri-State at Portfolio BI

New York, New York, United States -

Full Time

Start Date

Immediate

Expiry Date

22 Mar, 26

Salary

0.0

Posted On

22 Dec, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, SSRS, .NET, WCF, C#, VB.NET, SSIS, ETL, TFS, DevOps, Analytical Skills, Problem-Solving, Communication Skills, Asset Management, Capital Markets, Fixed Income Instruments

Industry

Financial Services

Description

Portfolio BI’s flagship products and services, PBI Axiom, PBI Vector, and PBI Stratus, enable alternative asset managers to address their data challenges in analytics, workflow, governance, and security. We are looking for a highly experienced and hands-on Senior Software Developer with deep expertise in SQL, SSRS, .NET technologies, and WCF services. The ideal candidate will be a strong individual contributor who can independently analyze, develop, and maintain complex systems while working collaboratively in a fast-paced environment. 5+ years of experience in software development, with a strong focus on SQL and .NET technologies Proven expertise in building and debugging complex SQL procedures Advanced knowledge of SSRS report development and data conversion Strong proficiency in C#, VB.NET, and WCF services Experience with SSIS for ETL processes Hands-on experience with TFS/TFS DevOps tools and workflows Excellent communication skills, with the ability to work independently and collaborate effectively in peer-driven development environments Strong analytical and problem-solving abilities, with a commitment to quality and timely delivery Key Responsibilities: Domain Knowledge: Experience with Asset Management firms, knowledge of capital markets, and fixed income instruments is necessary SQL Development: Design, develop, and optimize complex stored procedures, functions, and queries Debug and troubleshoot complex SQL code to ensure performance and accuracy Maintain and improve reliability of the existing SQL codebase SSRS Development: Enhance, debug, and refactor existing SSRS reports Transition or rewrite reports to new data structures and formats Ensure data consistency and accuracy across multiple reporting environments .NET and WCF Development: Design and implement new applications and services using C#, VB.NET, and WCF Maintain and improve existing .NET components and services Collaborate on developing new systems that integrate with SQL Server data sources Integration and Data Management: Work with SSIS packages for data migration, transformation, and loading (ETL) Collaborate with cross-functional teams to ensure seamless data flow across systems DevOps and Version Control: Use TFS/TFS DevOps for version control, continuous integration, and task management Participate in daily peer code reviews and maintain high coding standards System Monitoring and Support: Monitor alerts and system health to ensure high availability and reliability Respond to and resolve daily deliverables and ad hoc requests efficiently Preferred Attributes Self-motivated, detail-oriented, and proactive in identifying and resolving issues Comfortable handling multiple parallel tasks in a dynamic environment Experience in maintaining and modernizing legacy systems is a plus This is a fully-remote, contract role

Responsibilities

The Senior Consultant will design, develop, and optimize complex SQL procedures and SSRS reports while implementing new applications and services using .NET technologies. They will also collaborate with cross-functional teams to ensure seamless data flow and maintain system reliability.