Data Modelling & Business Intelligence Analyst

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

Additional information : vector synergy contact details and company information are provided in official materials.

#J-18808-Ljbffr