Job opening: Business Analyst
Salary: $62 579 - 117 972 per year
Published at: Apr 19 2024
Employment Type: Full-time
The foundation for success of the Defense Commissary Agency mission is our people. It is DeCA's goal to have a workforce that is comprised of our nation's diverse cultures and backgrounds. DeCA operates a worldwide commissary system that provides quality grocery products to active duty military personnel and retirees, members of the Reserve and National Guard, and their families, as well as current DeCA employees. The agency employs over 15,000 people and its annual sales exceed $4 billion.
Duties
This is a developmental position. Work assignments are progressively complex and intended to broaden your skills and provide you with practical experience to prepare you to perform at the target grade level. At the target grade level, the major duties are:
This position is located in the Headquarters (HQ), Defense Commissary Agency (DeCA), Sales Marketing, and Policy Group, Sales Directorate, Category Management Division.
Serve as an experienced business analyst and is responsible for providing the integration of syndicated scanning data and/or demographic information into graphical presentations and/or category management business reviews for the assigned categories.
Develop a thorough understanding of the shopper, market, and category in order to advise on price indexing, distribution and shelving opportunities delivering total category growth.
Assist Category team members by providing Category Management tools, methods, and analytics to support fact-based pricing strategies.
Requirements
- Must be a United States Citizen
- Application materials must be received by 11:59 EST on the closing date.
- Work Schedule: Full Time
- Tour of Duty: M-F (weekends, holidays, nights possible but rare)
- Permanent Change of Station (PCS) Costs: Are Authorized; If you PCS'd at government expense within the past 12 months, additional government funded PCS may not be authorized; however, you may choose to pay your own moving costs.
- Position Sensitivity: Non-Critical Sensitive
- Security Requirements: Secret
- Overtime: Occasionally
- Temporary Duty (TDY) Travel: Occasionally
- Fair Labor Standards Act (FLSA): Exempt
- Bargaining Unit Position: No
- Physical Requirement: Not applicable
- Obligated Position: No
- Selective Service Requirement: All male applicants born after December 31, 1959 must be registered with the selective service system or exempt from Selective Service. Please visit https://www.sss.gov/ for more information.
- Category Management Professionals Certification: Required within 18 months of appointment to this position.
Qualifications
In accordance with the General Schedule Qualification Standards for Administrative and Management Positions, https://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-standards/#url=GS-ADMIN, to qualify for this position (by the closing date of this announcement) you must possess one of the following:
To qualify at the GS-09 grade level:
(a) One year of specialized experience equivalent to GS-07 grade level that equipped you with the particular knowledge, skills, and abilities (KSAs) to perform successfully the duties of the position, and is directly in or related to this position. To be creditable, specialized experience must be at the GS-07 grade level or equivalent under other pay systems in the Federal service, military, or private sector.
Creditable specialized experience include:
Applybasic analytical knowledge of MS Excel to include the use of VLOOKUP, INDEX/MATCH, Pivot Tables and Data Tables
Perform analyses of data and processes and performs data gathering and identification of potential business data for use in Category Management reports.
Produce performance reports at cascading organizational levels, displaying a variety of interrelated performance statistics for use in isolating operational results that significantly deviate from the norm in either a positive or negative direction.
Manage the evolution of multiple syndicated databases to ensure data quality and delivery.
OR
(b) A Master's or equivalent graduate degree or two years of progressively higher-level graduate education leading to such a degree. Education must be from a college or university accredited by an organization approved by the U.S. Department of Education (https://ope.ed.gov/accreditation/) and in an appropriate field of study as described elsewhere in this announcement.
OR
(c) A combination of experience and education equaling 100% of the qualifications.
To qualify at the GS-11 grade level:
(a) One year of specialized experience equivalent to GS-09 grade level that equipped you with the particular knowledge, skills, and abilities (KSAs) to perform successfully the duties of the position, and is directly in or related to this position. To be creditable, specialized experience must be at the GS-09 grade level or equivalent under other pay systems in the Federal service, military, or private sector.
Creditable specialized experience include:
Apply intermediate analytical knowledge of MS Excel to include the use of VLOOKUP, INDEX/MATCH, Pivot Tables and Data Tables
Produce varied analyses in support of a Category Management Program.
Provide analysis for input into sales presentations for such key initiatives like new product introductions, and distribution opportunities.
Update sales reports, provide to team members and improve variety of reports ongoing with guidance of manager to ensure optimum analysis.
OR
(b) A Ph.D. or equivalent doctoral degree or three years of progressively higher-level graduate education leading to such a degree. Education must be from a college or university accredited by an organization approved by the U.S. Department of Education (https://ope.ed.gov/accreditation/) and in an appropriate field of study as described elsewhere in this announcement.
OR
(c) A combination of experience and education equaling 100% of the qualifications.
To qualify at the GS-12 grade level:
One year of specialized experience equivalent to GS-11 grade level that equipped you with the particular knowledge, skills, and abilities (KSAs) to perform successfully the duties of the position, and is directly in or related to this position. To be creditable, specialized experience must be at the GS-11 grade level or equivalent under other pay systems in the Federal service, military, or private sector.
Creditable specialized experience include:
Apply advanced analytical knowledge of MS Excel to include the use of VLOOKUP, INDEX/MATCH, Pivot Tables and Data Tables
Analyze and manipulate data to help team identify and establish goals.
Understand customer initiatives and support category management initiatives.
Analyze and report on data to include: sales statistics at the item, category, and departmental levels, shopper demographic characteristics, customer base composition, store operational profiles, and consumer shopping dynamics.
Education cannot be substituted for specialized experience at the GS-12 grade level.
You will receive credit for all relevant qualifying experience (paid and unpaid), including volunteer work done through National Service program (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social).
Additional Requirements that must be met by the closing date:
Time-in-grade applies to the promotion of current and former federal employees who hold or have held a permanent GS position in either the competitive or excepted service in the previous 52 weeks, including current employees applying under VEOA. Your application package must contain proof you meet this requirement. See Required Documents for more information.
For GS-13: You must have 52 weeks of Federal service at or equivalent to GS-12.
Time after competitive appointment. Current federal civilian employees must have completed at least 90 days of federal civilian service since being selected for a non temporary appointment from a competitive examination register of eligibles (an announcement opened to the public) or under a direct hire authority.
As part of the online application process, you will respond to a series of questions designed to evaluate your level of experience in these competencies:
Business AnalyticsCommissary Business OperationsCommunicationMinimum Qualifications- GS 9Minimum Qualifications GS-11Minimum Qualifications GS-12
Overtime: Occasional
Fair Labor Standards Act (FLSA): Exempt
Bargaining Unit Status: Not Covered
Those retired under CSRS or FERS considered: No. DoD criteria not met.
Work environment: The work is performed in an office setting with adequate lighting, heating, and ventilation and involves the ordinary risks and discomforts typical of an office environment.
Telework eligible:Yes - as determined by the agency policy (currently two in-office days per week)
Remote work eligible: No
Submitting an incomplete application package may result in your not being considered for this position. Your resume must reflect that you are either Part-Time with the number of hours listed, Full Time, or 40 hours per week as your work schedule. If you fail to provide this information in your resume, your resume will be considered as incomplete.
Military Spouse Preference: Submit (1) the Self-Certification Checklist and (2) proof of marriage to the military service member (e.g., marriage certificate, marriage license), and (3) a copy of the military service member's PCS orders.
Education
If you are relying on education to qualify, then:
- Your education must be from a college or university accredited by an organization approved by the U.S. Department of Education. See https://ope.ed.gov/accreditation/ for more information.
- If using foreign education, please see additional requirements at: https://www2.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html.
- To be creditable, education must be in a major field of study related to the position. The education must have equipped you with the knowledge and ability to perform the work of the position.
- Failure to provide transcripts will result in you being rated ineligible for this position. We accept unofficial transcripts for the application process, as long as they contain your name, the name of the school, the date and degree awarded, and the list of classes and credits earned. Transcripts must be received by this office no later than 11:59 PM EST on the closing date in order to be considered.
- If selected, an official transcript MUST be received before an Entrance of Duty date is set.
Contacts
- Address DECA HQ
1300 Eisenhower Street
Fort Gregg-Adams, VA 23801
US
- Name: DeCA HQ Servicing team
- Phone: 614-692-2331
- Email: [email protected]
Map