Portfolio BI logo
Portfolio BI

EDM + OMS & PMS + Public Cloud Managed Services = Portfolio BI

Senior Consultant – Capital Markets, Structured Products

ConsultantConsultantContractRemoteSeniorTeam 51-200Since 1998H1B SponsorCompany SiteLinkedIn

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 Categories

Related Job Pages

More Consultant Jobs

Full TimeRemoteTeam 1,001-5,000Since 1981H1B Sponsor

Solution Consultant overseeing technical Business Development for Digital Grid Management Products

Minnesota
$74.2K - $92.8K / year
CNM LLP logo

Independent Consultant

CNM LLP

Trusted Relationships, Professional Excellence

Consultant72 days ago
ContractRemoteTeam 51-200H1B Sponsor

Senior Advisor on ESG and Climate Accounting supporting client engagements at CNM LLP

California
$125 - $175 / hour
American Express Global Business Travel logo

Travel Consultant – Sabre Experience

American Express Global Business Travel

American 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

United States
$39.2K - $72.8K / year
Full TimeRemoteTeam 1,001-5,000Since 2021H1B Sponsor

Outbound Sales Consultant helping clients elevate their digital presence

United States
$15 / hour