Advisory Consultant, Logistics IT

Position: Advisory Consultant, Logistics IT Specialist

Location: Washington, D.C. & Alexandria, VA

Clearance: Active Secret Clearance Required

Education: Bachelor’s degree required

Years of Experience: More than three years of relevant experience

Work Arrangement: Must be willing to go on-site up to 5 days/week

Position Overview:

The OSW Logistics & Analytics IT Specialist is responsible for transforming complex IT system data into actionable business intelligence while maintaining robust information architecture and collaborative workspaces. This role requires strong communication and cross-functional collaboration with key business partners and stakeholders, including internal and external OSW LOG Government/Enterprise partners.

The specialist will leverage advanced business intelligence platforms (including Qlik and ADVANA/WDP , now the WDP War Data platform, alongside core LOG IT data to optimize IT system rationalization & performance, support rigorous data governance and records management, and drive continuous operational improvements through Microsoft Teams and SharePoint collaboration between environments.

Key Responsibilities:

Reporting & Analytics:

Consolidate and analyze multi-source logistics data from multiple LOG IT systems and multiple enterprise data repositories (including ADVANA/WDP ).

Build recurring KPI dashboards, operational trackers, and executive scorecards.

Execute ad hoc queries, reports, create live data dashboards and complex analyses supporting strategic, financial, and system optimization decisions.

Business Intelligence & Tooling:

Design, build, deploy, and maintain interactive business intelligence dashboards and analytical models using:

Qlik (Qlik Sense / QlikView)

Databricks

ADVANA/WDP (enterprise analytics, data workspace, and dashboarding ecosystem)

Power BI

Tableau

Advanced Excel (Power Query, advanced modeling)

TEAMS Channel Management

SharePoint Channel Management

Query enterprise data lakes and relational databases using SQL to build robust underlying data models (e.g., Qlik QVDs, ADVANA/WDP data products).

Automate manual reporting pipelines, data extraction, and schedule automated dashboard refreshes.

Create clean, intuitive, and executive-ready visualizations tailored for leadership reviews and cross-functional briefings.

Data Governance, SharePoint & Records Management:

Standardize data definitions and reporting standards across IT systems.

Validate data integrity across multiple data platforms and enterprise repositories (e.g., ADVANA/WDP ).

Administer and organize SharePoint document libraries, data repositories, list structures, and file directory frameworks for logistics documentation.

Oversee comprehensive Records Management lifecycle practices, including cataloging, archiving, version control, access permission management, and compliance with data retention policies.

Conduct regular audits of operational reports and SharePoint repositories to eliminate duplicate, obsolete, or inconsistent records.

Collaboration, Workflow & Continuous Improvement:

Leverage Microsoft Teams and SharePoint as centralized operational hubs to streamline cross-functional workflows, share dashboard releases, and facilitate transparent stakeholder communication.

Manage dedicated Microsoft Teams channels, automated notifications, and shared asset libraries for logistics and analytics initiatives.

Prepare data packages and facilitate analytical discussions for quarterly business reviews (QBRs) with key stakeholders.

Qualifications & Experience:

Education: Bachelor’s degree in Supply Chain Management, Logistics, Business Analytics, Information Systems, Industrial Engineering, Finance, or a related quantitative discipline.

Experience: 3+ years of hands-on experience in logistics IT analytics, Data analysis, and supply chain business intelligence.

Technical Proficiencies:

Demonstrated proficiency in Qlik Sense or QlikView for data modeling, dashboard architecture, and report creation.

Hands-on experience navigating and building analytics within ADVANA/WDP (or similar enterprise/defense data environments).

Working knowledge of Microsoft Teams administration and SharePoint site/library configuration, permissions, and file management workflows.

Practical understanding of enterprise Records Management standards, document lifecycle protocols, and audit retention policies.

Familiarity with additional BI tools (Power BI, Tableau) and proficiency with SQL and Excel.

Experience working with ERP (e.g., SAP, Oracle), PowerPoint, SharePoint & Teams.

Core Competencies:

Analyst should be a self-starter with strong analytical and problem-solving skills with close attention to detail.

Strong information organization and documentation governance capabilities.

Proven ability to translate complex data into clear, actionable executive insights.

Exceptional verbal and written communication skills for cross-functional collaboration.