Sr. Application Specialist

Job Description

What is the opportunity?

Partners across IT and with assigned business line(s) to assess, research, and analyze business, technical and system needs in order to resolve business systems issues by recommending and owning technology solutions that meet sponsor/stakeholder needs. Will work on large projects/programs with multiple applications with multiple interfaces and/or 3rd parties.  

What will you do?

Technical Analysis, Design and Consulting

• Facilitates Requirement gathering with the business and translates the business requirements into technical specifications for the vendor or internal developers.

• Manages detailed design phases for large projects/ programs identifying, tracking and resolving technical issues and ensuring solution meets sponsor needs. These include Alternative investments, Order Entry and Performance Reporting data file creation process.

• Provide quality and timely support to our business partners through contributions to mid-size, heavily integrated programs through building and running SQL queries to perform data analysis, impact analysis, and/or building ad hoc report

• Contributes to successful project completion by identifying risks and developing/recommending mitigation strategies

• Provides input and co-ordinates with technical team members in creating new and modifying existing database structures using different types of databases and recommending appropriate DB based on required functionality across multiple systems.

• Facilitates Requirement gathering with the business and translates the business requirements into technical specifications for the vendor or internal developers.

System Implementation

• Provides or participates in technical liaison between business the project or support team for project installations.

• Partners with development and support team in release activities and Post Implementation Validation activities for the application(s) supported.

Testing & Documentation

• Partners with Quality Engineering team and manage User Acceptance testing and verification ensuring all tasks are performed for all interfaces.

• Ensures adequate technical documentation and training.

Planning, Implementation & Support

• Manages all aspects of implementation planning & coordination.

• Develops detailed plans and accurate estimates for the design, build, implement and stabilize phases of the project.

• Performs database/ disaster recovery planning for multiple systems.

Relationships & Communication

• Acts as primary IT liaison with multiple interfacing applications, 3rd party vendors, IT Executive and/or Project Managers.

• Effectively communicates and builds rapport with team members, stakeholders and interface groups using a variety of techniques and collaboration from initiation to close.

• Facilitates complex group meetings (including business partners) for technical design, decision making, problem solving, implementation and strategic planning.

• Prepares and delivers presentations to business and technology partners, senior management and executives, selecting the appropriate approach based on the audience.

What do you need to succeed?

Must-have

• Position requires 7+ years of experience in IS/IT performing business/systems & data analysis. 

• Experience working with product owner, business analysts and developer

• Creating presentation, flow charts, business process documents with appropriate level of details and abstractions

• Translating requirements into technical solutions

• Understand business requirements

• Working knowledge and experience with cloud services – SaaS, preferred IaaS, PaaS

• Experience with building / running SQL query at an advanced level to perform data analysis, impact analysis, and/or producing ad hoc report

• Good understanding of data models and large data analysis

Nice-to-have

• Hands on experience with Informatica MDM (Master Data Management)

• Experience working in Agile development setting & familiarity with Jira

• Experience working in an enterprise environment and Service Oriented Architecture with multiple integration with upstream & downstream systems.

• Experience with financial industry and / or customer data /