UNKNOWN

FEED

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. Responsibilities include supporting the data development/sustainment lifecycle, including data profiling, ETL and data model design and development/sustainment, testing, and support.

YEAR

Job Title: Database Architect/Developer - Data WarehouseLocation(s): Monterey, CAHours: Regular Full-TimeSalary Range: $120k/yr - $138k/yrClearance RequirementsN/AWhat 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:<ul><li>5+ years of experience designing and developing data warehouses.</li><li>Proven track record of successfully implementing complex data warehouse projects</li><li>Experience with relational database design/modeling using tools. Expert-level SQL coding/querying skills in SQL Server and/or MySQL</li><li>Proficient in SQL and advanced SQL query optimization techniques</li><li>Expertise in data warehouse technologies like Snowflake, Redshift, or Teradata</li><li>Knowledge of ETL tools and methodologies</li><li>Familiarity with data modeling concepts (dimensional, star schema, snowflake schema)</li><li>Programming skills (Python, Java) may be beneficial depending on the environment</li></ul>Education:<ul><li>BS from an accredited college</li><li>or university with a minimum of 5+ years experience</li><li>or substitute with AS with 7+ years experience</li></ul>Certifications:<ul><li>b. Require anyone of the following IAT Level II (CySA+, Security+, CND, or SSCP) Certification and CE/OS Certification.</li></ul>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.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 that’s why we are seeking you!We understand and respect the dedication and sacrifice required to serve our nation’s 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.

JASINT

Database Architect/Developer - Data Warehouse

Computer Programming

Data Modeling

Data Profiling

Data Warehousing

Database Administration

Database Architecture

Database Design

Database Extract Transform and Load (ETL)

Database Programming

Federal Government

Flexible Spending Accounts

Homeland Security

Java

Microsoft SQL Server

MySQL

NCR Teradata

Python Programming/Scripting Language

Query Optimization

Relational Databases (RDBMS)

SQL (Structured Query Language)

Snowflake Schema

Star Schema

Telephone Skills

Testing

Tuition Reimbursement

clearcompany

Ops Tech Alliance (OTA) was founded by former National Security and Special Operations professionals with over 100 years of combined experience and was formed with a singular focus: to bridge the gap between operations and technology to enable mission success. Ops Tech Alliance (OTA) is seeking a Database Architect/Developer (Data Warehouse) to support the Defense Language Institute Foreign Language Center (DLIFLC) at the Presidio of Monterey, CA.

Database Architect/Developer   Salary Range: $92,000 to $107,000 per year  Ops Tech Alliance (OTA) is seeking a Database Architect/Developer (Data Warehouse) to support the Defense Language Institute Foreign Language Center (DLIFLC) at the Presidio of Monterey, CA. This role performs analysis, modification, documentation, and support of daily operations for the data warehousing and reporting environment. This position is contingent upon contract award.   Responsibilities 
• Support the full data development lifecycle, including data profiling, ETL, and data model design. 
• Design and develop dimensional data models and data warehouse structures. 
• Plan, install, and maintain database servers and applications, including after-hours work as required. 
• Optimize complex SQL queries for performance and scalability. 
• Document data models, ETL pipelines, and warehouse processes. 
• Collaborate with application developers, BI analysts, and stakeholders on reporting initiatives. Required Qualifications 
• AA/AS in a related discipline from an accredited college or university, OR 3+ years of related experience in lieu of degree. 
• Active IAT Level II certification (one of: CCNA Security, CySA+, GICSP, GSEC, Security+ CE, or SSCP) plus applicable CE/OS certification. 
• 5+ years designing and developing data warehouses. 
• Demonstrated track record implementing complex data warehouse projects. 
• Expert-level SQL coding and query optimization in SQL Server and/or MySQL. 
• Familiarity with data modeling concepts (dimensional, star schema, snowflake schema). 
• Knowledge of ETL tools and methodologies. 
• U.S. Citizenship; ability to obtain and maintain a Common Access Card (CAC). Desired Qualifications 
• BA/BS in Computer Science, Information Systems, or related field. 
• Experience with Snowflake, Redshift, or Teradata. 
• Programming experience in Python or Java. 
• Prior DoD or Army experience. 
 
Company Overview Ops Tech Alliance (OTA) was founded by former National Security and Special Operations professionals with over 100 years of combined experience and was formed with a singular focus: to bridge the gap between operations and technology to enable mission success.  We are a certified Service-Disabled Veteran-Owned Small Business (SDVOSB).  Team Member Benefits <ul><li>Competitive Pay</li><li>Paid Time Off</li><li>Tuition Assistance</li><li>Medical, Prescription, Dental & Vision Coverage</li><li>Life Insurance</li><li>Work-life Balance</li></ul>Our employees have achieved incredible things working on some of the most important technology and security projects in locations around the world to safeguard national security.  We focus on hiring top talent and we want you to join our team.   OTA is an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Python Jobs in Seaside, CA

Resume Resources

Get noticed by top employers!

Python Jobs in Seaside, CA

Database Architect/Developer - Data Warehouse JASINT

Database Architect/Developer Ops Tech Alliance

Resume Resources