Database Analyst IV

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. Requires a bachelor's degree in area of specialty and at least 9 years or equivalent experience in the field or in a related area. Full-time professional work experience in Software Development, Maintenance, or Implementation. Substitutions: Accredited college training may substitute for the required work experience with a maximum substitution of four (4) years. (Fifteen (15) semester hours in Information Technology or a related area is required.) Accredited graduate training in the above area may substitute for the required work experience with a maximum substitution of two (2) years. Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of two (2) years. (Proof of certification must accompany application.) Two (2) years of work experience as a Data Administrator ; Data Warehousing Administrator ; Data Architect ; Database Analyst-Intermediate ; Data Warehousing Analyst may substitute for all of the required experience.The purpose of this request is to procure senior level Data/Systems Analysis services for ODOT Transportation Development Branch in support of the Traffic Count Management System replacement project. The contractor will be responsible for data and systems analysis for the implementation of a COTS and SaaS Traffic Count application. The role of this contractor may include:Contribute or facilitate requirements gathering, business process, and JAD sessionsIdentify, define, and document data requirementsConduct data migration activities including planning, preparing, extracting, transforming, conversion mapping, transferring data from legacy system to source system and data validationConduct and support data cleanup activitiesConduct an assessment of the current system and document As-Is processesCreate functional specifications for interfaces, extracts and reportsBuild reports and extractsPrepare test data, write queries, and support testing activitiesContribute to the requirements traceability matrixContribute to data integration activitiesPossibly 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 plusComment Files Company Origin Viewable Created By Created On Background VerificationStandard Background VerificationPlease perform the following background verification at the point of the candidate's selection for the position:Drug Screening (5 Panel)SSN Address TraceStatewide Criminal HistoryFederal Criminal HistoryUS Criminal Record LocatorNational Sex Offender RegistryGlobal Monitor Check