Data Architect II

San Diego, CA
Job Type
Senior level

Job Description

Data 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:

  • Understanding and experience in a broad range of data and database competencies
  • 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
  • Ability to analyze data flow from source to destination in order to perform normalization, make it consumable, and present in manner that is usable by the end user community
  • Experience with Microsoft SQL Server highly desired
  • Experience developing ETL processes with SQL Server Integration Services (SSIS) highly desired
  • Designing and coding database tables to store the application's data
  • Data modeling to visualize database structure
  • Reviewing query performance and optimizing code
  • Creating table indexes to improve database performance
  • Working with application developers to create optimized queries
  • Programming views, stored procedures, and functions
  • Ability to prioritize and meet deadlines
  • Excellent critical thinking skills
  • Other duties as assigned


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.

  • 5+ years of practical experience minimum
  • Must possess and maintain a CompTIA Security+ Certification
  • Must be a Certified Business Intelligence Professional
  • Understanding and experience in a broad range of data and database competencies
  • Experience with Azure, Power BI, and Python preferred
  • 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 US Citizen and able to obtain and maintain the security clearance required for the position

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.

Ref #
30+ days ago
Last updated 30+ days ago

Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.