ODOT is looking for a Data Architect (DA1) for an assignment through the end of the fiscal year with a possible extension through FY18. A complete job description is attached. This is a re-post of position ID 46622. Please do not submit candidates submitted to 46622.
This posting will close to submissions: Thursday 5/25 @ 11AM
LOCAL CANDIDATES ONLY and ONSITE INTERVIEWS are REQUIRED. Do not submit candidates unavailable to interview onsite. Please submit resumes in a word document and remove all candidate personal (phone email)and vendor information. Discuss with the candidates how their recent job experience relates to the job description. (Complete job description attached)
PLEASE DO NOT reach out to ANY individuals at ODOT regarding this posting nor candidates for this posting. All questions/comments/etc. must be directed to the MSP Team, specifically, Andy Hovest.
Job Classification:
Data Architect 1(DA1)
Role
Data Architect 1(DA1) is requested from June 5, 2017 to June 30, 2017 (300 hours)
ALPS Project
DOT – Staff Augmentation
MBE/Open Market
Open Market
Requirement Description:
The candidate will be supporting the continued growth and development of The Ohio Department of Transportation’s Transportation Information Mapping System (**TIMS) and Esri’s Collector for ArcGIS.
** Public TIMS website: http://gis.dot.state.oh.us/tims
This position will function as a highly skilled Data Architect with specific responsibilities that include:
-Work with business owners, subject matter experts, and 3rd party vendors to determine project/application data requirements.
-Develop data architecture models.
-Develop data flow models.
-Develop business process / workflow models.
-Design, develop, and implement database tables/views.
-Create SQL queries to support application interfaces, data transfers (ETLs), and data extracts.
-Verify accuracy and completeness of application data validation procedures.
-Troubleshoot data-related production problems.
-Create project/user documentation for all the above.
-Provide status of work and deliverable estimate to Team Lead.
-Ability to work independently and as part of a team, the ability to manage time, work under pressure of tight deadlines, and meet assigned deadlines.
Experience:
1. Possess excellent communication skills; both oral and written skills including strong meeting and work session skills.
2. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.
3. Demonstrate proven experience in troubleshooting issues.
4. Must enjoy working in a team environment.
5. Possess extensive knowledge of specific database systems, and is capable of hands-on work in all phases of database design and management.
6. Design, develop, and implement infrastructure to provide highly-complex, reliable, and scalable database to meet the organization's objectives and requirements.
7. Analyze organization's business requirements for database design, and implements changes to database as required.
8. Perform systems analysis on database, and resolves performance, capacity, and replication issues as necessary.
9. Provide detailed design and specification documentation, including flowcharts, for all aspects of the database.
10. Work with database analysts to develop methodologies, report views, queries, and table replications
11. Ensure that all the data is in the proper format.
12. Participate in the identification, prioritization, and development of technical initiatives and strategies.
13. Develop and maintain database standards and naming conventions.
14. Keep up-to-date on emerging database architectures, technologies, and methodologies, and attends training classes as necessary.
15. Initiate discussion with Businesses to define and assemble business requirements.
16. Translate business requirements into technical requirements – strong technical documentation skills.
17. Define and evaluate logical and physical data models.
18. Architecture modeling: data analysis, business process, conceptual level technology.
19. Define user interface strategies.
20. Database design in coordination with DBA’s.
Mandatory Requirements/Time:
4 year college degree or equivalent technical study.
Advanced SQL Skills in MS SQL Server required.
ETL or Data transformation experience.
Data Extraction tools.
MS Office Products.
