Pioneers. Innovators. Professionals. TechINT Solutions Group (TechINT) is recognized for its knowledge and experience in providing innovative technology exploitation, operational intelligence, counter unmanned aerial systems and cyber security. TechINT Solutions Group has developed a unique analytical methodology to understand current and emerging technology that can be co-opted for nefarious purposes. Our innovative analytical methodology helps identify key variables indicative of illicit use or planned illicit use technologies.
 
TechINT Solutions Group is looking for a Data Engineer with SQL SSIS Development skills at our Reston, VA office supporting DHS's Continuous Diagnostic & Mitigation (CDM) Program. Job# TI957

This CDM role requires the ability to obtain a suitability clearance and involves working with relational and nonrelational data. The candidate will work with multiple data formats (CSV, JSON, XML), data in the Axonius cybersecurity asset management tool, creating and updating data transformation pipelines and storage (ETL/ELT) in Azure Cloud Data Services (Azure Blob Storage, Azure Data Factory, Azure SQL Database), data in an on-premise SQL databases, and SQL query language and logic to insert, delete, review, stage, and verify data quality.


Responsibilities include, but are not limited to:
  • Connecting to APIs or ingesting data from CSV flat files using Azure Services ingesting the data into Azure Blob storage for staging
  • Create data mapping and transform pipelines in Azure Data Factory putting the staged JSON data into an Azure SQL Database. Support either relational or nonrelational/NoSQL structures.
  • Create and continuously evaluate the effectiveness and efficiency of the data pipeline and SQL to enhance the overall efficacy of the data pipeline. This may require scripting to supplement SQL and tool processes
  • Design stable, reliable, and secure SQL databases that perform optimally at scale. This includes developing complex SQL to perform analysis, aggregations, complex joins, store procedures, views, etc. Includes troubleshooting errors with data outputs and/or identifying that data issues are coming from a downstream sensor tool itself
  • Support releases with updates to SQL schema, API data mappings, and ETL pipelines
  • Document all work including version control of all source code in the pipeline. This includes data requirements, relationships, data flows, and lineage. This also includes working with the test team on documenting test cases
  • Collaborate with other project stakeholders and provide Subject Matter Expertise with all questions around data in the pipeline and the ETL processes.
  • Actively participate in Agile ceremonies
  • Perform other duties as assigned

Requirements
  • BS in Computer Science or related field
  • Minimum 5+ years of experience in data with:
    • Experience in building and optimizing data architectures and pipelines with importance on Azure Data Factory or SQL Server Integration Services (SSIS)
    • Strong experience with data ETL/ELT tools, processes, and data validation
    • Complex SQL development in creating and maintaining relational database schemas
    • Data analysis looking for trend, issues, and quality across multiple data sets by querying and joining data
    • Experience with finding trends and issues across multiple data sets
    • Experience with adding metadata such as with tags and enriching data from other sources
    • Experience with relational database design, security, performance tuning, and SQL Experience with SQL Database or other relational database design, security, performance tuning, SQL queries, stored procedures, and views
    • Experience with dashboard and report generation, data analytics logic including defining queries or filters and building visualizations
    • Experience with parsing and storing nonrelational file formats (e.g., JSON, XML, and CSV)
    • Experience in data lifecycle management
    • Awareness of APIs types and call and responses to get data
    • Experience with database authentication and access and securing data in transit and at rest
    • Release management and version control system tools (e.g., Git, SVN)
  • Strong communication, interpersonal, and collaborations skills working in a team-oriented environment
  • Ability to research, test, and implement as an individual
  • Strong analytical, logical, and problem-solving skills
  • Ability to adhere to defined processes and procedures, and suggest improvements
  • Ability to effectively prioritize and handle multiple tasks simultaneously
  • Knowledge of connecting to and implementing on Cloud resources
  • Strong technical documentation skills
  • Experience in adhering to schedules for software version delivery, and release management in an Agile/DevOps environment (stories, bugs, and issue management)
  • Experience with JIRA and Agile development and release practices
  • Experience with databases, data store, authorization and access, and security in the Cloud

Preferred Qualifications
  • Experience architecting and implementing data ETL/ELT pipeline with using Azure Data Factory, SQL Server Integration Services (SSIS), AWS Glue, Google Fusion, Informatica, DataStage, etc.
  • Experience with nonrelational JSON based databases
  • Overall strong background in data engineering and architecting an enterprise integration solution using multi data sources
  • Understanding of technical, operational, and management issues related to data design, development, and deployment within multiple distributed systems
  • Scripting or programming skills (PowerShell, Python, Java, data science frameworks)
  • Building visualizations with Microsoft Power BI
  • Certification(s) in SQL a plus

Security Clearance Requirements
  • Candidate is required to be a US citizen (non-dual citizenship) with the ability to obtain DHS Suitability

Benefits
TechINT Solutions Group recognizes the need to support the well-being of our team members which is why we offer 15 personal days plus 10 paid federal holidays per year which will grow over time. We offer above industry standard medical, dental, vision, and life insurance plans along with a competitive 401k retirement plan to ensure we help support you, your family's well-being, and your retirement strategy as you grow with TechINT

PAY TRANSPARENCY NONDISCRIMINATION PROVISION
TechINT Solutions Group will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by TechINT Solution Group, or (c) consistent with TechINT Solutions Group’s legal duty to furnish information. 41 CFR 60-1.35(c)

This is a full time position
Clearance Required: Public Trust
Work Experience: Mid level

Subscribe to be notified of new jobs

Personal Information









Attachments

Other Information