Portfolio BI

Senior Consultant – Structured Products Development

Portfolio BI

contract

Posted on:

Location Type: Hybrid

Location: Dallas • Texas • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETL.NETSQLSSISTFS

About the role

  • 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

Requirements

  • 5+ years of experience in software development, with a strong focus on SQL and .NET technologies
  • 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
  • Experience with Asset Management firms, knowledge of capital markets, and fixed income instruments is necessary
Benefits
  • This is a fully-remote, contract role

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLC#VB.NETWCFSSRSSSISETLstored proceduresfunctionsqueries
Soft skills
communicationanalytical skillsproblem-solvingcollaborationindependencecommitment to qualitytimely delivery