Data Modeler/Architect

Data Modeler/Architect

23 Dec 2021
California, Sandiegocaliforniaus, 92103 Sandiegocaliforniaus USA

Data Modeler/Architect

Vacancy expired!

Data Modeler / Architect

Location: San Diego, CA

Job Summary:

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

Security Clearance:

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)

Physical Requirements

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.

Related jobs

Job Details

Jocancy Online Job Portal by jobSearchi.