Data Engineer/Asymmetric Threat Statistical Analyst with Security Clearance
Company Overview Operational Intelligence, an Avantus Federal Company, a NewSpring Holdings Company, is a mission-focused services and solutions company headquartered in McLean, VA. Drawing upon its heritage companies' histories of consistent growth and high performance in the federal services market, Avantus ensures eminence is earned, sustained and grown. Avantus' services and solutions are designed, tailored, and executed based on our long history of helping our Homeland Security, Defense, Intelligence, and Federal Civilian customers solve complex challenges. Our capabilities include Project & Portfolio Management, Facilities, Acquisition & Sustainment, Systems Engineering Technical Services, Operations & Analysis, Transformation & Advisory Services, Data & Software Solutions, Digital Innovation, and Augmented Intelligence. Position Overview We have an opening for a Data Engineer/Asymmetric Threat Statistical Analyst to support our DTRA customer. Responsibilities As an Asymmetric Threat Statistical Analyst, you will * Provide analytical support to our government client and forward deployed units * Counter improvised threats and the networks that finance, build, or employ such threats * Provide large-scale advanced analytics support; collecting, parsing, transforming, and integrating relevant data in support of projects; and providing operational, systems, and intelligence analysis to support the mission. * Provide data supporting strategic and operational requests from deployed and deploying units. These data sets may be used to: assist decision makers with risk assessments, prioritization, and/or to provide leadership with quantitative organizational assessments to support functional evaluations. * Develop, document, implement, and automate ETL (extract transform load) processes using SQL and other analytical programming tools that most efficiently import structured, semi-structured, and unstructured data from new and/or dynamic data sources, ensuring data validity, reliability, and availability to users. * Collaborate with team members to ensure retrieval of information pertinent to current work and timely dissemination of counter asymmetric threat products. Required Qualifications * Current Top Secret/Specialized Compartmented Information Security Clearance #AvantusClearedJob * Master's in a technical discipline plus three (3) years of experience; or Bachelor's in a technical field plus five (5) years of experience. * Significant programming experience in SQL (including VBA, and macro). * Significant experience programming in at least one other programming language (Python, R, Perl, C++) * Effectively communicate both orally and in writing. Preferred Qualifications * SQL Certified Programmer certificate prior to employment. * Degree in one of the following disciplines: Operations Research, Applied Mathematics, Engineering, Science, Computer Science, Mathematics, or Statistics. * Experience using Python libraries including pandas, scipy, numpy, matplotlib, requests, or similar libraries in another programming language. * Knowledge of how to utilize business intelligence tools and processes that improve readability of and access to data, through the creation of stored/scheduled processes and effective visualization. * Ability to create complex programs that ingest, parse, clean, transform, and analyze large (millions of records) datasets; to apply mathematical and statistical models to real-world data, and; to deliver analytical results through written and oral presentations. * Prior experience utilizing ETL software (eg, PowerCenter, Pentaho, PLSQL), Business Intelligence software (eg, SAS BI, Oracle BI, Cognos, Business Objects), or Geospatial Information Systems (GIS) software (eg, ESRI ArcGIS suite) is preferred. * Experience interacting with "big data" systems such as Hadoop or Amazon Web Services (AWS). Experience using Alteryx Designer to build/manage workflows. * Prior experience as an all-source intelligence analyst or ORSA * Prior experience with Counter UAS operations. Company EEO Statement Avantus Federal is an equal opportunity employer and Vietnam Era Veterans Readjustment Assistance Act (VEVRAA) federal contractor. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity, protected veteran status, status as a qualified individual with a disability, or any other category protected by law. Avantus hires and promotes individuals solely on the basis of their qualifications for the job to be filled.