Database ArchitectDeveloper 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 Experience:

Staff IC