Intern Security Data Engineering & Software Development

Role Description

We are seeking a motivated Intern to support a targeted data engineering and software development project focused on modernizing an existing data-processing workflow. The project involves migrating a Python- and Excel-based process to a scalable, SQL-backed architecture with a secure web-based interface.

While the data being processed relates to vulnerability information, the primary focus of the role is on data modelling, backend development, and application design. This internship offers strong hands-on learning opportunities in data engineering, full-stack development, and system design, with exposure to real-world operational datasets.

Responsibilities

The intern will contribute to the design and implementation of a system that:

• Adapts an existing Excel-based data processing workflow to run on an SQL Server backend
• Works with Excel files containing structured vulnerability-related datasets from multiple sources
• Translates a Python (pandas-based) processing pipeline into a database-backed solution
• Supports data unification, enrichment, and prioritization logic across multiple inputs
• Incorporates historical data and user-provided inputs for enrichment and analysis
• Designs and implements:
• A relational database schema and data retention strategy
• Backend logic to replicate existing processing behavior
• A secure web-based frontend to present and interact with the data
• Ensures the system:
• Retains monthly historical data for up to one year
• Replicates the full existing process, with data segregation handled at the presentation layer

Key Learning Opportunities

During this internship, you will gain practical experience in:

• Data engineering principles and ETL-style workflows
• Relational database design and historical data retention
• Backend application development and data access patterns
• Frontend development and data visualization
• Translating analytical scripts into maintainable, scalable systems
• Working with real enterprise datasets in a production-oriented context

Required Skills & Knowledge

• SQL (querying, joins, schema design, data manipulation)
• Python, particularly for data processing (e.g., pandas)
• Database design fundamentals
• Web development basics (frontend and backend concepts)
• Understanding of structured data workflows and transformations

Nice-to-Have

• Experience or academic exposure to data engineering concepts
• Familiarity with additional programming languages or frameworks suitable for backend or web development
• Experience with REST APIs, ORMs, or web frameworks
• Interest in system design, scalability, and data quality

Expectations

• Ability to work independently on a well-defined technical project
• Willingness to learn and apply new tools and technologies
• Strong attention to detail when handling structured and historical data
• Clear documentation of design decisions and implementation choices
• Collaboration with mentors and technical stakeholders throughout the project

Who This Internship Is For

This role is ideal for students or recent graduates primarily interested in data engineering and software development, who want hands-on experience designing databases, building backend services, and developing web-based applications. Exposure to cybersecurity-related data is part of the project context, but the emphasis is on engineering, system design, and implementation rather than security operations.