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 https://www.portfoliobi.com/.
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 Now
Apply Now