Data Engineer with Security Clearance - McLean, United States - Vector Talent Resources

Description

Vector Talent is seeking a Data Engineer supporting Naval Criminal Investigative Service (NCIS).

The Data Engineer will provide engineering, application analysis, design, development, application integration, system architecture services to the support of enhancements to the NCIS Criminal Investigative capabilities.

Location:

Remote Security Clearance:

Secret Responsibilities:

Responsible for collecting, managing, and converting raw data into information that can be interpreted by data scientists and business analysts.

Data accessibility is their ultimate goal, which is to enable organizations to utilize data for performance evaluation and optimization
Works on overall Data Architecture
Collect Data and conduct research
Create models/identify patterns
Automate Tasks when applicable
Perform data processing, algorithm/structures, pipeline orchestration, data quality, governance, discovery
Work with structured and unstructured data, blob data
Develop and work with APIs
Collect and organize data using data warehousing techniques and file storage technologies
Perform ELT and ETL processes
Gather data requirements

Develop and maintain scalable data pipelines and build out new API integrations to support continuing increases in data volume and complexity.

Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increase data accessibility, and foster data-driven decision-making across the organization.

Implement processes and systems to monitor data quality, ensure production data accuracy, and ensure key stakeholder and business process access.

Write unit/integration tests, and contribute to engineering wiki, and documents.
Perform data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.
Work closely with a team of front-end and back-end engineers, product managers, and analysts.
Design data integrations and data quality framework based on established requirements.

Collaborate with stakeholders to gather data requirements, understand data sources, and ensure data quality and integrity throughout the ETL process.

Implement data validation, cleansing, and enrichment techniques to improve the accuracy and completeness of data.
Monitor and troubleshoot ETL processes to identify and resolve issues in a timely manner.
Work in a team environment to design, develop, and support a software system that is undergoing modernization.
Participate in developing new functionality migrating the application into the cloud and introducing new technologies into the tech stack.
Participate in Agile Scrum SDLC activities.
Support developing Agile SDLC phase documentation.
Perform unit and integration testing of software/systems prior to release to the users for user acceptance testing.

Minimum Requirements:
Active Secret

IAT Level II (CNNA-Security, CySA+, GICSP, GSEC, Security+CE, CND, SSCP)
8+ years of programming and software development experience including analysis, design, development, implementation, testing maintenance, quality control, troubleshooting, and software upgrade
Familiarity/knowledge of XML, HTML, CSS, JavaScript/AJAX, PHP, and ASP.NET
Highly skilled at PL/SQL (and SQL in general). Both in the areas of functional querying and in the areas of optimization and organization
Prior experience doing refits on stored procedures
Can function as a gatekeeper of good data-tier design and implementation decisions
Supports and empowers developers to make changes and move the data layer forward
Good understanding of how to build PL/SQL reports to support a Reports On Demand initiative
Good knowledge of database deployments and source control is critical
Good communication skills and a strong security/ownership mindset

Preferred Qualification:
Oracle DBA experience as a secondary skillset might also be nice for providing support here and there
Power BI experience
MySQL experience