Data Warehouse Analyst – McLean VA

Title: Data Warehouse Analyst
Positions: 2
TemptoPerm: No
Startdate: 8/01/2012
Enddate:  12/31/2012 – Most like to extend till end of next year
Funding: Initiative
Project: CDW Light Enhancements
Looking for Analysts in the Corporate Data Warehouse team to support ongoing light enhancements and other initiative projects.

Statement:    • Work with business SMEs and identified project stakeholders to develop detailed requirements (functional/non-functional/operational/data quality).
• Document all requirements into DOORS.  Conduct requirements walkthroughs with project team and project stakeholders.
• Lead and support change control on requirements.
• Develop Requirements traceability matrix (RTM).
• Work with developers for detailed design document.
• Develop business rules spreadsheets (BRSs) to document data movement/data transformation rules.
• Perform data profiling, data analysis, setup mock data for development/unit testing.
• Work with developers, data modelers, testers and business area SMEs to support development, system testing, UAT
• Support all phases of the project development lifecycle using SDLC and other project methodologies.
• Perform Unit testing, and document test results.
• Support System Testing, End-to-End testing, and UAT
• Develop implementation/backout plans and support production implementation.
• Support post-production validation.
• Support project management tasks as defined by the Project Manager.

Skill level: Mid-level (3-7 yrs)

Skills: DOORS, SQL, DB2, Requirements management, testing, project management support tasks.

Comments: Experience with Mortgage/finance industry preferred