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 US and abroad. Our exceptionally talented team is highly collaborative in spirit and practice, producing Results that Matter. Come work with the best! We offer opportunity, unique challenges, and clear-sighted commitment to the mission. SPA: Objective. Responsive. Trusted.

The Joint, Office of the Secretary of Defense, Interagency Division provides expert support services to a range of customers spanning across the Department of Defense, Federal Civilian, and international markets. JOID provides a diverse portfolio of analytical and programmatic capabilities to help our customers make informed decisions on their most challenging issues.

SPA's NATO Allied Command Transformation Group within JOID provides capability development, portfolio management, program management, quality management, cost estimation analysis, standardization, reporting, software solutions and information management, and capability management support. We also provide an improved capability requirements capture process, including the generation, documentation and tracing of user requirements, with appropriate technical scrutiny, over the entire lifecycle of the requirements from capability definition through capability realization and capability usage.

SPA has a near-term need for a Data Analyst/Engineer in Support of ACT Architectural Coherence to provide contracting services to NATO onsite in Norfolk, VA.

The HQ SACT requires support in establishing the Enterprise Architecture function and reporting about on-going and future programs and initiatives delivering the Digital Transformation Implementation Strategy. The HQ SACT is responsible for capturing capability requirements developing capability architectures in support of the different NATO modernization and transformation programs. The support will consist of consolidating architectural data across multiple sources (e.g. specialized architectural tools and repositories, requirements management tools, project and portfolio management tools) to create reports, presentations and interactive web-published dashboards and heat maps illustrating architectural scope, connections, overlaps, gaps, and delivery progress of multiple programs and projects.

Will gather and analyze data related to enterprise architecture and capability architectures, including data on capabilities, processes, data flows, requirements, and program portfolio. You will create architectural dashboards and heat maps, use data to visualize the architecture maturity, architectural links, and gaps between initiatives, requirements fulfilment, status of programs and projects, and identify potential risks and bottlenecks. Utilize data to create architectural roadmaps for capability development, and identify the capabilities to support future initiatives and NATO Digital Transformation. Collaborate with enterprise architects and capability architects to develop and implement data-driven architecture strategies. Work closely with the architects to understand their needs and deliver actionable insights. Integrate data sources relevant for the enterprise architecture (capability architectures, taxonomies, requirements, and program/project information). Develop, construct, test, and maintain data pipelines and data processing tools such as databases, data warehouses and ETLs. Transform data into formats that can be easily analyzed by developing, maintaining, and testing infrastructures for data generation. Configure, integrate, and maintain data integration and analytics tools and shared repositories (e.g. PowerBI, KNIME, SQL Server and other DBMS', SharePoint). Will improve data quality and efficiency, support evaluation of capability requirements and objectives and their delivery status, and perform additional tasks as required by the COTR related to the labor category.

This role is a hybrid of data analysis and data engineering, and will require you to have skills in both areas.

Required:

Active National or NATO Secret clearance
• Bachelor's degree in a relevant engineering, management, information systems, accounting, economics, finance, business administration, public administration, operations research, project management, or related discipline; or 5 years of professional experience in data analytics/engineering
• Demonstrable recent experience (at least 5 years in the last 10) in complex data analysis and processing; able to list most relevant projects supported, analytical artifacts produced, or data engineering tasks performed
• Demonstrable recent hands-on experience (at least 3 years in the last 10) using modern software architecture and software development related to data science, analytics, and data integration, e.g. Python, SQL, KNIME, Pentaho, or similar and familiarity in working with semi-structured data (XML, JSON) and APIs; able to list most relevant projects supported (no more than 3), tools/languages used, and nature of the source data (e.g. relational, free text, JSON/XML)
• Demonstrable recent hands-on experience (at least 3 years in the last 10) designing and implementing data warehouse and data lake solutions
• Knowledge of different data modeling paradigms, e.g. relational, dimensional, triple store (semantic Wikis), NoSQL; able to list most relevant projects supported (no more than 3), tools used and data modeling paradigm used
• Effective storytelling via data, experienced 'data storyteller', and able to provide most relevant examples (no more than 3) together with the type of audience, 'data story' presented, and presentation goals and outcomes
• Demonstrable recent hands-on experience (at least 2 years in the last 5) with data presentation and visualization tools, e.g. Microsoft Power BI, Tableau, Kibana, or similar using high quality graphs and reports, charts, heats maps, and interactive dashboards; able to list most relevant projects supported (no more than 3), types of visualizations, and tools used