1 Click Easy Apply


Business Systems Analyst - Investment, Data Warehouse, SQL


Wilmington, Delaware


Business Systems Analyst - Investment, Data Warehouse, SQL Job Opening in Wilmington, Delaware - Business Systems Analyst - Investments
Location: Wilmington, DE 19809
Requirements:
This person will support 50% data warehouse projects and 50% support for end users and release support.
Experience with investment applications is a must
We use PAM which is also called PFI-Investment /Asset Platform, it supports trading systems. We extract data from their trading system out to these investment apps (PAM).
This team also does release testing usually twice a year so the candidates needs to have experience with it.
Business Systems Analyst also writes SQL queries; SSIS/SSRS for report writing.
Key Accountabilities:
Supports company BA/BCA and development staff in creation of application and system integration
Provides tier 2 service desk application support and trouble shooting.
Develops and executes simple SQL scripts to resolve production issues and create reports
Monitor / track issues until resolution and determine impacts resulting from issue
May Coordinates Minor software release schedule and approval process with Release Management, development staff, Business System Analysts, and customers
Able to provide root cause analyze when troubleshooting system issues
Develops advanced requirements based on customer request and/or requirements. Assist in writing requirements, design, testing and/or initiation of projects to help provide solutions for our customers.
Develops technical specifications to solve a business need or problem
May define XML schemas for web services
Develops and executes SQL commands to accomplish data model changes and is involved in data modeling. May also include report generation
Monitor or track tasks until completion to insure delivery to customers
Active participant in design sessions and other technical meetings involving system changes
Work with business to understand system issues
Knowledgeable on a specific set of components within an application or a single application.
Communicate issues effectively to multiple levels within the organization
Recreate issues and document requirements for bug fixes and/or system enhancements
Create documentation and training materials, Provide end-user training to internal and external customers
Assists in release software upgrades to customers (internal/external), including testing
Travel for position is up to 10%
Minimum Qualifications ():
5 - 7 years of experience with investment applications (PAM or CAMRA or similar)
Previous experience at implementing multiple systems which should include a financial system or workflow application (hopefully at multiple companies)
Troubleshooting System issues and end users questions
Experience with release testing, SQL server query writing. * Exposure to SSIS/SSRS for report writing.
Finding solutions to complex business workflow.
Software Development Life Cycle experience
Basic Property and Casualty knowledge preferred
Bachelor's degree with emphasis in related field or equivalent experience
Excellent problem solving and analytical skills
Strong interpersonal and communication skills, both oral and written
Ability to quickly learn new technology and systems
Job Type: Full-time
Salary: $85,000.00 to $90,000.00 /year

1 Click Easy Apply

TalentEinstein.com - Superhuman AI Recruiting Assistant | Terms & Conditions

All rights reserved
Swanco LLC