Database Architect/Developer-Data Warehouse

Overview

The Database Architect/Developer-Data Warehouse is responsible for performing analysis, modification, documentation, and support of daily operations for the data warehousing and reporting system for the Defense Language Institute Foreign Language Center (DLIFLC) Academic Network Labor Contract to administer, maintain, secure, and accredit the DLIFLC Academic Network which provides the IT environment for 100% of the DLIFLC teaching and instructing for all students, staff, faculty, and guests in a learning environment at the unclassified level.

Responsibilities

• · Responsibilities include supporting the data development/sustainment lifecycle, including data profiling, ETL, and data model design and development/sustainment, testing, and support.
• · The duties include planning, installation, maintenance during or after-work hours, troubleshooting, and managing all Database Developer servers and applications.

Qualifications

Required:

• · BS from an accredited college or university with a minimum of 5 years experience or substitute with AS with 7 years experience with any one of the following IAT Level II (CySA , Security , CND, or SSCP) Certification and CE/OS Certification;
• · Minimum of 5 years of experience designing and developing data warehouses, demonstrating successful implementation of complex data warehouse projects and experience with relational database design/modeling using tools;
• · Expert-level SQL coding/querying skills in SQL Server and/or MySQL and 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) and programming skills (Python, Java)
• · Secret Clearance

Salary Range: $120,000 - $127,000

The above salary range represents a general guideline. Integral Federal considers a number of factors when determining base salary offers such as the scope and responsibilities of the position and the candidate's experience, education, skills and current market conditions.

Depending on the position, employees may be eligible for overtime, shift differential, and/or discretionary bonuses in addition to base pay. 

Company Overview

Integral partners with federal defense, intelligence, and civilian leaders to tackle their most important challenges and deliver positive outcomes. Since our founding in 1998, we have helped clients leverage existing and emerging technologies to transform their enterprises, empower growth, drive innovation, and build sustainable success. The forward-leaning solutions we deliver are tailored to each mission with a focus on keeping our nation safe and secure.

Integral is headquartered in McLean, VA and serves clients throughout the country.

We offer a comprehensive total rewards package including paid parental leave and immediate vesting in our 401(k). Give us a try and become part of a curated group of professionals at Integral Federal!

Our package also includes:

· Medical, Dental & Vision Insurance

· Flexible Spending Accounts

· Short-Term and Long-Term Disability Insurance

· Life Insurance

· Paid Time Off & Holidays

· Earned Bonuses & Awards

· Professional Training Reimbursement

· Paid Parking

· Employee Assistance Program

Equal Opportunity Employer/Protected Veteran/Disability

Salary : $120,000 - $127,000