Enterprise Data Architect

Overview

On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

Data Dictionary
Enterprise Architecture
Taxonomy
Use Cases
Core Data
Data Structure
Design Review
Collaboration
Reporting
Database
Interfaces
System Integration
Mentorship
Facets
Data Modeling
Data Architecture
Amazon Web Services
Cloud Architecture
Storage
BREW
Remote Desktop Services
Amazon RDS
Amazon Redshift
DMS
Analytical Skill
Modeling
Data Governance
Master Data Management
Meta-data Management
Data Engineering
Extract
Transform
Load
Data Quality
Communication
Attention To Detail
SANS
Multitasking

Job Details

W2 Only

for W2 Candidates

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 usecases
  • Provide an initial design solution for the core data model andadditional forthcoming data structures
  • Support project requirements in the modernization of Conceptual,Logical, and Physical Models
  • Define the NJDOL architecture across Conceptual, Logical, and Physicallayers
  • Develop and maintain Conceptual, Logical, and Physical data modelsutilizing best practices and ensuring optimal query performance
  • Optimize and update Conceptual, Logical, and Physical data models tofoster a new and secure data environment
  • Assist in establishing best practices for standard naming conventions
  • Coordinate activities with the EDL team, including developers andtesters
  • Assist in promoting database objects from lower to higher environments
  • Lead design reviews of data models and relevant metadata to ensureconsistency
  • Recommend opportunities for the reuse of data models across projects
  • Consult with Database Administrators regarding the creation ofphysical data schemas, referential integrity, and the fulfillment of businessrequirements
  • Collaborate with ETL developers, report developers, and end users oneffective 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.

REQUIRED SKILLS

  • Data Architecture 15 Years
  • AWS Cloud Architecture 10 Years
  • AWSGlue/Athena/Storage/Lambda/Data Brew/RDS/Redshift, DMS 10 Years
  • Operational Data ModelingSkills 15 Years
  • Analytical Modeling Skills 15 Years
  • Data Governance 10 Years
  • Master Data Management 15 years
  • Metadata Management 10 Years
  • Data Cataloging 15 Years
  • Data Engineering and ETL 15 Years
  • Data Quality 15 Years
  • Excellent written and verbal communication skills 15 years
  • Strong attention to detail 15 years
  • Ability to write in explanatory and procedural styles for multiple audience 15 years
  • Skilled at prioritization and multi-tasking 5 years

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.