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.