CA-Database Architect/Developer - Data Warehouse

{
  "content_hash": "46d0ed444861b5d78a4678fed292c18ff17c7589667dbdb0a96265774b87e455",
  "source_hash": "47bcb34f3b8de7ef74010121136df760b40a0964c42cf43b625262422e923835",
  "last_changed_at": "2026-06-14T10:30:46.013Z",
  "active_status": "deleted"
}

{
  "language": "en",
  "location": {
    "raw": "Monteray, California, 93940, United States",
    "city": "Monteray",
    "region": null,
    "country": "United States",
    "is_remote": true,
    "confidence": 0.95
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-12T10:33:39.088Z",
  "launch_scope": {
    "reason": "bamboohr_production_catalog",
    "included": true,
    "location": {
      "raw": "Monteray, California, 93940, United States",
      "city": "Monteray",
      "region": null,
      "country": "United States",
      "is_remote": true,
      "confidence": 0.95
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": "remote",
  "salary_period": null,
  "workplace_type": "remote",
  "salary_currency": null
}

{}

{
  "list_job": {
    "id": "372",
    "isRemote": null,
    "location": {
      "city": "Monteray",
      "state": "California"
    },
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "province": null
    },
    "departmentId": null,
    "locationType": "0",
    "jobOpeningName": "CA-Database Architect/Developer - Data Warehouse ",
    "departmentLabel": null,
    "employmentStatusLabel": "Full-Time"
  },
  "detail_errors": [],
  "detail_job_opening": {
    "location": {
      "city": "Monteray",
      "state": "California",
      "postalCode": "93940",
      "addressCountry": "United States"
    },
    "datePosted": "2026-06-10",
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "countryId": null
    },
    "description": "<p><span style=\"color: rgb(0, 0, 0); font-family: Inter, sans-serif; font-size: 14pt; font-weight: bold\">**Position is contingent upon contract award**</span></p>\n<p><br></p>\n<p><span style=\"color: rgb(72, 65, 63); font-family: Inter, sans-serif; font-size: 12pt; font-weight: bold\">Location: Monterey, California</span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 12pt\"><span style=\"color: rgb(72, 65, 63); font-weight: bold\">Travel Required: No</span><span style=\"color: rgb(72, 65, 63); font-weight: bold\"><br></span><span style=\"color: rgb(72, 65, 63); font-weight: bold\">Remote Type: No</span><span style=\"color: rgb(72, 65, 63); font-weight: bold\"><br></span><span style=\"color: rgb(72, 65, 63); font-weight: bold\">Clearance: n/a</span></span></p>\n<p><br></p>\n<p><span style=\"color: rgb(0, 0, 0); font-family: Inter, sans-serif; font-size: 12pt\">Sunayu, LLC has an exciting new opportunity to support the Defense Language Institute Foreign Language Center (DLIFLC). We are looking for professionals to help us manage and modernize the IT infrastructure that drives world-class language instruction for the DLIFLC’s diverse academic community.</span></p>\n<p><br></p>\n<p><span style=\"color: rgb(0, 0, 0)\"><span style=\"font-size: 10pt\"><span style=\"font-size: 10pt\"><span style=\"font-size: 12pt\">The person in this position is responsible for performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system. Responsibilities include supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support. The duties will include planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications.</span><br></span></span><br></span><span style=\"color: rgb(0, 0, 0)\"><span style=\"font-size: 12pt; text-decoration: underline\"><span style=\"font-weight: bold\">Position Requirements</span></span></span></p>\n<p><span style=\"color: rgb(0, 0, 0); text-decoration: underline\"><span style=\"font-size: 12pt\">Experience:</span></span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Minimum of 5 years of experience designing and developing data warehouses.</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Proven track record of successfully implementing complex data warehouse projects</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Experience with relational database design/modeling using tools. Expert-level SQL coding/querying skills in SQL Server and/or MySQL</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Proficient in SQL and advanced SQL query optimization techniques</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Expertise in data warehouse technologies like Snowflake, Redshift, or Teradata</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Knowledge of ETL tools and methodologies</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Familiarity with data modeling concepts (dimensional, star schema, snowflake schema)</span></li>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Programming skills (Python, Java) may be beneficial depending on the environment</span></li>\n</ul>\n<p><span style=\"color: rgb(0, 0, 0); font-size: 12pt; text-decoration: underline\"><span>Education:</span></span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">Associate’s degree (AA/AS) in Information Technology or related field OR 2‑year technical diploma OR 2+ years of directly relevant hands‑on IT support experience. Bachelor’s preferred, not required.</span></li>\n</ul>\n<p><span style=\"color: rgb(0, 0, 0); font-size: 12pt; text-decoration: underline\"><span>Certifications:</span></span></p>\n<ul>\n<li><span style=\"color: rgb(0, 0, 0); font-size: 12pt\">IAT Level I (A+ CE or Network+ CE) — required. IAT Level II (Security+, CySA+, or SSCP) — preferred for shift leads/escalation or when privileged admin access is assigned. Vendor OS cert (Windows or Apple) preferred for imaging/break‑fix.</span></li>\n</ul>\n<p><br></p>\n<p><span style=\"font-size: 12pt; font-weight: bold\">Physical Demands</span></p>\n<p><span style=\"font-size: 12pt\">This is largely a sedentary role; however, some filing is required. The ability to move files, open filing cabinets, and bend or stand as necessary would be required.</span></p>\n<p><br></p>\n<p><br></p>\n<p><span style=\"text-decoration: underline\"><span style=\"font-family: Inter, sans-serif; font-size: 12pt; font-weight: bold\">Who We Are At Sunayu</span></span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Sunayu, LLC serves as a premier technology partner to the Defense and Intelligence communities, delivering mission-critical engineering solutions across the nation. Our operations are anchored in a commitment to trust, accountability, and ethical transparency, ensuring the high-performance outcomes necessary to protect our country's most vital interests. </span></p>\n<p><br></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt; font-weight: bold\">Culture</span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Our strength lies in our community: <span style=\"color: rgb(29, 28, 29)\">Our team prioritizes collaboration, professional growth, and encourages open communication</span>. At Sunayu, we don't just secure the mission—we grow together.</span></p>\n<p><br></p>\n<p><span style=\"color: rgb(51, 51, 51); font-family: Inter, sans-serif; font-size: 10pt; font-weight: bold\">Career Development</span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">We support and encourage our team members to continue their professional growth by providing company-reimbursed training and continuing education of up to $5,000 per year. We also participate in many industry conferences and events where we share our expertise and experiences.</span></p>\n<p><br></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt; font-weight: bold\">Pay Rate</span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Salary range considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, education/ training, key skills, as well as market and business considerations when extending an offer.</span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt\"><br></span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt\"><span style=\"font-weight: bold\">Benefits</span></span></p>\n<ul>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">3 Medical Plan Options</span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Dental and Vision </span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">FSA, DCFSA, HSA</span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Life/AD&amp;D Insurance</span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Short-Term &amp; Long-Term Disability </span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Employee Assistance Program (EAP)</span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Training and Educational Assistance</span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Paid Time Off (PTO)</span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">11 Federal holidays </span></li>\n<li><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">401k plan with up to a 6% match (100% immediate vesting) </span><br></li>\n</ul>\n<p><br></p>\n<p><span style=\"color: rgb(10, 10, 10); font-family: Inter, sans-serif; font-size: 10pt; font-weight: bold\">Equal Opportunity Employer</span></p>\n<p><span style=\"font-family: Inter, sans-serif; font-size: 10pt\">Sunayu, LLC is an Equal Opportunity/Affirmative Action Employer.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran status, disability status, marital status, genetic information, medical condition, or any other characteristic protected by law.</span></p>\n<p><br></p>",
    "compensation": "$120,000 - $138,000",
    "departmentId": null,
    "locationType": "0",
    "seekPromoted": false,
    "jobCategoryId": "18390",
    "jobOpeningName": "CA-Database Architect/Developer - Data Warehouse ",
    "departmentLabel": "",
    "jobOpeningStatus": "Open",
    "minimumExperience": "Mid-level",
    "jobOpeningShareUrl": "https://sunayu.bamboohr.com/careers/372",
    "employmentStatusLabel": "Full-Time"
  }
}