Job Title: Database Architect/Developer - Data Warehouse
Location(s): Monterey, CA
Hours: Regular Full-Time
Salary Range: $120k/yr - $138k/yr
Clearance RequirementsN/A
What you will be doing: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.
Position RequirementsMinimum Requirements:Experience:
- 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:
- BS from an accredited college
- or university with a minimum of 5+ years experience
- or substitute with AS with 7+ years experience
Certifications:
- b. Require anyone of the following IAT Level II (CySA+, Security+, CND, or SSCP) Certification and CE/OS Certification.
Physical DemandsThis 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.
