Job Description :
Job Title: Data Architect
Job ID: 2017-193047
Duration: Until 12/31/2017 with possible extension
Location: Austin, TX

Position''s General Duties and Tasks
This data architect shall be responsible for understanding operational data models in client based systems and will work with other architect team members in the design of an overall data solution for the application. The architect will coordinate with the analysts and application architects to define the structure for how data will be captured and used in the application and shared across other applications.

As the business defines the applications targeted for replacement and migration to newly implemented client systems, the data architect will help coordinate data migration planning activities including any data modeling required to understand the mapping between source and target systems. Working collaboratively with the analysts, the architect will assist in data mapping and outlining ETL design for data migration. Additionally, it is expected that the bi-directional data feeds (insert, updates, deletes) between systems may be facilitated through integration services. The data architect will work closely with the application implementation and application architects to design a data flow between systems that shall support the front-bridge and back-bridge data transport requirements.

Key Responsibilities:
- Participate in gathering project data requirements with business analysts
- Determine data migration, application data, and data feed requirements
- Design ETL
- Develop data flows and models to support data feeds, geospatial
- Integration, data migration, and application data dictionary
- Help develop data dictionary and classification and publish to metadata with analysts
- Assist in building a library for common terms and definitions in coordination with business analysts
- Collaboration with enterprise architects, analysts, and project management

Basic Qualifications:
- 8+ years working across one or more relevant industries.
- Strong experience in translating the business client’s
- Expertise in application data architecture and supporting implementation
- Data migration planning project experience
- Source to target mapping
- Capacity planning and data storage
- Database systems engineering
- 3+ years experience working with ETL/ELT for data migration
- Understanding of enterprise service bus architectures and rest services
- Integration of data using a publish / subscribe model
- 3+ years Involvement in design of bi-directional data movement (front bridge / back bridge)
- Past or current experience in ETL development using Informatica and/or Microsoft SSIS
- Understanding of geospatial data integration
- Subject area data modeling for OLTP, normalized models, domains
- Business process knowledge, technical skills, and communication skills

Client : TXDOT