What are the responsibilities and job description for the Analyst position at Systems Products and Solutions, Inc?
Data Analyst to provide technical support and SharePoint services to our customer by providing data extracts and reports for optimizing program management and projections for Army Depot production requirements. To be successful the candidate must be able to expertly create and maintain Excel spreadsheets and the underling Access database tables and queries. Should have very high level of confidence employing VBA to create automated solutions in a shared network environment to support mission requirements. Knowledge of working with Access datasets and Excel workbooks to create pivots and advanced reports is a must.
Candidate must be able to perform at a very high level in Microsoft Suite and have demonstrated expertise in Excel and Access. Candidates should also be able create Excel Pivot Tables, and Access tables reports and queries,).
Extensive expertise in ACCESS, EXCEL, LMP, and other databases who can conduct analysis and help automate the generation of required reports.
Desired Skills: In addition to the required skills it is desirable that the candidate have a working knowledge of the Amy Logistics. Skill relating to SAP, BEx Query Designer, Business Objects (BOBJ), Power BI, SQL, Tableau, and Visual Basic for Applications (VBA), are desired.
Responsibilities:
- Importing data from various sources and formats
- Creating Access/Excel solutions
- Identify customer data requirements and work with team to meet them
- Maintaining SharePoint lists and files
- Work with teams from all areas to ensure data sets meet the needs of Army Depots
- Provide quality assurance of imported data
Qualifications
Education
Preferred
Bachelors or better.
Experience
Required
Required Skills: Extensive expertise in ACCESS, EXCEL, LMP, and other databases who can conduct analysis and help automate the generation of required reports.
Preferred
Candidate must be proficient in Microsoft Office Suite Products and have a demonstrated fluency in Excel and Access. In addition the candidate will be familiar and fluent in Visual Basic for Applications (VBA).
Preferred Skills: In addition to the required skills, it is desired that the candidate possess and demonstrate knowledge of Logistic modernization Program (LMP), Business Objectives and SAS.
High School Diploma or GED and not less than 13 years of experience in logistics or supply; BS/BA degree and not less than 8 years related experience, or an MS/MA degree and not less than 4 years of experience. Technical civilian or military school experience directly related to the equipment in task order requirements may substitute for 2 years of experience.
Job Type: Full-time
Pay: $58,622.82 - $73,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Referral program
- Tuition reimbursement
- Vision insurance
Schedule:
- 8 hour shift
COVID-19 considerations:
Candidates for this position are required to abide by Federal Government site access COVID-related safety rules, as well as corporate safety protocol measures.
Ability to commute/relocate:
- Huntsville, AL: Reliably commute or planning to relocate before starting work (Required)
Experience:
- Microsoft Office: 8 years (Preferred)
- Logistics: 4 years (Preferred)
- SAP BusinessObjects: 4 years (Preferred)
- SharePoint: 4 years (Preferred)
Work Location: One location