Technical Business Analyst – Data Warehouse/Data Mart build

  • Competitive with full benefits
  • New York, NY, États-Unis
  • CDI, Plein-temps
  • BNY Mellon
  • 22 sept. 17

The Technology Business Analyst (TBA) on this project team has the responsibility to gather, analyze, document, and validate the needs of the business stakeholders and serves as the principal conduit for managing system requirements between the business and the software development. The primary responsibilities for this project include: elicit business requirements from business users and subject matter experts, define and document those requirements, write functional specifications, perform data gap analysis between requirements and existing data sources, coordinate with developers, create user acceptance test scripts and assist with testing in conjunction with multiple business and IT groups.

~Position Description – Technology Business Analyst

The Technology Business Analyst (TBA) on this project team has the responsibility to gather, analyze, document, and validate the needs of the business stakeholders and serves as the principal conduit for managing system requirements between the business and the software development. The primary responsibilities for this project include: elicit business requirements from business users and subject matter experts, define and document those requirements, write functional specifications, perform data gap analysis between requirements and existing data sources, coordinate with developers, create user acceptance test scripts and assist with testing in conjunction with multiple business and IT groups.  This project is expected to run through 2017.

Qualifications

The preferred candidate is a team player who works well with technical and non-technical resources and possesses the following:

 

Bachelor's degree in business or technical-related discipline, or equivalent work experience required, advanced degree preferred, 8-10 years of experience in providing consulting advice to senior IT and business management required, experience in the securities or financial services industry is a plus.

•        Preferred 10+ years of experience of working as technical business analyst on a large IT data project involving data warehouse/data mart build, data process flow, conceptual and logical data and dimensional modelling

•        Extensive experience with Transactional and dimensional level data in an enterprise data warehouse environment

•        Experience in writing user stories and acceptance criteria based on business requirement in an agile development environment.

•        Must be a strong performer, capable of consistently producing deliverables on time.

•        Must possess strong SQL skills

•        Experience working in a global team involving onshore/offshore model

•        Effective oral and written communication skills

•        A self-motivated personality, and able to work efficiently independently, as well as, in a team.

•        Experience working in agile (scrum) development environment

•        Domain knowledge on Banking and Financial & Regulatory Reporting is a plus

•        Technical expertise working on database appliances, columnar database and big data (specifically Hadoop, ExaData, Vertica, SQL Server ), ETL (Pentaho) and BI ( JasperSoft ) is desirable

•        Experience working with regulatory projects (e.g. Basel III, CCAR, BCBS 239) is desirable