Technical Analyst / Developer with investran application

Madison, NJ, us on site Until 8/22/2026 H-1B sponsor history First posted February 23, 2026 Last posted February 23, 2026
Job description

First IT Solutions 

Relevant Experience (in Yrs) 6+ 

Minimum 1 year prior Investran application experience as an end user, technical support or consultant 

Advanced technical skills in Excel & VBA developing macros 

Minimum 2 year of full project life cycle experience implementing an Investment and/or accounting based application 

Minimum 2 years practical experience with SQL including complex stored procedures 

Minimum 2 years practical experience with Business Intelligence Reporting Tools (Crystal Reports, SSRS, XML). Experience must include report design and development. 

Minimum 2 years practical experience with .NET environments 

Minimum 2 years practical experience with the Software Development Life-Cycle 

Must be detailed oriented and have the ability to multi-task and set priorities. 

Ability to work independently and be productive (meets deadlines / flexible / responsive to change). 

Good written and verbal communication skills. 

Program Specifications and Interface Control Documents – responsible for updating existing documentation or creating new documentation when new functionality or reporting is added. 

Business Automations – responsible for analyzing and converting business process flow utilizing Excel OLE DB & Excel macro functions. 

Analyzing current business processes, defining work flow and completing gap analysis in respective business areas requirements and able to develop recommendations to solve for local or regional requirements.   

Working with technical and business personnel to write detailed specifications for reporting, systems requirements, use cases, and design documents. 

Report Development – Documents business requirements and develops reports utilizing SSRS / Crystal Reports / Excel OLE DB / XML 

Testing – responsible for coordinating testing efforts with Investran vendor, developing test cases surrounding the application, customization to ensure completeness of work. This is to be done prior to the release of the work to the business testers working with the Software Project Manager. 

Performs data inputs, importing of data and migrations ensuring consistency and accuracy of data and hierarchical structures where necessary. Uses appropriate mechanisms and troubleshoots/follows-up on issues that may arise. 

Developing communication and implementing strategies around process changes. 

Position requires the ability to quickly trouble shoot issues and think outside of the box. 

Job Status: Full Time 

Eligibility: EAD GC or GC or US Citizens

Share the Profiles to mkonni(at)1stitsolutions(dot)com

Contact: 703-349-1214

Keep the subject line with Job Title and Location

About this role

Summary

Develops and supports investran applications, reports, and business processes, ensuring data accuracy and system functionality.

Job title

Technical Analyst / Developer with investran application

Experience level

6+ years

Industry

software

Location requirements

Madison, NJ, US; remote not specified

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

excelvbasqlcrystal reportsssrsxml.netsoftware development life-cycle

Preferred skills

None specified

Specializations

investransqlreporting tools.NETVBA
Locations

Structured locations inferred from the posting.

Madison, NJ, USA

On-site City