Data Warehousing Specialist Journeyman Level

Vickers Nolan Enterprises, LLC.

McLean (VA)

On-site

USD 130,000 - 135,000

Full time

10 days ago

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

401(k) with company match

Health, Dental & Vision Insurance

Life Insurance

Disability Insurance

Flexible Spending Account

11 Paid Holidays

PTO

Gym Membership

Corporate-Sponsored Events

Job summary

VNE seeks a Data Warehousing Specialist in a fast-paced data engineering environment. You will design, develop, and maintain end-to-end data warehousing processes, moving data to a robust data lake and keeping documentation up to date.

You will implement warehousing activities and governance, enable real-time data availability, and work across teams to improve systems and data pipelines. Requires TS/SCI clearance and Security+ readiness.

Qualifications

High school with 7-25 years of experience
Bachelor's degree in a data/IT field with 3-15 years experience
5+ years creating software for retrieving, parsing, and processing data
3+ years Python/SQL/Scala/Java
3+ years building scalable ETL/ELT workflows
Experience in collaborative cross-functional teams
Experience using GitLab/GitHub/Bitbucket
Ability to convert data into usable formats and scale data platforms
Exhibits originality and innovation on complex tasks
Ability to work with latitude in methodology and solution presentation
Security+ certification within 30 days
TS/SCI clearance required

Responsibilities

Develop, design, and maintain end-to-end data warehousing processes
Move data from source systems to a data lake and maintain pipelines
Create and maintain technical documentation for data processes
Implement corporate data warehousing activities and governance
Ensure real-time data availability for use and publication

Skills

Python/SQL/Scala/Java

ETL/ELT pipelines

Data warehousing

Git & version control

Data pipelines

Education

High School Diploma/GED

Bachelor's degree in Data or IT-related field

Tools

Databricks

Spark

AWS/Azure/Google Cloud

Redshift

Snowflake

MongoDB/Cassandra

Job description

Job Details

Level: Experienced

Job Location: National Capitol Region - NCR, VA

Position Type: Full Time

Education Level: High School Diploma/ GED

Salary Range: $130,000.00 - $135,000.00 Salary

About VNE

Vickers and Nolan Enterprises (VNE) is an engineering company that provides Government projects and programs with experienced and dedicated system architects, engineers, subject matter experts (in tactical intelligence), and program managers. VNE also develops training courses and tools to prepare warfighters to effectively employ tactical intelligence systems and provide management guidance to the Government organizations that develop these systems.

VNE has earned a reputation for exceptional performance, innovation, agility, and responsiveness in the Intelligence Community (IC). We attack our mission with a comprehensive understanding of the data available and required; skilled research, design, development, integration, and testing of systems and software solutions; expertise in cybersecurity/information assurance and technology; programmatic, acquisition, and logistics support know-how; and our own unique training curricula that enables students to excel at intelligence operations across all levels of the community.

VNE is devoted to improving tactical operations at home and abroad by enabling the seamless transition of data across the intelligence community and developing/integrating solutions to unify operations and intelligence.

VNE is a Service Disabled Veteran Owned Small Business (SDVOSB) founded in 2004 in Stafford, VA.

Minimum Qualifications

High School with 7 to 25 Years of experience
Bachelor's degree in a Data or IT-related field with 3 to 15 years of experience
5+ years of experience creating software for retrieving, parsing, and processing structured and unstructured data
3+ years of experience with Python, SQL, Scala, or Java
3+ years of experience building scalable ETL/ELT workflows for reporting and analytics
Experience creating solutions within a collaborative and cross-functional team environment
Experience using version control tools such as GitLab, GitHub, or Bitbucket
Ability to develop scripts and programs for converting various types of data into usable formats, and support project team to scale, monitor, and operate data platforms
Possesses and applies expertise on multiple complex work assignments. Assignments may be broad in nature, requiring originality and innovation in determining how to accomplish tasks.
Operate with appreciable latitude in developing methodology and presenting solutions to problems.
Ability to obtain a Security+ Certification within 30 days of start date
TS/SCI level Clearance required.

Additional Qualifications

Experience with UNIX or Linux, including basic commands and Shell scripting
Experience with a public cloud, including AWS, Microsoft Azure, or Google Cloud
Experience with distributed data or computing tools, including Spark, Databricks, Hadoop, Hive, AWS EMR, or Kafka
Experience working on real-time data and streaming applications
Experience with NoSQL implementation, including MongoDB or Cassandra
Experience with Databricks
Experience with data warehousing using AWS Redshift, MySQL, or Snowflake
Experience with Agile engineering practices
Need to be able to work out of McLean and Ft. Belvoir.

Job Description

As a Data Warehousing Specialist in Data Engineering, you can resolve a problem with a complete end-to-end solution in a fast, agile environment. If you’re looking for the chance to not just develop, but to create a system that will make a difference, we need you on our team. We’re looking for an experienced specialist like you with the skills needed to develop software and systems from vision to production-ready.

This role is more than just coding. As a Data Warehousing Specialist, you’ll use your passion to master new tools and techniques and identify needed system improvements. You’ll help design, develop, and maintain robust processes to efficiently move data from source systems to our robust data lake. You'll also help maintain and update technical documentation for processes and data pipelines.

“Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users. Support Data Lifecycle Management processes. Possess a deep understanding of state and federal regulations, industry standards and governance policies. Acquire and capture new and vetted data, apply common data classification schemas, implement archival processes and a robust recovery plan, ensure data is available in real-time for use and publication, facilitate the creation of a comprehensive data management policy, determine guidelines for retaining or destroying data.”

Essential Duties of the Job

Ability to communicate task requirement information to client in a clear and concise manner.
Must be able to sit and stand for prolonged periods of time, as well as lead and participate in meetings and working groups.
Requires visual acuity to use a keyboard.
Must be able to attend work each day, during scheduled hours, unless on travel or approved time off.
Ability to work on computer for long periods, and communicate with individuals by telephone, email and face-to-face

Physical Demands and Work Environment

While performing duties of job, employee is occasionally required to stand; walk; sit; use hand to finger, handle or feel objects, tools, or controls; reach with hands and arms; talk and hear.

Employee must occasionally lift and/or move up to 50 pounds.

Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus.

May be exposed to chemicals related to office equipment.

The noise level in the work environment is usually moderate (i.e. general office environment).

Benefits