Data Architect

Salesforce and SQL Server Integration Developer & Support

Location: Hartford, CT-Day one onsite

Duration: 36 Months

Job Description:

Look for SQL Developer with Salesforce Experience

This is primarily a Salesforce and SSIS development and support role. You’ll work with various business areas, such distribution intelligence, sales, and marketing. You’ll work with technology leaders, generating new ideas to support, maintain, improve, and modernize the business and technology. We work from high-level requests and requirements, and developers are expected to have a deep understanding of the business and its needs. We strive for an environment where people have the autonomy to pursue technical solutions without arbitrary constraints. A growth/learning mindset to continuously improve our techniques and tools is critical.

Experience working in asset management, hedge fund, broker/dealer, investment company, or a similar financial company is required, as is several years’ experience in a heavily Salesforce, SQL Server, and SSIS development environment. You’ll ensure project status is transparent and up-to-date, documentation is created and maintained, and knowledge transfer occurs in a timely fashion. Experience with Azure DevOps (CI/CD) is important.

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.
• Primarily in-office position in Hartford, CT.

Desired Experience:

• 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.