Job Description:
Generally, the experienced Logistics/Supply Chain Analyst serves as the Business Intelligence (BI) & Data Visualization Subject Matter Expert (SME) and Database Administer (DBA) on matters related to Marine Corps Logistics data sources, policy, and BI product development in database management and data visualization solutions. They will implement and maintain one or more complex databases implementing procedures to control access and allocation of data and maintain security controls. This person will apply basic principles, theories, and concepts to job assignments. Interface with internal and external stakeholders and make significant contributions to department goals and planning efforts. They will coordinate projects vertically and horizontally within a Major Subordinate Command Marine Corps staff. They will support the development and maintenance of scalable data stores that supply large amounts of data in forms needed for business analysis that leads to key leader decision making. This person will assist in the design of BI dashboards and reports for logistics and fiscal Key Performance Indicators (KPIs) and data analytics tools that are aligned and/or synchronized with Marine Corps Readiness optimization and Intermediate Supply and Maintenance production oversight in accordance with Marine Corps priorities. As required, they will provide training to the personnel on developed products and utilization of reports and tools.
Duties and expectations include, but are not limited to, the following:
- Manage progress on the project assigned and report closely to superior on project status.
- Troubleshoot data issues by tracing the data flow and identifying the root of cause.
- Maintain SQL queries for ad-hoc reports.
- Maintain and enhance stored procedures for production databases.
- Perform testing on customized in-house developed web-based analytical software.
- Improve the plan/process of a project to maximize efficiency by minimizing the time and effort needed.
- Confer with stakeholders to analyze current operational procedures, identify problems, and learn specific input and output requirements.
- Validate and analyze data and convert from raw data to analytical reports for decision-making purposes.
- Create schema objects such as attributes, facts, logical views, user hierarchies and transformations using Data Visualization tool (i.e. Power BI).
- Create public objects such as metrics, filters, prompts, consolidations, custom groups, reports and documents based on client's requirements using Power Bi.
- Develop and maintain document services reports based on client's requirements.
- Develop and maintain custom reports to combine the data sets of multiple reports and also create customized dashboards and scorecards using report services.
CLEARANCE REQUIREMENTS: Secret
EDUCATION REQUIREMENTS: Bachelor's degree
Mandatory: Yes
Waiverable/Substitutable: Yes
- Four Year degree substitutable with an additional four years of experience in lieu of a degree
CERTIFICATION REQUIREMENTS: None
Mandatory: N/A
Preferred: Microsoft SQL Server database Certifications, Security+ Plus
EXPERIENCE REQUIREMENTS:
Mandatory: Eight years of full-time experience (including internships) providing logistics and supply chain management-related services and the following additional experience:
- 3+ years of user experience with Oracle applications and platform services.
- 1+ years of operating experience with Microsoft SQL Server or SQL Database equivalent.
- General experience required includes: increasing responsibilities in design and/or maintenance of complex electronic systems.
- Familiar with Design and Development Software Process Activities including Waterfall and Agile Design Processes as well as familiarization with the design and development of databases.
- Progressive experience in design and installation of integrated systems of personnel, materials, machinery, and/or equipment.
- Knowledge of both logical and physical data modeling.
- Progressive financial and/or logistics and/or system experience.
Preferred:
- Familiarity of DoD Logistics and Supply Chain operations with working knowledge of recent developments and policies of issues affecting Marine Corps Supply and Maintenance Activity that may impact Marine Corps Military Equipment Readiness a plus.
Work Type:
OnSite - Camp Pendleton, CA
Clearance Requirements:
Secret or ability to achieve.