Data Engineering Intern - Summer

Systems Planning and Analysis, Inc. (SPA) delivers high-impact technical solutions to complex national security issues. With over 50 years of business expertise and consistent growth, we are known for continuous innovation for our government customers, in both the U.S. and abroad. Our exceptionally talented team is highly collaborative in spirit and practice, producing Results that Matter. Come work with the best!

We offer opportunities, unique challenges, and clear-sighted commitment to the mission. SPA:
Objective. Responsive. Trusted.

Veracity Forecasting Portfolio (VF) is part of the Sea, Land, Air Division within Systems Planning and Analysis, Inc. Our unique processes result in authoritative, data-driven analyses that assist enterprise managers with complex decision making. We offer our customers proven expertise in descriptive, predictive, and prescriptive analytics; advanced mathematics and computational techniques (a.k.a. data science); and software engineering. Our mission is to help enterprise leaders make complex, fully informed decisions and save money in the process.

We are seeking a motivated Data Engineer Intern to work with our data team on an important Department of Navy program.

You’ll support the design and documentation of scalable, reliable data architectures that enable analytics, reporting, and advanced data use cases. Working under the guidance of experienced data scientists, you will gain hands‑on exposure to data modeling, system design, and architectural best practices while contributing to real projects. Specific responsibilities include:

• Assist in designing conceptual, logical, and physical data models for analytical platforms
• Support the development of data architecture diagrams, standards, and documentation
• Support design and implementation of cloud-based data pipelines in common industry environments
• Help evaluate data sources, integration patterns, and technology options
• Contribute to data modeling efforts using tools such as ER diagrams, dimensional modeling, and modern modeling approaches
• Participate in reviewing data pipeline and storage designs for scalability, performance, and maintainability
• Research emerging data architecture patterns, tools, and best practices; summarize findings for the team
• Assist with documenting data flows, data lineage, governance considerations, and architectural decisions
• Collaborate with data scientists/analysts and stakeholders to gather requirements and refine designs
• Support basic prototyping or proof-of-concept work related to data architecture solutions

• Degree candidate in Data Science, Computer Science, or other appropriate technical discipline
• Strong foundational knowledge of databases
• Proficiency in Python (or similar scripting language) for data manipulation
• Familiarity with data modeling concepts (dimensional modeling, star/snowflake schemas) and basic ETL concepts
• Familiarity with cloud-based development tools
• Understanding of version control and collaborative development practices
• Strong analytical thinking, attention to detail, and eagerness to learn
• Strong written and verbal communication skills
• US citizen with the ability to obtain/maintain a security clearance

• Academic project experience involving database design, data warehousing, or system architecture
• Exposure to cloud platforms and services such as S3, Big Query, Redshift, Snowflake, or Databricks
• Familiarity with data modeling tools (like Lucidchart, draw.io, ERwin, or similar) and/or diagramming practices
• Understanding of data governance, data quality, and enterprise architecture concepts
• Experience with version control and collborative documentation tools

At SPA, we…