[Remote] Senior Consultant for Capital Markets (Structured Products) - Remote - US
Note: The job is a remote job and is open to candidates in USA. Portfolio BI is a company that provides flagship products and services to alternative asset managers. They are seeking a highly experienced Senior Consultant for Capital Markets with expertise in SQL and .NET technologies to develop and maintain complex systems while collaborating in a fast-paced environment. Responsibilities • Experience with Asset Management firms, knowledge of capital markets, and fixed income instruments is necessary • 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 • 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 across systems • 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 Skills • 5+ years of experience in software development, with a strong focus on SQL and .NET technologies • Experience with hedge fund firms, knowledge of capital markets, and fixed income instruments is a must • 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 • 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 Benefits • This is a fully-remote, contract role Company Overview • Portfolio BI is a provider of front-to-back solutions for order management, portfolio management and operational data. It was founded in 2020, and is headquartered in New York, New York, USA, with a workforce of 51-200 employees. Its website is Company H1B Sponsorship • Portfolio BI has a track record of offering H1B sponsorships, with 2 in 2023, 2 in 2022, 4 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job