Portfolio BI is hiring a Senior Consultant for Capital Markets (Structured Products) to join our team. This senior software developer role focuses on complex systems for structured products within the capital markets sector, requiring independent work in a dynamic environment.

What You'll Do

Design, develop, and optimize complex SQL stored procedures, functions, and queries.
Debug and troubleshoot complex SQL code to ensure performance and accuracy.
Maintain and improve the reliability of the existing SQL codebase.
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.
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.
Work with SSIS packages for data migration, transformation, and loading (ETL).
Collaborate with cross-functional teams to ensure seamless data flow.
Use TFS/TFS DevOps for version control, continuous integration, and task management.
Participate in daily peer code reviews and maintain high coding standards.
Monitor alerts and system health to ensure high availability and reliability.
Respond to and resolve daily deliverables and ad hoc requests efficiently.

What We're Looking For

5+ years of software development experience, with a strong focus on SQL and .NET technologies.
Experience within hedge fund firms and knowledge of capital markets and fixed income instruments.
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.
Strong analytical and problem-solving abilities, with a commitment to quality and timely delivery.
Experience with Asset Management firms and knowledge of capital markets and fixed income instruments.

Nice to Have

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.