Data Modeling & Business Intelligence Analyst

Data Modeling & Business Intelligence Analyst

Norfolk, United States | Posted on 10 / 14 / 2025

Sandy Mac Evolution LLC is a Veteran-Owned company dedicated to connecting top talent with meaningful opportunities.

Job Description

Thisopportunity is open only to individuals who currently hold an active U.S.Department of Defense (DoD) security clearance at the required level. Engagement will be under a 1099 / Business-to-Business (B2B) contractualarrangement not a W-2 employment position. As this is a B2B / 1099 engagement, benefits such as health insurance, paidtime off, and retirement plans are not provided. Contractors are responsible for managing their own taxes, insurance, and other business obligations inaccordance with federal and state requirements.

A senior data specialist with a degree in IT, computerscience, or information systems and over 10 years of experience in datamodeling, repository design, ETL workflows, and BI dashboard / reportingdevelopment. They are proficient with SQL optimization, Oracle / MS SQL Server,and BI tools such as Power BI, Oracle BI, or equivalent.

The ideal candidate combines technical depth with strong stakeholder engagementskills, capable of translating complex requirements into robust BI solutions. Prior NATO or defense data governance experience is highly desirable.

Preferred Background : Senior BI / Data Modelers with Power BI / SQL expertise and NATO project experience.

• Design, implement, and maintain logical and physical data models, schemas, tables, and relationships for enterprise-level systems (primarily IBM Engineering Lifecycle Management)
• Develop processes for importing, exporting, migrating, and linking data from multiple repositories, ensuring interoperability (e.g., via Requirements Interchange Format)
• Maintain metadata repositories, data dictionaries, and naming conventions for enterprise consistency
• Design and execute ETL workflows to extract, transform, and load data from diverse sources
• Conduct SQL tuning, query optimization, and performance diagnostics for Oracle and MS SQL environments
• Develop, customize, and maintain BI reports, dashboards, and visualizations using Power BI, Oracle BI, and related tools
• Create small-scale, purpose-built database applications (e.g., MS Access, FileMaker, or web-based solutions)
• Support change and configuration management of data assets, ensuring documentation and version control
• Perform testing, validation, and troubleshooting of BI solutions, data pipelines, and database structures
• Ensure compliance with NATO, organizational, and regulatory data standards
• Collaborate with analysts, developers, system administrators, and stakeholders to translate business requirements into technical solutions
• Identify and automate repetitive data preparation and reporting tasks to improve efficiency
• Integrate data across systems to provide unified analytics and reporting
• Deliver user training, documentation, and support for BI and data tools
• Provide technical support for data systems and BI applications
• Contribute data modeling and analytics expertise to support capability development and operational decision-making
• Perform additional tasks as directed by the COTR related to the labor category

Asthis is a B2B / 1099 engagement, benefits such as health insurance, paid timeoff, and retirement plans are not provided. Contractors are responsible for managing their own taxes, insurance, and other business obligations inaccordance with federal and state requirements.

Requirements

#J-18808-Ljbffr