Portfolio BI
EDM + OMS & PMS + Public Cloud Managed Services = Portfolio BI
Senior Consultant – Capital Markets, Structured Products
Location
Texas
Posted
71 days ago
Salary
Not specified
Seniority
Senior
5 yrs expEnglishETLSQLSSISTFS.net
Job Description
• 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
Job Requirements
- 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
Benefits
- This is a fully-remote, contract role
Related Guides
Related Categories
Related Job Pages
More Consultant Jobs
Consultant72 days ago
Full TimeRemoteTeam 1,001-5,000Since 1981H1B Sponsor
Solution Consultant overseeing technical Business Development for Digital Grid Management Products
Consultant72 days ago
ContractRemoteTeam 51-200H1B Sponsor
Senior Advisor on ESG and Climate Accounting supporting client engagements at CNM LLP
Travel Consultant – Sabre Experience
American Express Global Business TravelAmerican Express Global Business Travel (Amex GBT) is a corporate travel management platform. As an employer, the company strives to provide its team members wi
Consultant75 days ago
Full TimeRemote
Remote Travel Consultant providing travel services to corporate clients
Consultant76 days ago
Full TimeRemoteTeam 1,001-5,000Since 2021H1B Sponsor
Outbound Sales Consultant helping clients elevate their digital presence




