Vector Synergy
Data Modelling & Business Intelligence Analyst
Vector Synergy, Norfolk, Virginia, United States, 23500
Data Modelling & Business Intelligence Analyst
Join to apply for the Data Modelling & Business Intelligence Analyst role at Vector Synergy. Location:
Norfolk, VA, USA Security Clearance:
NATO Secret Overview
Role focuses on data modelling, data integration, and business intelligence development within an enterprise environment. 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 metadata repositories, data dictionaries, and naming conventions to ensure consistency and discoverability of enterprise data. ETL Development: Design and execute ETL workflows to extract, transform, and load data from multiple sources into structured repositories. SQL Optimization: Tune SQL, optimize queries, and perform performance diagnostics in Oracle and MS SQL Server environments. Business Intelligence Development: Develop and maintain BI reports, visualizations, and dashboards using Microsoft Power BI, Oracle BI, and other approved tools to support decision-makers. Custom Application Development: Create small-scale database applications as needed for stakeholder requirements. Change and Configuration Management: Support version control, documentation, and lifecycle management of data assets. Testing and Quality Assurance: Validate database structures, BI solutions, and data pipelines for 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: Gather requirements and translate them into technical specifications; coordinate with business analysts, developers, and system administrators. Process Automation: Identify opportunities to automate data preparation, reporting, and integration tasks to improve efficiency. Cross-System Reporting: Deliver unified analytics and reporting across multiple systems. User Training: Provide training materials and sessions for BI tools, databases, and reporting solutions. Technical Support: Provide ongoing support for data systems and BI tools. Capability Lifecycle Analysis Support: Contribute analytics expertise to strategic planning and capability development. Performs additional tasks as required by the COTR related to the labor category. Qualifications
10+ years progressive experience in data modelling, database administration, and BI development; 2+ years with IBM-ELM and IBM Db2 RDBMS. Expertise with IBM-ELM, IBM Rational Publishing Engine (RPE), Oracle, MS SQL Server; BI tools such as Power BI and Oracle BI. Bachelor’s Degree in Computer Science, Information Systems, or related field. Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred. Experience with data integration, ETL, and system interoperability; OSLC API development and management; ReqIF for NATO information exchange. Experience across full SDLC: requirements analysis, system design, testing, deployment. Proficiency in SQL, data analysis, and enterprise application customization. Experience with DevSecOps practices, CI/CD pipelines, and configuration management. English proficiency as defined in STANAG 6001 (SLP 3333) or equivalent. Strong oral and written communication, including briefing and coordinating with stakeholders. Additional information: vector synergy contact details and company information are provided in official materials.
#J-18808-Ljbffr
Join to apply for the Data Modelling & Business Intelligence Analyst role at Vector Synergy. Location:
Norfolk, VA, USA Security Clearance:
NATO Secret Overview
Role focuses on data modelling, data integration, and business intelligence development within an enterprise environment. 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 metadata repositories, data dictionaries, and naming conventions to ensure consistency and discoverability of enterprise data. ETL Development: Design and execute ETL workflows to extract, transform, and load data from multiple sources into structured repositories. SQL Optimization: Tune SQL, optimize queries, and perform performance diagnostics in Oracle and MS SQL Server environments. Business Intelligence Development: Develop and maintain BI reports, visualizations, and dashboards using Microsoft Power BI, Oracle BI, and other approved tools to support decision-makers. Custom Application Development: Create small-scale database applications as needed for stakeholder requirements. Change and Configuration Management: Support version control, documentation, and lifecycle management of data assets. Testing and Quality Assurance: Validate database structures, BI solutions, and data pipelines for 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: Gather requirements and translate them into technical specifications; coordinate with business analysts, developers, and system administrators. Process Automation: Identify opportunities to automate data preparation, reporting, and integration tasks to improve efficiency. Cross-System Reporting: Deliver unified analytics and reporting across multiple systems. User Training: Provide training materials and sessions for BI tools, databases, and reporting solutions. Technical Support: Provide ongoing support for data systems and BI tools. Capability Lifecycle Analysis Support: Contribute analytics expertise to strategic planning and capability development. Performs additional tasks as required by the COTR related to the labor category. Qualifications
10+ years progressive experience in data modelling, database administration, and BI development; 2+ years with IBM-ELM and IBM Db2 RDBMS. Expertise with IBM-ELM, IBM Rational Publishing Engine (RPE), Oracle, MS SQL Server; BI tools such as Power BI and Oracle BI. Bachelor’s Degree in Computer Science, Information Systems, or related field. Advanced technical certifications (e.g., CCNA, vendor-specific DBMS certifications) preferred. Experience with data integration, ETL, and system interoperability; OSLC API development and management; ReqIF for NATO information exchange. Experience across full SDLC: requirements analysis, system design, testing, deployment. Proficiency in SQL, data analysis, and enterprise application customization. Experience with DevSecOps practices, CI/CD pipelines, and configuration management. English proficiency as defined in STANAG 6001 (SLP 3333) or equivalent. Strong oral and written communication, including briefing and coordinating with stakeholders. Additional information: vector synergy contact details and company information are provided in official materials.
#J-18808-Ljbffr