Enterprise Data Architect

Enterprise Data Architect

Location : Trenton NJ area

Reports To : Client IT Management

Job Description :

Only qualified Enterprise Data Architect candidates located near the Trenton NJ area will be considered due to the position requiring an onsite presence.

The Sr. Enterprise Architect focuses on building data architecture frameworks standards and data modeling activities defining conceptual logical physical analytical and canonical models.

10 years of handson experience with AWS architecture is required.

Required Skills :

Data Architecture : 15 years

AWS Cloud Architecture : 10 years

AWS Glue / Athena / Storage / Lambda / Data Brew / RDS / Redshift DMS : 10 years

Operational Data Modeling Skills : 15 years

Analytical Modeling Skills : 15 years

Data Governance : 10 years

Master Data Management : 15 years

Information Governance : 10 years

Metadata Management : 10 years

Data Cataloging : 15 years

Data Engineering and ETL : 15 years

Data Quality : 15 years

Experience writing in explanatory and procedural styles for multiple audiences : 15 years

Experience in prioritization and multitasking : 5 years

Desired Skills :

Mainframe Technologies including Cobol Db2 IMS DB / DC VSAM JCL : 5 years

Knowledge of working in Federal State and Local Government : 5 years

Knowledge and Experience :

15 years of experience in business / working as a data architect data modeler data analyst.

Understanding of AWS Cloud Architecture and the basics of its infrastructure.

Handson experience and expertise in using AWS tools : AWS Glue Data Brew AWS Lambda AWS S3 AWS DynamoDB AWS RDS Athena Redshift DMS.

Handson experience and expertise in creating and automating data pipelines using AWS services.

Expertise in data management principles master data management principles data governance concepts and data engineering methodologies.

Proficient in NoSQL and relational MDM data modeling.

Experience in data governance with Collibra.

Experienced in working with different software development methodologies.

Duties and Responsibilities :

Conduct an assessment of the current state of data systems.

Establish the system of record and data dictionary for data systems.

Develop enterprise architecture.

Create and construct conceptual logical and physical models.

Facilitate business sessions to validate business taxonomy and use cases.

Provide an initial design solution for the core data model and additional forthcoming data structures.

Support project requirements in the modernization of conceptual logical and physical models.

Define the client architecture across conceptual logical and physical layers.

Develop and maintain conceptual logical and physical data models utilizing best practices and ensuring optimal query performance.

Optimize and update conceptual logical and physical data models to foster a new and secure data environment.

Assist in establishing best practices for standard naming conventions.

Coordinate activities with the EDL team including developers and testers.

Assist in promoting database objects from lower to higher environments.

Lead design reviews of data models and relevant metadata to ensure consistency.

Recommend opportunities for the reuse of data models across projects.

Consult with database administrators regarding the creation of physical data schemas referential integrity and the fulfillment of business requirements.

Collaborate with ETL developers report developers and end users on effective database utilization.

Guide system analysts engineers programmers and others on project limitations requirements interfaces and system integration challenges and solutions.

Mentor client team members on all facets of data modeling.

Note :

Contractor will be able to work remotely a lot of the time but must be located near Trenton NJ area and be available to come into the office for meetings.

AWS,Data Architecture,Master Data Management,Data Governance,Cloud