Contract

Trenton New Jersey United States

Yes

Enterprise Architect

Location: Trenton, NJ(Hybrid)

Duration: 12+ months

Interview: Phone + F2F

Note: Need a local contractor who is available to come into the office for meetings. Contractor will be able to work remotely a lot of the time.

Job Responsibilities:

• Need a Sr Enterprise Architect focusing for building data architecture Frameworks, Standards, and Data Modeling activities defining Conceptual, Logical, Physical Analytical and Canonical models. Solid Knowledge of AWS Architecture required - (15 yrs) 
• Must have Excellent written and verbal communication skills, meticulous attention to detail, as well as the ability to understand abstract concepts.
• The Enterprise Information Strategy is divided into several Tracks of work. The Sr Enterprise Data Architect will focus on:
• AWS Cloud Data Architecture.
• Building Data Architecture Frameworks,Data pipeline frameworks,Standards, and Data Modeling Activities for UI Mod
• All underlying systems, data owners, databases, and applications working together with the Sr Data Management Lead and the Office of the CIO in defining the Conceptual, Logical, Physical Analytical and canonical models. This work stream will focus on several systems in scope.
• The DA will analyze the data needs of the systems and databases and uses skills in coding to maintain secure databases. They then collect and organize the data obtained into structured data models. Additionally, using mathematical and statistical theory methods they present findings to management which are then used to improve various initiatives within the NJDOL systems.
• Will meet with business teams and determine the best methods to gather the information required.

The Enterprise Data Architect must:

• Research and properly evaluate resources of information to determine possible limitations in reliability or usability
• Apply sampling techniques to effectively determine and define ideal categories to be questioned
• Compare and analyze provided statistical information to identify patterns, relationships, and problems 
• Define and utilize statistical methods to solve industry-specific problems and engineer data structures Prepare detailed reports for management and other departments by analyzing and interpreting data.

Experience:

• 15+yearsofexperience in Business/IT working as a Data Architect, DataModeler, Data Analyst and/or Business Process Support Associate
• Expertise in Data Modeling, Solution Architecture, Master Data Management (MDM),Business Process Analysis/Engineering, Business Requirements Gathering and Systems Analysis in State, Local Government and Public Sector Domains
• Expertise in one or more Data Modeling Tools
• Experienced in working with different Software Development Methodologies.
• Proficient in, NoSQL, Relational, MDM and Canonical Data Modeling.
• Extensive Knowledge of Data Management Principles
• Extensive Knowledge of Master Data Management Principles 
• Knowledge of Data Governance Concepts
• Knowledge of Data Engineering Methodologies
• Knowledge of Data Engineering

Responsibilities:

• Conduct Current State Assessment of Data Systems
• Define System of Record and Data Dictionary for Data Systems Develop Enterprise Conceptual, Logical and Physical Data Models
• Creates and builds Conceptual, Logical and Physical Models
• Facilitates Business Sessions and validates business taxonomy and use cases aligned to data models
• Provide initial design solution for core data model as well as for additional upcoming data sources and required models supporting
• Support Project Needs to design Conceptual Logical and Physical Models to Modernization Efforts
• Define the architecture from Conceptual, Logical to Physical layers. Provide solution expertise to cross functional delivery teams
• Provide architecture thought leadership and actively participate in the design, implementation, and roll-out efforts.
• Develop and maintain Conceptual, logical and physical data models using best practices and DOL standards to ensure high data quality, reduced data redundancy, and good query performance.
• Reverse and forward engineer data models in Erwin or other Data Modeling Tools
• Optimize and update Conceptual, logical and physical data models to support new and existing projects and ensure business users are working in a clean safe data environment.
• Assist in the creation of best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Coordinate activities with the rest of the EDL team including developers and testers; Assist in promoting database objects from lower to higher environments.
• Lead design reviews of data models and other relevant metadata to ensure consistency, quality, accuracy and integrity.
• Recommend opportunities for reuse of data models in new projects.
• Consult with Database Administrators concerning the creation of physical data schema from the logical model by making recommendations, designing referential integrity, and ensuring business requirements are satisfied.
• Consult with ETL developers, report developers, end users concerning how to use the database as designed and how to navigate efficiently within the database.
• Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces, and system integration challenges and solutions.
• Mentor DOL team members on all aspects of Data Modeling.

Required skills:

• Data Architecture 15 Years
• AWSCloudArchitecture15Years
• OperationalDataModelingSkills15Years
• Analytical Modeling Skills 15 Years
• Canonical Modeling 10 Years
• Information Governance 10Years
• Master Data Management15years
• Metadata Management 10 Years
• Data Cataloging 15 Years
• DataEngineeringandETL15Years
• Data Quality 15 Years
• Excellentwrittenandverbalcommunicationskills,5years
• Proficiency in MS Office, 5 years
• Strongattentiontodetail,5years
• Abilitytowriteinexplanatoryandproceduralstylesformultipleaudiences,5years
• Skilledatprioritizationandmulti-tasking,5years
• MainframeTechnologiesincludingCobol,Db2,IMS DB/DC, VSAM, JCL and other middleware tools
• Knowledge of working in Federal, State and Local Government