Data Architect

Company: Arena Technical Resources, LLC (ATR)
Location: Washington
Posted on: September 3, 2024

Job Description:

Job Description
Job Title: Data Architect
Job Location: Washington, DC (1 day telework)
Clearance: Top Secret

What you'll do: You will support the execution of IT management and execution functions across units and systems, to build on the efficiencies gained through centralization over the last several years in order to deliver improved quality, usability, and utility. With a requirement to continuously expand, enhance, and maintain enterprise business intelligence, analytical, warehousing, technological, and user support capabilities.

Required Qualifications:

• Candidate shall have at least 5 years of experience with architecting, designing, and developing enterprise data warehouse components, including data marts, operational data stores, staging, and archival databases.
  
• Candidate shall have extensive experience building star schemas, Type I and Type II dimensions, facts to dimensions matrices, and working with large enterprise data warehousing, reporting, and Business Intelligence (BI) projects.
  
• Candidate shall have extensive knowledge in dimensional modeling concepts.
  
• Candidate shall have extensive experience in building conceptual, logical, and physical data models.
  
• Candidate shall have extensive experience in developing and maintaining a metadata repository.
  
• Candidate shall have extensive experience in at least one major RDBMS platform (DB2, PostgreSQL, or SQL Server).
  
• Candidate shall possess excellent oral and written communication skills and effectively communicate details with all levels of management.
  
• Candidate shall possess the necessary people skills to identify requirements and deliver results.
  
  
  Preferred Qualifications:
  
  
• Experience using data modeling tools, preferably ERWin and/or TOAD Data Modeler.
  
• Candidate having an understanding of ETL tools, preferably Informatica.
  
• Prior work experience with the Federal Bureau of Investigation is preferred.
  
  
  Arena Technical Resources, LLC, (ATR) is an Equal Opportunity Employer (EOE) who will provide equal employment opportunity to employees and applicants for employment without regard to race, ethnicity, religion, color, sex, pregnancy, national origin, age, veteran status, ancestry, sexual orientation, gender identity or expression, marital status, family structure, genetic information, or mental or physical disability.
  
  An Equal Opportunity Employer M/F/D/V
  Job Category: Database Admin/Developer
  Job ID: 16212
  Job Title: Data Architect
  Job Location: Washington, DC
  Annual Pay Rate: $131,000
  # Required: 1
  Apply To:
  #J-18808-Ljbffr

Keywords: Arena Technical Resources, LLC (ATR), Washington DC , Data Architect, Other , Washington, DC