Job description

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. The main objectives of ACT are: providing appropriate support to NATO missions and operations; leading NATO military transformation; improving relationships, interaction and practical cooperation with partners, nations and international organizations. ACT therefore 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 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: 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 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. 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, 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 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, 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 Qualifications: • 10+ years of progressive experience in data modelling, database administration, and BI development. 2+ years of experience performing these tasks in IBM-ELM and the IBM database environment (Db2), including the relational database management system (RDBMS). • Demonstrated Expertise with Enterprise Data and Analytics and Publishing tools: IBM-ELM, IBM Rational Publishing Engine (RPE), Oracle, MS SQL Server, and BI tools such as Power BI and Oracle BI. • Demonstrated experience with data integration, ETL processes, and system interoperability 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. • Demonstrated experience supporting full SDLC activities, including requirements analysis, system design, testing, and deployment. • Demonstrated proficiency in SQL, data analysis, and customization of enterprise applications. • Demonstrated professional experience with DevSecOps practices, CI/CD pipelines, and configuration management processes. • Demonstrated proficiency in English as defined in STANAG 6001 (Standardized Linguistic Profile (SLP) 3333 - Listening, Speaking, Reading and Writing) or equivalent. • Demonstrable proficiency in effective oral and written communication, including briefing and coordinating with business stakeholders. Education and Clearance: • Bachelor’s Degree in Computer Science, Information Systems, or related field. • Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred. • NATO or National SECRET clearance McBride is an Equal Opportunity Employer. McBride Consulting does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

Requirements