Senior Consultant for Structured Products Development team - Dallas, TX

Portfolio BI•Dallas, TX

12h•Remote

About The Position

Portfolio BI’s flagship products and services, PBI Axiom, PBI Vector, and PBI Stratus, enable alternative asset managers to address their data challenges in analytics, workflow, governance, and security. We are looking for a highly experienced and hands-on Senior Software Developer with deep expertise in SQL, SSRS, .NET technologies, and WCF services. The ideal candidate will be a strong individual contributor who can independently analyze, develop, and maintain complex systems while working collaboratively in a fast-paced environment.

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

Nice To Haves

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

Responsibilities

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