Mediabistro logo
job logo

Lead Systems Analyst

3B Staffing LLC, St Louis, MO, United States


Lead Systems Analyst

Needs to be US Citizen or GC Holder w/ good communication in order to convert in 6-12+ months)

REMOTE

From the manager:
Precision Loan Management is a must have (Might see it as Precision LM on resumes)

I asked for screening questions and he said that he does not know enough about it, but he would ask him team to see if there was anything specific with PLM that would be beneficial. As of now, just make sure they have the PLM.
Team fit- Easy going
Technical BA (Analysis, requirements, testing system)
A little SQL- tables to pull data
POSITION OVERVIEW

Under limited supervision, serves as liaison between users and Technical IT teams to analyze, document and test business requirements involving the commercial mortgage application and its' data warehouse model. Provide solutions for system support and enhancement requests. Provide basic application support for internal business users.

Responsibilities:

Develops, validates, documents, and maintains business and functional requirements and conducts structured walkthroughs of requirements with business and IT technical team members.

Mainly responsible for developing all business / technical requirements for support and enhancement items within the Commercial Mortgage Data Warehouse model.
Transforms business requirements into SQL statements
Analyzes data in order to triage issues within the data model
Works closely with data architect, business sponsors, core system admins, and report writers within an Agile methodology

Analyzes source system data in support of improving data quality

Works with the business to identify data issues and identify potential solutions
Proactively works to identify ways to improve data quality through business rules automation
Review existing Application functionality and perform gap analysis to identify enhancements to existing system functionalities. Apply configuration changes and updates via an application management tool.

Develops test plans and executes test scripts for application and data model changes in order to deliver quality work
Assists in evaluation of business requests to determine feasibility; researches and identifies options.
Responds to questions from business and IT technical teams.
Assists in evaluation of and tracking of new or enhanced solutions to determine potential issues, communicates how problems may affect business and recommends solutions, mainly within the mortgage data warehouse model.
Assists in performing task automation and implements process improvements; recommends enhancements that result in increased quality and service.
Respond to escalated calls from users and the help desk
Assists in the support of the core commercial mortgage servicing and accounting platform.
Maintains regular and predictable attendance
Performs other duties as assigned
Requirements:

Ability to transform data into information for analytics
Intermediate SQL skills

Includes writing basic update scripts, along with intermediate queries

Intermediate Excel skills
Ability to be flexible when needed, take initiative, and demonstrate accountability
Strong oral and written communication skills demonstrating ability to share and impart knowledge
Ability to quickly adapt to new methods, work under tight deadlines and stressful conditions within an Agile methodology.
Strong investigative, analytical and problem-solving skills
Strong data analysis skills
Strong interpersonal skills
Ability to accept guidance and ask relevant questions as part of onboarding process
Ability to set goals and handle multiple tasks, clients, and projects simultaneously
Ability to appropriately balance priorities, deadlines, and deliverables
Ability to work well within a team environment and participate in department/team projects
Ability to balance attention to detail, a sense of urgency along with a methodical approach to work assignments
Ability to balance detail with departmental goals/objectives
Ability to foster customer service as needed
Ability to translate business needs and problems into viable/accepted solutions
Ability to provide customer support for core platform capabilities and/or system development experience.
Basic negotiating and persuasion skills
General business knowledge
Bachelor's degree or equivalent related work experience
5-7 years IT-related experience, such as Business Analysis, Quality Assurance, etc.
Preferred:

8+ years IT-related experience, such as Business Analysis, Data Analysis, etc.
2+ years Financial or Investment industry knowledge