ShorePoint is a cybersecurity services firm with a focus on high-profile, high-threat private and public-sector customers who demand experience and proven security models to protect their data. We are seeking a Data Integration Engineer to provide unparalleled support to our customer through the Continuous Diagnostic & Mitigation (CDM) Program. This is a unique opportunity to shape the growth, development and culture of an exciting and emerging company in the cybersecurity market. The CDM Program is a high-profile, high-visibility, cybersecurity modernization and risk management program where you can contribute innovative solutions and consult with government agencies to enhance their Information Assurance (IA) programs and continuous monitoring capabilities. The Data Integration Engineer is responsible for the integration new capabilities and managing the integration of existing capabilities for federal agencies in support of the CDM project or customer requirements. The Data Integration Engineer will work closely with architects, engineers, and integrators to assess customer requirements and to design and support data integration from various toolsets to the integration layer and the CDM Agency and Federal Dashboards to ensure compliance with dashboard data requirements. The Data Integration Engineer will establish standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. Additionally, you will serve as a trusted advisor, providing subject matter expertise, guidance, and best practice recommendations.

 

Roles and Responsibilities

  • Design, develop, test, and provide production support of integration development process
  • Perform data analysis and data modeling to create source to target mapping documents
  • Develop Connectors and processes for Elastic to various security sensors and tools
  • Create documentation for the installation, configuration and implementation of these connectors and processes
  • Interpret functional requirements and implements them into processes between a sensor layer and dashboard layer
  • Perform functional testing in cybersecurity lab
  • Provide support to test team and to tool subject matter experts through systems engineering life cycle
  • Provide Tier 3 support to operations teams when deployed into production

Required Skills

  • 3-5+ years of Data Integration experience with a minimum 4 years of IT enterprise experience
  • 3-5+ years of experience with API such as JSON, XML, XSLT, SQL, XML and VMF (Variable Message Formats)
  • 3-5+ years of experience with code development interfacing with SQL, NoSQL, other relational and non-relational databases
  • 3-5+ years’ experience with ETL using technologies such as REST, SOAP, Native API, and WSDL, Logstash, Transporter, Python. JavaScript, XML, XSLT, JSON, SQL
  • 3-5+ years of experience using technologies such as Spark, Impala, Unix Shell/KSH, control-M, SQL, Hive, and Oracle PL/SQL
  • Hands-on experience with process building & deployment, alert framework/exception handling, connectors/listeners
  • Worked in a DevOps model leveraging the following services GitHub, Jenkins, Docker, Kubernetes, Openstack
  • Understands and applies information system or operational solution related data modeling methods and tools to perform data integration tool interoperability
  • Excellent communication, and relationship skills to articulate advanced technical topics and build consensus among clients and technical stakeholders
  • Strong interpersonal and collaborations skills working in a team-oriented environment
  • Strong analytical and problem-solving skills
  • Ability to adhere to defined processes & procedures, and suggest improvements
  • Ability to effectively prioritize and handle multiple tasks simultaneously
  • Strong technical documenting skills

Desired Skills

  • Advanced SQL, NoSQL query and scripting
  • Experience with relational database systems (i.e. DB2, SQL Server)
  • Experience with non-relational databases such as (Amazon RDBS, MongoDB, Hadoop tools)
  • Experience with Python, Java
    Understanding of data design concepts (i.e. data modeling, data mapping)
  • Overall strong background in systems engineering, security engineering, architecting, enterprise integration, and interoperability in a complex systems environment
  • Knowledge of emerging cybersecurity technologies
  • Experience modeling data, message, and service interoperability
  • Understanding of technical, operational, and management issues related to design, development, and deployment of complex and distributed systems
  • Understanding of interrelationships between critical infrastructure protection and cybersecurity
  • Familiarity with DHS Cybersecurity programs such as Continuous Diagnostics and Mitigation (CDM)
  • Knowledge and experience with Assessment & Authorization (A&A) processes in Federal environments, preferably with experience utilizing the NIST Risk Management Framework (RMF) for complex systems or networks
  • Powershell knowledge is a benefit

Education Requirement

  • BS in Computer Science or related field is required
  • Masters degree is a plus

Years of Experience Requirement

  • 3-5+ years of Data Integration experience with at least 4 years of overall enterprise IT experience is required

Certification Requirement

  • CISSP Certification preferred, but not required

Location

  • Reston, VA

Security Clearance

  • Must be able to obtain and maintain a DHS Suitability/Entry on Duty (EOD)
  • Active Secret or Top Secret clearance is preferred

Sound like the job for you?

Send us a link to your resumé or portfolio to become part of our talent pool.

Click here to apply