Job Description :
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