Essential Duties & Job Functions:
- Provide asset data analysis and reporting support.
- Develop, maintain, and improve repeatable analytical processes to evaluate and validate data extracted from multiple asset discovery tools, ensuring accuracy, consistency, and reliability of software discovery capabilities across the USMC enterprise.
- Analyze and interpret complex datasets from disparate systems to identify trends, anomalies, data gaps, and opportunities for process improvement related to software asset and license management.
- Create comprehensive analytical reports, dashboards, and visualizations using multiple data sources and formats to support Program Managers, Customer Support and Strategic Sourcing personnel, Software Project Managers, IT Asset Managers, and other stakeholders.
- Use Structured Query Language (SQL) to manipulate data in order to perform data analysis. Examples of approved database technologies, to perform data analysis, includes Oracle and MS SQL Server.
- Perform quality assurance reviews of reports to ensure accuracy of the results and standardization of processes and procedures across the team of analysts.
- Support the identification and cataloging of software procurement data.
- Provide analytical recommendations and present findings to leadership and stakeholders in a clear, concise, and actionable manner.
- Additional duties as assigned.
REQUIRED SKILLS / EXPERIENCE
- Firm understanding and ability to use Structured Query Language databases such as:
- Microsoft SQL Server2019,
- 3+ years' experience in SQL Server development. Designing data structures (tables/views/indexes), T-SQL programming (stored procedures and functions).
- SQL Server Management Studio20 (SSMS)
- Visual Studios, SQL Server Integration Services (SSIS),PowerShell, and Power BI experience highly desired.
- Ability to analyze data migration plans to include mapping of source to target databases.
- Ability to communicate effectively with project leaders and senior management regarding key milestones, success criteria and risks.
- Expert in database design for relational database management including data warehouse, datamart, and data mining.
- Must have knowledge/skill of PL/SQL scripting for Oracle Database.
- Ability to use SQL Developer, writing DDL statements and to effectively create and analyze various database schemas.
- Prior experience with Oracle Database Administration (DBA) 11g/12c, E-Business Suite 12.2.x, PL/SQL, ASM/RAC, Application Clustering, Recovery Manager (RMAN), Rapid Clone, Auto Config and UNIX/Linux Scripting (Shell Script) preferred.
REQUIRED CERTIFICATIONS
- CompTIASecurity+ CE certification preferred
SECURITY CLEARANCE REQUIREMENT
- Able to pass Federal National Agency Check with Inquiries (NACI) and have an Active DoD Secret Clearance.
TRAVEL
