Data Analyst (Senior)

Professional Solutions Delivered, LLC (ProSoDel) is a total solutions provider for government and commercial customers in the areas of Program Management, Logistics, Organizational Change Management, Communications, Training, and Information Technology (IT) Support Services. We are currently seeking an on-site Data Analyst (Senior) to join our team of professionals in support of the USMC MCICOM G-9 Directorate.

Essential Duties & Job Functions:

• Develop and refine the COLS framework installation function and subfunction capabilities, performance risk levels, and measures (COLS Refresh).

• Facilitate the development and implementation of the annual COLS other than labor costing, manpower costing, and performance management data collection efforts, including determining changes, analyzing and updating business rules, obtaining feedback, and responding to information requests.
• Determine and manage detailed requirements for refining and developing the LFS Apps COLS Application, ensuring accurate data imports from other systems, and developing reports, splash pages, and dashboards for improved staff review.
• Refine and develop the COLS Power BI Dashboard, incorporating analyses and visuals using COLS data, PBIS data, and DAI data for organizational use.
• Provide administrative support for managing and maintaining the COLS App and COLS aspects of the Manpower App.
• Facilitate COLS functional communities of interest (HQ and regional experts) in refining COLS definitions, cost estimates, and performance data.
• Support the development and implementation of the COLS Executive Resource and Risk Management system for MCICOM COLS levels, aiding in leadership reviews and feedback loops.

• Analyze COLS OTL and Labor out-year cost estimate data for all organizational levels, ensuring validation, consistency, and decision-making accuracy, coordinated with BOS Study efforts.
• Review analytic results with subject matter experts for consistency with empirical data.

• Use DoD cost estimation techniques, statistical methods, and cost driver data for analysis.
• Recommendations must adhere to MIL-STD-3022 guidelines for VV&A for decision support.
• Develop approaches to limit error and implement them as directed.
• Analyze COLS cost estimates against PBIS, DAI, and COLS data to validate alignment and improve understanding.
• Update and administer COLS 101, COLS App, COLS cost estimates, COLS performance, and training as needed.
• Conduct reviews and propose updates to orders, directives, and policies governing COLS programs, ensuring effective communication with G-5 leads.
• Facilitate development of the Commander’s Organizational Risk Estimate (CORE) report annually, including tool creation, data collection, training, analysis, and reporting.

• Primary work location is on-site (some remote work is possible).

• Able to travel, both CONUS and OCONUS, as required/necessary for the program. 
• Perform related work as assigned.

Job Requirements (Education, Experience, Professional Associations)

Education

• Education: Must have at least ten (10) years of relevant experience and a Bachelor’s degree or at least five (5) years of experience and a Master’s degree.

Required Experience

• Proficiency in briefing and communication skills to senior Military (e.g., O-6 level and above), Military Commanders and their staff, organizational leaders, and peers. [ET1] 
• Experience with using Python and/or SQL to pull data from databases.
• Experience integrating data from multiple data sources into data-driven solutions based on customer requirements.
• Experience with utilizing Power BI and/or Tableau to visualize data based on customer requirements.
• Experience developing customized, data-driven dashboards from initial conceptualization to final delivery.
• Skilled in developing executive-level correspondence, presentations, and management programs involving executive-level participants. 
• Experience working with a diverse and often conflicting group of stakeholders from a cross section of all staff divisions/efforts.

Desired Experience

• Experience with any of the data science libraries on Python – Pandas, Scikit-learn, Matplotlib, etc.
• Experience developing solutions based on financial data highly desired.
• Experience working for DoD or other large government entities a plus; USMC or other Military service experience a HUGE PLUS.

Clearance

• Must be a United States Citizen. 
• Must be able to obtain and maintain a Common Access Card (CAC), active DoD clearance highly desired.

*As a condition of employment, employee must successfully complete a background investigation and a drug screen in accordance with all federal, state, and local laws.