Data Enterprise Architect at CAI

Job ID Number

R4037

Employment Type

Full time

Worksite Flexibility

Hybrid

Job Summary

The Sr Enterprise Data Architect will be focusing on building data architecture Frameworks, Standards, and Data Modeling activities defining Conceptual, Logical, Physical Analytical and Canonical models and will need AWS experience.

Job Description

We are seeking a highly skilled and experienced Sr. Enterprise Data Architect to join our IT team. This position will be full-time, hybrid, and is a contract position to be extended for 1-2 more years.

We are looking for 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.

Location: Trenton, NJ 08625

What You'll Do

• Design the blueprint for clients data management framework

• Collaborate with client IT management and other teams to develop a data strategy that meets departmental needs and industry requirements

• Create an inventory of the data necessary to build and implement a data architecture

• Envision, design data pipelines and how data will flow through the enterprise

• Maintain a repository of all data architecture procedures and artifacts

• Develop measures that ensure data accuracy, integrity and accessibility

• Continually monitor, refine and report data management system performance

• 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

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

• Consult with Database Administrators regarding the creation of physical data schemas, referential integrity, and the fulfillment of business requirements

• Mentor DOL team members on all facets of Data Modeling

What You'll Need

Required

• The enterprise data architect must have a deep understanding of AWS services and cloud infrastructure

• This skill set includes proficiency in AWS core services such as EC2, S3, VPC, and RDS, as well as an understanding of advanced services like AWS Lambda, Amazon ECS, and AWS Outposts

• 15+ years of experience in Business/working as a Data Architect, Data Modeler, Data Analyst

• Hands on Experience and Expertise in using AWS tools: AWS glue, data brew, AWS Lambda, AWS S3, AWS Dynamo DB, AWS RDS, Athena, Redshift, DMS

• Hands on Experience and Expertise in creating and automating Data pipelines using AWS services

• Expertise in Data Management Principles

• Expertise in Master Data Management Principles

• Expertise in Data Governance Concepts

• Expertise in Data Engineering Methodologies

• Expertise in Data Modeling, Solution Architecture, Master Data Management (MDM), Gathering and Systems Analysis

• Proficient in, NoSQL, Relational MDM Data Modeling

• Experience in Data Governance with Collibra

• Experienced in working with different Software Development Methodologies.

• 15 plus years of Data Architecture experience

• 10 plus years of AWS Cloud Architecture experience

• AWS Glue/Athena/Storage/Lambda/Data Brew/RDS/Redshift, DMS

• Operational Data Modeling

• Analytical Modeling

• Data Governance

• Master Data Management

• Metadata Management

• Data Cataloging

• Data Engineering and ETL

Desired

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

• Knowledge of working in Federal, State and Local Government environments

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

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.