enterprise data architect

$207,750 - $207,750/Yr

Randstad - Trenton, NJ

Full-time - Senior

Trenton, NJ

Administrative and Support Services

About the position

The Enterprise Data Architect role at Randstad US involves building data architecture frameworks, standards, and data modeling activities. The position requires extensive experience in AWS architecture and focuses on defining various data models including conceptual, logical, physical, analytical, and canonical models. This is a contract position based in Trenton, NJ, offering a competitive hourly rate.

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 NJDOL 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 DOL team members on all facets of Data Modeling

Requirements

• Minimum 15 years of experience in data architecture
• Bachelor's degree in a relevant field
• Hands-on experience with AWS Architecture
• Proficiency in Data Analysis and ETL processes
• Experience with AWS Cloud Formation

Benefits

• Health insurance
• Incentive and recognition program
• 401K contribution