Data Warehousing Analyst

Data Warehousing Analyst

by Brian Borsa|July 31, 2008
  • Contract to Hire
  • St. Louis, MO
  • Reference: STLconusi7

Responsible for leading the efforts to formulate and define scope and objectives based on user needs related to a large complex data warehouse that supports enterprise wide compliance and business initiatives.  Works with internal business groups to collect and define requirements, translate these into Detailed Business Requirements and Functional Design documents.  Will also develop Erwin Data Models for a dimensional enterprise data warehouse and communicate with database administrators to set up various distributed databases.  Create Data Mapping documents for source to target objects within the warehouse.  Will work closely with development and participate in technical design.  Will be involved in test planning and will participate in various stages of testing to include writing of test cases, unit testing and integrated testing.  Must also relate business reporting need as it relates to the data.  System Development Life Cycle to include both iterative and waterfall approaches.  Must have proven track record in duties as related to SDLC.




  • 4 year degree in Computer Science, Economics, Finance.
  • 8 or more years of experience in information systems technology in the financial services industry.
  • 10 or more years of mainframe tools such as TSO/ISPF, COBOL, JCL, Easytrieve, FOCUS, and File-aid.
  • 4 years coding experience in SQL; 4 years BI SQL query tool such as WebFocus; 4 years database query tool such as TOAD.
  • Proven leadership skills and ability to work as a team member.  
  • Exceptional technical, logical, analytical and problem-solving skills.
  • Ability to present complex technical concepts in verbal and written business terms.
  • Excellent planning and organizational skills.
  • Excellent interpersonal, verbal and written communication skills.
  • Experience in compliance, security and business projects.
  • Ability to manage multiple projects / tasks consecutively.
  • Exceptional project/team leadership skills.

To apply for this job email your details to brian@cycle3it.com

Choose a style:

Purchase Now!