7+ years of advanced SQL Server development and support experience in an asset management firm, hedge fund, or broker/dealer, with consummate business knowledge in distribution, sales, and marketing
7+ years of imperative programmatic development experience on the Salesforce platform including use of VSCode to develop SOQL, APEX, Lightning Web Components, triggers, custom APIs, etc.
Very strong expertise in SSIS with experience in integration across various platforms (beyond SQL Server) including external API platforms such as Salesforce CRM and Eloqua Marketing Cloud
Experience with KingswaySoft SSIS extensions is highly desired.
5+ years of experience in C# and VB application development
Extensive experience in a batch-oriented environment
Experience with SalesPage Enterprise distribution data platform is major “plus”
Experience in data warehouse/data mart modeling and development
Well-versed in the use of Git/GitHub source control
Power BI experience is a plus
Expectations
Excellent written and verbal communication skills. Detail-oriented, concise, transparent.
Support, maintain, enhance, and develop software that meets and exceeds the needs of the company, focusing on testability, reliability, scalability, and maintainability.
Provide support during business hours and after hours/on-call as needed.
Collaborate with team and senior IT management to drive projects to completion.
Perform development duties using the following requirements:
Work in an Agile environment in Azure DevOps (Pipelines, GitHub, Boards, Wiki, Test Plans, etc.).
Microsoft SQL Server, SSIS.
Salesforce development including Apex, SOQL, LWC, API integration, as well as general configuration and administration.
HTML, JavaScript, and CSS development
General API integration development
Tidal as an enterprise scheduler, but UC4, Autosys, ActiveBatch, etc., will suffice.
Experience with at least one sales data provider, such as SS&C’s SalesConnect.