Technical Analyst / Developer with investran application

TecTammina; Madison (NJ); On-site; USD 60,000 - 85,000; Full time

Job summary

A technology solutions provider in Madison, NJ, seeks a full-time Technical Analyst/Developer skilled in Investran application and SQL. This role involves updating documentation, analyzing business flows, and collaborating with teams for reporting needs. The ideal candidate will have experience with Excel, VBA, and Business Intelligence Tools like SSRS and Crystal Reports. Strong problem-solving and communication skills are key to succeed in this fast-paced environment.

Qualifications

• Minimum 1 year prior experience with Investran as end user or technical support.
• Advanced technical skills in Excel & VBA for developing macros.
• Minimum 2 years practical experience with SQL, including complex stored procedures.
• Experience with Business Intelligence Reporting Tools, including report design.
• Proven ability to work independently and manage priorities.

Responsibilities

• Update documentation for program specifications and interface control.
• Analyze business process flows and convert them for automations.
• Define workflows and complete gap analysis for business requirements.
• Collaborate with teams to write detailed specifications for reporting.
• Document requirements and develop reports using SSRS and Crystal Reports.
• Coordinate testing efforts with Investran vendor and develop test cases.
• Ensure integrity and accuracy of data during inputs and migrations.
• Develop communication strategies around process changes.
• Quickly troubleshoot issues and develop creative solutions.

Skills

Investran application experience

Excel & VBA

SQL

Business Intelligence Reporting Tools

.NET environments

Software Development Life Cycle

Verbal communication

Written communication

Problem-solving

Tools

SSRS

Crystal Reports

OLE DB

Job description

Technical Analyst / Developer with investran application

Full‑Time

Key Qualifications & Experience

• First IT Solutions
• 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 years 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.

Responsibilities

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

Additional Information

• 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