Systems Planning & Analysis
Data Modeling & Business Intelligence Analyst
Systems Planning & Analysis, Norfolk, Virginia, United States, 23500
Data Modeling & Business Intelligence Analyst
Join to apply for the
Data Modeling & Business Intelligence Analyst
role at
Systems Planning & Analysis Overview
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. Responsibilities
The candidate will 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. Design and execute ETL workflows to extract, transform, and load data from multiple sources—including spreadsheets, legacy systems, and modern applications—into structured repositories. Conduct SQL tuning, query optimization, and performance diagnostics to ensure efficient operation of Oracle and MS SQL Server environments. 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. 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. Support the change and configuration management of data assets, ensuring version control, documentation, and compliance with lifecycle management processes. Perform testing, validation, and troubleshooting of database structures, BI solutions, and data pipelines to verify accuracy and functionality. Ensure compliance with organizational, NATO, industry, and regulatory standards for data storage, reporting, and access control. Collaborate with business analysts, developers, system administrators, and end users to capture requirements and translate them into technical specifications. Identify opportunities for automating repetitive data preparation, reporting, and integration tasks to improve efficiency and reduce manual effort. Integrate data across multiple systems to deliver unified, cross-domain analytics and reporting solutions. Deliver training sessions, documentation, and user guides to ensure effective adoption and utilization of BI tools, database systems, and reporting solutions. Provide ongoing technical support and troubleshooting for data systems, BI tools, and associated applications. Contribute data modelling and analytics expertise to support requirements-based strategic planning, capability development, and operational decision-making processes. 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. Bachelor’s degree in Computer Science, Information Systems, or a related field. 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. NATO or National SECRET clearance. 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. Able to work fully onsite based on client needs. Desired
Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred. Seniority level
Mid-Senior level Employment type
Full-time Job function
Research, Analyst, and Information Technology Industries
Defense and Space Manufacturing, Aviation and Aerospace Component Manufacturing, and Armed Forces
#J-18808-Ljbffr
Join to apply for the
Data Modeling & Business Intelligence Analyst
role at
Systems Planning & Analysis Overview
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. Responsibilities
The candidate will 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. Design and execute ETL workflows to extract, transform, and load data from multiple sources—including spreadsheets, legacy systems, and modern applications—into structured repositories. Conduct SQL tuning, query optimization, and performance diagnostics to ensure efficient operation of Oracle and MS SQL Server environments. 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. 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. Support the change and configuration management of data assets, ensuring version control, documentation, and compliance with lifecycle management processes. Perform testing, validation, and troubleshooting of database structures, BI solutions, and data pipelines to verify accuracy and functionality. Ensure compliance with organizational, NATO, industry, and regulatory standards for data storage, reporting, and access control. Collaborate with business analysts, developers, system administrators, and end users to capture requirements and translate them into technical specifications. Identify opportunities for automating repetitive data preparation, reporting, and integration tasks to improve efficiency and reduce manual effort. Integrate data across multiple systems to deliver unified, cross-domain analytics and reporting solutions. Deliver training sessions, documentation, and user guides to ensure effective adoption and utilization of BI tools, database systems, and reporting solutions. Provide ongoing technical support and troubleshooting for data systems, BI tools, and associated applications. Contribute data modelling and analytics expertise to support requirements-based strategic planning, capability development, and operational decision-making processes. 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. Bachelor’s degree in Computer Science, Information Systems, or a related field. 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. NATO or National SECRET clearance. 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. Able to work fully onsite based on client needs. Desired
Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred. Seniority level
Mid-Senior level Employment type
Full-time Job function
Research, Analyst, and Information Technology Industries
Defense and Space Manufacturing, Aviation and Aerospace Component Manufacturing, and Armed Forces
#J-18808-Ljbffr