Data Modelling and Business Intelligence Analyst

Data Modelling and Business Intelligence Analyst

McBride is a certified Minority-Owned Business Enterprise (MBE), Service-Disabled Veteran-Owned Small Business (SDVOSB), and Disadvantaged Business Enterprise (DBE) management and IT consulting firm with significant professional services experience that includes IT transformation, project management, digital transformation, strategic planning, business process improvement, change management, human capital management, disaster recovery, and operations.

Client: 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. ACT leads Alliance concept development, capability development, training and lessons learned initiatives and provides unfettered military support to policy development within NATO.

Background: Deputy Chief of Staff Capability Development (DCOS CAPDEV) acts as the 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:

• a. Identify and prioritize Alliance capability development from short to long term, ensuring coherence between all capabilities within the CAPDEV portfolio.
• b. Lead the determination of required capabilities and prioritization of shortfalls to inform the delivery of materiel and non-materiel solutions across the Doctrine, Organization, Training, Material, and Leadership, Personnel, Facilities and Interoperability (DOTMLPFI) lines of effort to enable a holistic approach to capability development, ensuring improved interoperability, deployability 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 organizational functional reviews, CAPDEV is 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.

Tasking:

• 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, File Maker 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 analysts, developers, system administrators, and end users to capture requirements and translate 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,…