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.