Rivet Operations Company, LLC has an opening for a Data Architect to join our rapidly growing team. The Data Architect is responsible for the development, management, and maintenance of the data model, data rules, and all tasks impacting usability of application data
Essential Duties and Responsibilities: (Not listed in order of importance; other duties may be assigned) and must be able to perform the following with minimal guidance:
Manage, Maintain and Support Day-to-Day Operations of NDMS, SingleSite, OneNDMS, Data Convergence, Corporate Reporting System (CRS) and Other Initiatives.
Model in Kimball's dimensional methodology using the Project Lead's requirements.
Design/modify logical and physical dimensional models using Erwin to meet business' reporting requirements.
Prepare and document standards and procedures for dimensional data modeling and naming conventions.
Perform a variety of activities including data modeling and documentation, database design tasks and data and system analysis, data queries and database design tasks with a team with various skills. These efforts include, but not limited to, capturing and developing data requirements, database design support, data modeling interpretation, application design and prototyping solutions.
Perform data modeling and subject matter support to ensure data specifications and requirements to meet long-term needs. This includes analyzing and defining data requirements and specifications.
Create data models (both transacting and warehouse applications) using Kimball methodology, industry best practices and standard processes to ensure high quality data to reduce redundancy and support efficient reporting.
Develop and maintain data standards, process documentation and templates that assist in a common understanding of data models and data marts and the processes that involve in developing them.
Support data standardization efforts including best practice standards, naming conventions, and synchronization of shared data requirements across subject areas throughout
Work within the team to assist in the design of the overall ETL data warehouse architecture: Understanding of ETL strategy, staging databases and data quality.
Support database development including the build and maintenance of stored procedures and advanced SQL/PLSQL techniques.
Extensive working knowledge of current SAP Business Intelligence tools, Oracle SQL and PL/SQL and databases, Toad, Erwin, and Kimball Methodology.
Extensive experience with data modeling (knowledge of conceptual, logical and physical models).
Perform data analysis of extraction source systems and provide architecture guidance for data models
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
7+ years of practical experience minimum
Must possess and maintain an IAT level II certification IAW DoD 8570.01-M
Understanding and experience in a broad range of data and database competencies
Experience assessing impacts of legacy systems and addressing data related problems of system integration and compatibility
Experience defining an overall data architecture as it relates to task goals during the analysis, design, planning phases and implementation of each project
Ability to prioritize and meet deadlines
Strong critical thinking skills
Self-starter requiring minimal supervision
Proficient problem-solving skills
Strong verbal communication to effectively express concepts, plans, and proposals
Works well in a team environment
Enjoys the challenges of a dynamic research and development project
Must be a
Position requires a Secret clearance
Tool-set used on site:
SAP Business Intelligence (Business Objects) 4.x (Webi, Crystal, Xcelsius)
Oracle SQL /PLSQL
TOAD and SQLNavigator
Informatica (ETL Tool)
CA Erwin (Data Modeling tool)
Work may involve sitting or standing for extended periods of time. Position may require typing and reading from a computer screen. Must have sufficient mobility, including but not limited to bending, reaching, and kneeling to complete daily duties in a timely and efficient manner. There is a possibility that due to parking availability and location of work, walking moderate to long distance may be required. Possible lifting up to 25 lbs.
Please note: Rivet Operations Company LLC reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing. Positions functions and qualifications may vary depending on business needs.
Rivet Operations Company LLC is an equal opportunity employer and does not discriminate against applicants based on race, color, creed, religion, medical condition, legally protected genetic information, national origin, sex (including pregnancy, childbirth or related medical condition), sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status or legally protected characteristics.