Talent.com
Data Modeling And Business Intelligence Analyst

Data Modeling And Business Intelligence Analyst

SpektrumNorfolk, Virginia, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.job_description

Spektrum have a wide range of exciting opportunities in several global locations.

We are always looking to add great new talent to our team and look forward to hearing from you.

Spektrum supports apex purchasers (NATO, UN, EU and National Government and Defence) and their Tier 1 supplier ecosystem with a wide range of specialist services. We provide our clients with professional services, specialised aerospace and defence sales, delivery, and operational subject matter expertise. We are looking for personnel to join our team and support key client projects.

Who we are supporting

Allied Command Transformation (ACT) is NATO’s leading agent for change : driving, facilitating, and advocating the continuous improvement of Alliance capabilities to maintain and enhance the military relevance and effectiveness of the Alliance. The main objectives of ACT are : providing appropriate support to NATO missions and operations; leading NATO military transformation; and improving relationships, interaction and practical cooperation with partners, nations and international organisations. ACT therefore leads Alliance concept development, capability development, training and lessons-learned initiatives and provides unfettered military support to policy development within NATO.

The program

Capability Development & Management Support (CDMS)

DCOS Capability Development (CAPDEV) acts as the Supreme Allied Commander Transformation's Director for guidance, direction and coordination of the activities and resources of the Capability Development Directorate.

The Requirements Division will execute all tasks and activities needed to support requirements management for NATO capabilities

The Capability Requirements (CR) Branch will develop the Capability Requirements Brief and recommended courses of action to resolve issues through the life cycle management of requirements using matrixed, cross-functional project-specific Requirements Management teams.

The Requirements Forward Branch (Mons) is responsible for conducting requirements development and management representation and engagement-related functions in Europe.

The Capability Division coordinates the development of capabilities from capability planning through acceptance and then disposal with management entities, NATO Headquarters staff and the NATO Governance Structure

The Capability Forward Branch (Mons) coordinates with ACO, NCIA, NSPA, NATO HQ, territorial Host Nations, and NATO Centres of Excellence (COEs) to support the development of capabilities.

Strategic Plans and Policy (SPP) supports Allied Command Transformation in formalizing military advice to shape future military strategy, political guidance, and other policy documents supporting NATO’s strategic objectives.

Role Background

Deputy Chief of Staff Capability Development (DCOS CAPDEV) acts as the Supreme Allied Commander Transformation's Director for guidance, direction and co-ordination of the activities and resources of the Capability Development Directorate. CAPDEV is responsible to :

  • Identify and prioritize Alliance capability development from short to long term, ensuring coherence between all capabilities within the CAPDEV portfolio.
  • Lead the determination of required capabilities and prioritization of shortfalls to inform the delivery of materiel and non-materiel solutions across the Doctrine, Organisation, Training, Material, and Leadership, Personnel, Facilities and Interoperability (DOTMLPFI) lines of effort to enable a holistic approach to capability development, ensuring improved interoperability, deploy ability and sustainability of Alliance Forces.
  • The future Capability Development Directorate will include enduring functionality to effectively plan and manage coherent through life capability development, aligned to NATO’s strategic intent and priorities. The CAPDEV Data and Analytics Office (DAO) is responsible to DCOS for managing the data and platform operations for Capability Lifecycle, Requirements, and P3M data as well as providing analytics as service and enabling self-service analytics for CAPDEV decision makers.
  • As part of ongoing organisational functional reviews, CAPDEV is in the process of implementing measures for improved capability development planning and management, including the way it collects, manages, analyses and reports on capability development and delivery information, both legacy and current.

Role Duties and Responsibilities

  • Data Modeling and Repository Architecture : Design, implement, and maintain logical and physical data models, database schemas, tables, and relationships to support enterprise-level information systems. Primarily IBM Engineering Lifecycle Management (ELM)
  • Data Integration and Interoperability : Develop processes for importing, exporting, migrating, linking, and merging data from multiple repositories, ensuring compatibility and interoperability (e.g., via Requirements Interchange Format).
  • Metadata and Data Dictionary Management : Maintain comprehensive metadata repositories, data dictionaries, and naming conventions to ensure consistency, accuracy, and discoverability of enterprise data.
  • ETL Development : Design and execute ETL workflows to extract, transform, and load data from multiple sources—including spreadsheets, legacy systems, and modern applications—into structured repositories.
  • SQL Optimization : Conduct SQL tuning, query optimization, and performance diagnostics to ensure efficient operation of Oracle and MS SQL Server environments.
  • Business Intelligence Development : Develop, customize, and maintain BI reports, visualizations, and dashboards using Microsoft Power BI, Oracle BI, and other approved tools to provide actionable insights to decision-makers.
  • Custom Application Development : Create small-scale, fit-for-purpose database applications using platforms such as Microsoft Access, FileMaker Pro, or web-based solutions to meet specific stakeholder needs.
  • Change and Configuration Management : Support the change and configuration management of data assets, ensuring version control, documentation, and compliance with lifecycle management processes.
  • Testing and Quality Assurance : Perform testing, validation, and troubleshooting of database structures, BI solutions, and data pipelines to verify accuracy and functionality.
  • Data Governance and Compliance : Ensure compliance with organizational, NATO, industry, and regulatory standards for data storage, reporting, and access control.
  • Stakeholder Engagement : Collaborate with business analysts, developers, system administrators, and end users to capture requirements and translate them into technical specifications.
  • Process Automation : Identify opportunities for automating repetitive data preparation, reporting, and integration tasks to improve efficiency and reduce manual effort.
  • Cross-System Reporting : Integrate data across multiple systems to deliver unified, cross-domain analytics and reporting solutions.
  • User Training : Deliver training sessions, documentation, and user guides to ensure effective adoption and utilization of BI tools, database systems, and reporting solutions.
  • Technical Support : Provide ongoing technical support and troubleshooting for data systems, BI tools, and associated applications.
  • Capability Lifecycle Analysis Support : Contribute data modelling and analytics expertise to support requirements-based strategic planning, capability development, and operational decision-making processes.
  • Performs additional tasks as required by the COTR related to the labor category
  • Essential Skills and Experience

  • Three years’ recent (i.e., in the last 5 years) experience in data modelling, database administration, and BI development in IBM-ELM and / or IBM-DOORS and the IBM database environment (Db2), including the relational database management system (RDBMS).
  • Five years’ recent (i.e., in the last 10 years) experience in data modeling and database design in enterprise environments using Oracle and / or MS SQL Server.
  • Three years’ recent (i.e., in the last 5 years) experience designing and implementing ETL processes to integrate multiple data sources into enterprise repositories in enterprise environments such as Open Services for Lifecycle Collaboration (OSLC) (API development and management), and experience with Requirements Interchange Format (ReqIF) for information exchange across the NATO enterprise.
  • Five years’ recent (i.e., in the last 10 years) experience developing business intelligence dashboards, reports, and documents using tools such as Microsoft Power BI, Oracle BI, and IBM Rational Publishing Engine.
  • Experience in change management, configuration management, and maintaining metadata repositories / data dictionaries in compliance with organizational or governmental standards.
  • Demonstrable proficiency in effective oral and written communication, including briefing and coordinating with business stakeholders.
  • Desirable Skills, Experience and Certifications

  • Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred.
  • Education

  • A University Degree in Computer Science, Information Systems, or related field.
  • Language Proficiency

  • Advanced Proficiency in English
  • Working Location

  • Norfolk, VA, USA
  • Working Policy

  • On-Site
  • Contract Duration

  • January 2026 – December 2026
  • Security Clearance

  • Valid National or NATO Secret personal security clearance
  • We never know what new opportunities might be just over the horizon. If this opportunity isn't for you please feel free to send us your resume anyway and be the first to know if something suitable for your skills and experience comes up.

    serp_jobs.job_alerts.create_a_job

    Intelligence Analyst • Norfolk, Virginia, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Share Your Thoughts, Pocket Some Cash : Join Opinion Outpost's Survey Opportunities!

    Share Your Thoughts, Pocket Some Cash : Join Opinion Outpost's Survey Opportunities!

    DynataGloucester Point, VA, United States
    serp_jobs.job_card.full_time
    Ready to turn your opinions into cash? Explore the world of remote paid online survey gigs with Opinion Outpost!.It's as simple as sharing your thoughts from the comfort of your own home and watchi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Open Rank, Data Analytics and Decision Sciences (DADS), Tenure-Track

    Open Rank, Data Analytics and Decision Sciences (DADS), Tenure-Track

    InsideHigherEdAll Cities, Virginia, United States
    serp_jobs.job_card.full_time
    The Darden School of Business at the University of Virginia invites applications for a tenure-track open rank appointment in DADS, beginning in the fall of 2026. The DADS area at Darden specializes ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Looking for the ultimate side hustle?

    Looking for the ultimate side hustle?

    Survey AuthorityGloucester Point, VA, United States
    serp_jobs.job_card.full_time
    Earn cash by matching with real companies that pay you for your opinions.serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Search & Rescue

    Search & Rescue

    U.S. NavySeaford, VA, United States
    serp_jobs.job_card.full_time +1
    To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.When lives are on the line, Navy Aviation Rescue Swimmers (AIRRs) are exceptionally adept at answering the call....serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Entry Level Sales Representative

    Entry Level Sales Representative

    American Income LifeEastville, VA, US
    serp_jobs.job_card.full_time
    A Sales Career That Grows With You.Are you looking for a career path that gives you the freedom and flexibility to control your schedule, but also has the security and stability of a large company?...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Research Assistant Professor

    Research Assistant Professor

    InsideHigherEdAll Cities, Virginia, United States
    serp_jobs.job_card.full_time
    The Comprehensive Cancer Center at the University of Virginia seeks a Laboratory Manager and scientist at the Research Assistant Professor level to help lead a translational blood cancer research p...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Remote Senior Financial Analyst - AI Trainer

    Remote Senior Financial Analyst - AI Trainer

    Data AnnotationSuffolk, Virginia
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Survey Taker : Earn up to $25 per survey (Remote)

    Survey Taker : Earn up to $25 per survey (Remote)

    Earn HausGloucester Point, VA, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion. You will help influence brand decisions on se...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Data Analytics Manger-SQL to Big Query

    Data Analytics Manger-SQL to Big Query

    Family DollarChesapeake, VA, US
    serp_jobs.job_card.full_time
    We cannot provide sponsorship at this time.Data Analytics Manager-SQL to Big Query.At Family Dollar, we strive for exceptional collaboration between talented individuals who exhibit our values and ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Remote Finance Director - AI Trainer

    Remote Finance Director - AI Trainer

    Data AnnotationSuffolk, Virginia
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Assistant Research Professor

    Assistant Research Professor

    InsideHigherEdAll Cities, Virginia, United States
    serp_jobs.job_card.full_time
    The Center for Diabetes Technology (the “Center”) at the University of Virginia School of Medicine is seeking researcher / scientist to join our Center. The candidate should have a very strong commitm...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Remote Financial Analyst - AI Trainer

    Remote Financial Analyst - AI Trainer

    Data AnnotationChesapeake, Virginia
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Make money your way. Deliver with Uber!

    Make money your way. Deliver with Uber!

    Uber eatsHudgins, VA, United States
    serp_jobs.job_card.full_time +1
    Delivering with Uber is an alternative to a part-time or full-time job and can get you earning cash quickly.Delivering with Uber allows you to earn quick cash while maintaining the flexibility your...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    Academic General Faculty, Data Analytics and Decision Sciences (DADS)

    Academic General Faculty, Data Analytics and Decision Sciences (DADS)

    InsideHigherEdAll Cities, Virginia, United States
    serp_jobs.job_card.full_time
    The Darden School of Business at the University of Virginia invites applications for an Academic General Faculty (AGF, non-tenure track) in DADS, beginning in the fall of 2026.The DADS area at Dard...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Assistant Professor of Psychology

    Assistant Professor of Psychology

    InsideHigherEdAll Cities, Virginia, United States
    serp_jobs.job_card.full_time
    The Department of Psychology at the University of Virginia invites candidates to apply for an Assistant Professor tenure-track position in clinical psychology. We are seeking a candidate to join our...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Remote Commercial Banking Analyst - AI Trainer

    Remote Commercial Banking Analyst - AI Trainer

    Data AnnotationSuffolk, Virginia
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time +1
    We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the q...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Psychologist- Top Market Pay

    Psychologist- Top Market Pay

    LifeStance HealthLandtown, VA, United States
    serp_jobs.job_card.full_time
    We are actively looking to hire talented licensed clinical psychologists in the area who are passionate about patient care and committed to clinical excellence. You can design your practice around t...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Deliver with Uber - Flexible Gig

    Deliver with Uber - Flexible Gig

    Uber eatsNassawadox, VA, United States
    serp_jobs.job_card.full_time +1
    Delivering with Uber is an alternative to a part-time or full-time job and can get you earning cash quickly.Delivering with Uber allows you to earn quick cash while maintaining the flexibility your...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day