Database Architect/Developer-Data Warehouse

Integral Federal
Monterey, CA
Category Data Analyst
Job Description
Integral Federal is seeking a Database Architect/Developer-Data Warehouse to analyze, modify, and support data warehousing and reporting systems for the Defense Language Institute Foreign Language Center (DLIFLC). This role involves maintaining data development, ETL, data model design, and testing, along with managing databases and applications. The Architect/Developer will ensure the data warehousing system is secure and accredited.

Requirements

  • BS from an accredited college or university with a minimum of 5+ years experience or AS with 7+ years experience
  • Minimum of 5 years of experience designing and developing data warehouses
  • Expert-level SQL coding/querying skills in SQL Server and/or MySQL
  • Expertise in data warehouse technologies like Snowflake, Redshift, or Teradata
  • Knowledge of ETL tools and methodologies
  • Familiarity with data modeling concepts (dimensional, star schema, snowflake schema)
  • Programming skills (Python, Java)

Benefits

  • Medical, Dental & Vision Insurance
  • Flexible Spending Accounts
  • Short-Term and Long-Term Disability Insurance
  • Life Insurance
  • Paid Time Off & Holidays
  • Earned Bonuses & Awards
  • Professional Training Reimbursement
  • Paid Parking
  • Employee Assistance Program
]]>