Spektrum
Data Modeling And Business Intelligence Analyst
Spektrum, Norfolk, Virginia, United States, 23500
Data Modelling And Business Intelligence Analyst
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. Role Background Allied Command Transformation (ACT) is NATO’s leading agent for change, driving continuous improvement of Alliance capabilities. CDMS, CAPDEV, and related NATO Directorate structures coordinate capability development and lifecycle management. The CAPDEV Data and Analytics Office (DAO) manages data and platform operations for Capability Lifecycle, Requirements, and P3M data, providing analytics as a service and enabling self-service analytics for CAPDEV decision makers. 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. Essential Skills And Experience Three years’ recent 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 experience in data modeling and database design in enterprise environments using Oracle and/or MS SQL Server. Three years’ recent experience designing and implementing ETL processes to integrate multiple data sources into enterprise repositories in environments such as OSLC and experience with ReqIF for information exchange across the NATO enterprise. Five years’ recent experience developing BI 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 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.
#J-18808-Ljbffr
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. Role Background Allied Command Transformation (ACT) is NATO’s leading agent for change, driving continuous improvement of Alliance capabilities. CDMS, CAPDEV, and related NATO Directorate structures coordinate capability development and lifecycle management. The CAPDEV Data and Analytics Office (DAO) manages data and platform operations for Capability Lifecycle, Requirements, and P3M data, providing analytics as a service and enabling self-service analytics for CAPDEV decision makers. 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. Essential Skills And Experience Three years’ recent 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 experience in data modeling and database design in enterprise environments using Oracle and/or MS SQL Server. Three years’ recent experience designing and implementing ETL processes to integrate multiple data sources into enterprise repositories in environments such as OSLC and experience with ReqIF for information exchange across the NATO enterprise. Five years’ recent experience developing BI 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 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.
#J-18808-Ljbffr