NCIS Data Engineer | Active Secret clearance

Description

The role sits in the IT Technology Operations division of the NCIS ITD organization in Quantico, VA. NCIS is the Department of the Navy component that leads criminal investigation, law enforcement, counterterrorism, counterintelligence and cyber matters. It has about 2,000 personnel, with 700 at headquarters and the rest at offices worldwide. It also holds exclusive investigative jurisdiction over non-combat criminal, terrorism, sabotage, espionage and subversion cases across the DON.

The job supports the agency's work against criminal, terrorist and foreign intelligence threats to the DON at sea, on land and in cyberspace. You will help build a data hub that takes in raw data, including law enforcement data, and turns it into clean, usable datasets for analysis, visualization and machine learning. The goal is to grow the data ecosystem with richer context while keeping the agility to try new ideas.

The company is a global technology and professional services firm with about 26,000 staff in more than 50 countries. It serves U.S. government, defense and intelligence customers in AI, cloud, cyber and software development.

Responsibilities

• Design, build and run scalable end-to-end data pipelines covering transformation, data models, schemas, metadata and workload management.
• Work with large, varied datasets to build and tune pipelines, pipeline architectures and integrated datasets using standard data integration tools.
• Advise decision makers on IT matters as the agency builds its new data hub and moves toward data-driven processes.
• Identify data sources, plan how data will be acquired and integrated, and set best practices for governance, quality, storage and use in analytics and business intelligence.
• Build and deepen your knowledge of data hubs and the wider range of data storage, including warehouses, lakes and marts.
• Manage data across IT infrastructure, including the data hub, applications, cloud and network resources.
• Put cloud architectures and platforms to work, including moving data from on-premises systems to the cloud.
• Cleanse and manage data so it meets operational needs.
• Set enterprise standards for a repeatable system development lifecycle for reference and master data, including shared rules for naming, abbreviations and acronyms.
• Recommend and carry out changes to the data environment, make schema changes, and advise on updates to applications and data sources so data stays accurate and follows the governance model.
• Combine business and operational data and enrich it with data about customers, including data they generate.
• Extend the data infrastructure to take in sensor, device and other new sources.
• Suggest ways to make how NCIS acquires, stores, manages, shares and uses its data more efficient and effective.
• Work with business users and stakeholders to release more actionable, high-quality data on key operational and tactical activities.
• Build technology solutions that give users a platform, training and standard tools for querying, data mining, statistical analysis, reporting, scenario modeling, visualization and dashboards. Support both a central hub and an analytics-as-a-service model so data can be shared across the enterprise.
• Write documentation for data engineering work, such as SOPs.
• Define data policies, standards and procedures that improve quality, availability, accessibility, security and usability, and that enforce enterprise information management program requirements.

Requirements

• Hold an active Secret clearance now.
• Be a U.S. citizen.
• Be able to obtain a TS/SCI clearance after hire.
• Have at least 10 years of experience in data management, including data integration, modeling, optimization and data quality, or in other areas directly relevant to data engineering.
• Have a bachelor's degree in a technical discipline. An additional 4 years of experience may be considered in place of the degree.
• Hold CompTIA Security+ CE.
• Have strong experience designing, building and managing pipelines for data transformation, data models, schemas, metadata and workload management.
• Have strong experience with large, varied datasets and with building and tuning pipelines and integrated datasets using traditional data integration technologies.
• Have strong experience optimizing existing ETL processes and data preparation flows, and moving them into production.
• Have strong experience writing object-oriented scripts in Python, Java or Scala.
• Have strong SQL and PL/SQL skills for relational databases.
• Have experience on AWS or Azure.
• Have experience with ETL/ELT, data replication and CDC, message-oriented data movement, and API design and access.
• Have experience with data preparation tools such as Databricks, Trifacta, Paxata and Unifi, using them to cut down or automate tedious preparation work.
• Have basic experience working with data governance, quality and security teams, data stewards, and privacy and security officers to get pipelines into production to the right standards.
• Work across cloud, on-premises and hybrid environments, multiple operating systems, and containerization tools such as Docker, Kubernetes and AWS Elastic Container Service.
• Be able to work with IT and business teams to fold analytics and data science output into business processes and workflows.
• Knowledge of machine learning, AI and data analytics (a plus).
• Experience in a data management or CDO office (a plus).
• Deep knowledge of law enforcement information or prior law enforcement, DoW or DON experience (a plus).
• AWS Certified Data Engineer Associate certification (desired).
• Experience with Databricks, Snowflake, Apache Kafka, Airflow, Spark and ETL tools (desired).
• Experience with DON Jupiter (desired).

Conditions

Based in Quantico, VA, with a hybrid schedule: 3 days onsite and 2 days remote.

Full-time, 40 hours per week.

No travel required.

The likely salary range is $142,792 to $166,750. This is not a guaranteed figure. Pay depends on experience, geographic location and possibly contract terms, and may fall outside this range.

As part of hiring, you will complete an identity verification step using biometrics and AI to confirm your identity and prevent fraud, and you agree to the collection and use of your biometric data for that purpose. You must be on camera for virtual interviews.

The company is an equal opportunity employer that welcomes individuals with disabilities and protected veterans.

Benefits

• Medical plan options, some with Health Savings Accounts, plus dental and vision plans.
• 401(k) with pre-tax and post-tax contributions up to IRS limits and a company match.
• Full flex work weeks where possible.
• Paid time off, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
• Short and long-term disability, life, accidental death and dismemberment, personal accident, critical illness, and business travel and accident insurance, provided or available.
• An AI-powered career tool that suggests career steps and learning opportunities.
• An internal mobility team to help you reach your career goals.
• Competitive pay and a military-friendly workplace.