By joining our team as a technical business analyst, you will have the opportunity to act as a liaison between our various corporate lines of business and the providers of technology shared services to the firm as a whole. You will gain exposure to both proprietary and third party applications as you work on projects that span the software development life cycle including problem and business analysis, vendor evaluation and selection, and understanding how applications interact in our expansive technical environment. In addition, your role will entail report writing, the coordination of application testing and integration and the support of these applications. Some of the lines of business with which you will be collaborating include IT, Human Resources, Accounting, Finance, Facilities, Purchasing and Marketing. Your role within these teams will be to build a deep understanding of our business as a whole as well as the applications being utilized within them. As you collaborate with these teams, you will learn both the high level goals as well as the specific needs of the business stakeholders with whom you are working to understand their needs and goals, translate them into project work streams and coordinate with other technical teams to recommend, implement and support solutions to meet those needs. This role will truly enable you to leverage your knowledge of how various applications and technical solutions are architected to ensure that the applications being utilized or evaluated within our various lines of business are meeting the needs they are designed to address. Conduct business analysis around stakeholder needs Write functional specification documents Elicit requirements from stakeholders using techniques such as interviews, design sessions, surveys and/or other techniques as needed Act as a liaison between corporate business stakeholders and the corporate applications and other internal technology teams Partner with business stakeholders and project teams to translate business requirements into creative and practical solutions Perform research and acquire knowledge of existing business applications and processes Perform vendor evaluations for third party solutions Manage implementation projects and timelines Define and manage data interfaces with third party vendors Define, manage and execute data interfaces internally Analyze, cleanse, transform, manage and validate data Create and run Ad-hoc SQL reports and queries for end-users Create reports for end-users Perform data maintenance and cleaning tasks QUALIFICATIONS: Minimum of two (2) years of experience providing application implementation and support services to end users or working with a back-office business domain such as accounting, payroll, recruiting, human resources, etc.; Previous financial services industry experience a plus Previous experience working with data integration and/or vendor feeds required Strong organization, verbal, and written communications skills required Excellent customer services skills possessing a high energy service oriented business facing approach required Strong analytical / problem solving skills critical Ability to work independently and as part of a team necessary Flexibility to work on a mix of technical and non technical assignments required Knowledge of SDLC models required Experience with Crystal Reports, Cognos Impromptu or Microsoft SQL Server Reporting Services a plus Knowledge of Microsoft .Net a plus Strong knowledge of MS Access, Excel, Word required
Strong Understanding of Relational Database Concepts, preferably Microsoft SQL Server, required
Strong SQL & T-SQL Skills required
Experience with SSIS, DTS, Informatica or other integration enabling tools a plus




