> Markdown version of [/jobs/ext/597158-ca-database-architect-developer-data-warehouse](https://www.wearedevelopers.com/jobs/ext/597158-ca-database-architect-developer-data-warehouse). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# CA-Database Architect/Developer - Data Warehouse

- **Company:** Sunayu, LLC
- **Location:** Monterey, CA, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Adobe Analytics, Java (Programming Language), Microsoft Windows, Computer Programming, Databases, Extract Transform Load (ETL), Data Profiling, Data Warehousing, Relational Databases, Python (Programming Language), Microsoft SQL Server, MySQL, Query Optimization, Standard Sql, Teradata SQL, Snowflake, Information Technology, Star Schema
- **Published:** June 12, 2026
- **Apply:** https://www.clearancejobs.com/jobs/8971369/ca-database-architectdeveloper-data-warehouse

## About the Role

* Minimum of 5 years of experience designing and developing data warehouses.
 * Proven track record of successfully implementing complex data warehouse projects
 * Experience with relational database design/modeling using tools. Expert-level SQL coding/querying skills in SQL Server and/or MySQL
 * Proficient in SQL and advanced SQL query optimization techniques
 * 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) may be beneficial depending on the environment

Education:

 * 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.

Certifications:

 * 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.

Physical Demands

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.

## Description

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.


## Related Videos

- [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Branch your database like your code:  How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)
- [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)