Database Analyst IV

Job Description

We have a position for a Database Analyst IV with one of our clients in Salem, OR for an initial contract duration of 6 months. US citizens and all those authorized to work in the US are encouraged to apply.

Maintains data storage and access by evaluating, designing and implementing company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications and constructions. Relies on established guidelines and instructions to perform daily job functions. Works under immediate supervision and usually reports to a manager.

• Contribute or facilitate requirements gathering, business process, and JAD sessions
• Identify, define, and document data requirements
• Conduct data migration activities including planning, preparing, extracting, transforming, conversion mapping, transferring data from legacy system to source system and data validation
• Conduct and support data cleanup activities
• Conduct an assessment of the current system and document As-Is processes
• Create functional specifications for interfaces, extracts and reports
• Build reports and extracts
• Prepare test data, write queries, and support testing activities
• Contribute to the requirements traceability matrix
• Contribute to data integration activities
• Possibly contribute to system integration activities
• Must have experience with writing SQL
• Must have experience with data mapping, manipulation and analysis
• Must have the ability to communicate clearly verbally and in writing
• Must have the ability to interact with customers, lead meetings, clearly understand customer needs, and document those needs
• Must have experience in data management, Functional Specification writing, and testing procedures
• Should be familiar with relational database concepts
• Data administration skills a plus