Database Architect/Developer - Data Warehouse

Job Title: Database Architect/Developer - Data Warehouse Location(s): Monterey, CA Hours: Regular Full-Time Salary Range: $120k/yr - $138k/yr Clearance Requirements N/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 Requirements Minimum 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 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. Why JASINT? At JASINT, we proudly boast a together we can attitude. That is only possible with a strong talented team. Our goal is to answer the call to provide top mission and Warfighter support at all levels, and thats why we are seeking you! We understand and respect the dedication and sacrifice required to serve our nations greatest efforts, and our commitment, in turn, is to Support You! JASINT cares about your work-life balance and offers competitive benefits to help you at every stage of your personal and professional life by providing the following: Retirement/401k with an employer match, employer-paid health, dental, vision for employees, flexible spending accounts (HSA/FSA), company partially funded HSA, STD/LTD, professional development, tuition and certification reimbursement, spot award recognition, PTO, Floating Holidays. JASINT offers internal and external referral bonuses for all cleared exceptional talent we hire! Friends of yours are friends of JASINT! JASINT provides equal employment opportunities to all employees and applicants without regard to race, color, ancestry, national origin, gender, sexual orientation, marital status, religion, age, disability, gender identity, genetic testing results, or service in the military. Equal employment opportunity applies to all terms and conditions of employment, including hiring, placement, promotion, termination, layoff, recall, transfer, leave of absence, compensation, and training. JASINT participates in E-Verify and will provide the federal government with I-9 information to confirm that all new hires are authorized to work in the U.S. To learn more about E-Verify, please visit dhs.gov/e-verify.