ENTERPRISE DATA ARCHITECT

Job ID Number

R3690

Employment Type

Full time

Worksite Flexibility

Hybrid

Job Summary

As the Enterprise Data Architect, you will analyze the data needs of systems and databases using skills in coding to maintain secure databases.

Job Description

We are looking for an Enterprise Data Architect for an 11-month contract opportunity that is hybrid in Trenton, NJ. The Enterprise Data Architect 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 client’s systems. The candidate selected will meet with business teams and determine the best methods to gather the information required.

What You’ll Do

• 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

• Providearchitecturethoughtleadershipandactivelyparticipateinthedesign, implementation, and roll-out efforts

• Develop and maintain Conceptual, logical and physical data models using best practices and 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

• Assisting 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; Assisting promoting data base 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 team members on all aspects of Data Modeling

What You’ll Need

Required:

• 15+ years of experience in Business/IT working as a Data Architect, Data Modeler, 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

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard and monitor

Reasonable Accommodation Statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 – 8111.

Equal Employment Opportunity Policy Statement

It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.