user avatar

Database Architect/Developer - Data Warehouse

JASINT Consulting and Technologies, LLC

Posted today

Job Requirements

Monterey, CA
Secret Polygraph Unspecified
Career Level not specified
$120,000 - $138,000

Job Description

Job Title: Database Architect/Developer - Data Warehouse

Location(s): Monterey, CA

Hours: Regular Full-Time

Salary Range: $120k/yr - $138k/yr

Clearance Requirements

This position requires a current and active Secret Clearance at the time of application.

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 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.
group id: 10268897