RICEFW Technologies Inc ยท 7 hours ago
Enterprise AWS Data Architect - Mostly REMOTE Need to come into the office for meetings
Trenton, NJ
Contract
Remote
Senior Level, Lead/Staff
15+ years exp
Maximize your interview chancesBusiness IntelligenceConsulting
Insider Connection @RICEFW Technologies Inc
Get 3x more responses when you reach out via email instead of LinkedIn.
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 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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
15+ years of experience in Business/working as a Data Architect, Data Modeler, Data Analyst
Understand the AWS Cloud Architecture and the basics of its infrastructure
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 in State
Proficient in NoSQL, Relational MDM Data Modeling
Experience in Data Governance with Collibra
Experienced in working with different Software Development Methodologies
Data Architecture 15 Years
AWS Cloud Architecture 10 Years
AWS Glue/Athena/Storage/Lambda/Data Brew/RDS/Redshift, DMS 10 Years
Operational Data Modeling Skills 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
Preferred
Mainframe Technologies including Cobol, Db2, IMS DB/DC, VSAM, JCL 5 years
Knowledge of working in Federal, State and Local Government 5 years
Company
RICEFW Technologies Inc
RICEFW Technologies Inc is a technology consulting firm and solutions provider with extensive experience in IT Staff Augmentation and consulting services since 2010.
51-200 employees
H1B Sponsorship
RICEFW Technologies Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (50)
2022 (78)
2021 (52)
2020 (38)
Funding
Current Stage
Growth StageCompany data provided by crunchbase
