Portfolio BI ยท 2 days ago
Senior Consultant for Capital Markets (Structured Products) - Remote - US
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.
Management Consulting
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
Qualification
Required
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
Preferred
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
Portfolio BI
Portfolio BI is a provider of front-to-back solutions for order management, portfolio management and operational data.
H1B Sponsorship
Portfolio BI has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (2)
2022 (2)
2020 (4)
Funding
Current Stage
Growth StageRecent News
2024-03-21
Company data provided by crunchbase