Summary You are responsible for the completeness and accuracy of your application package. We encourage you to read the entire announcement before starting the application process. Qualifications and requirements must be met by the announcement closing date. This recruitment is subject to restrictions of the DoD referral system for displaced employees. Additional positions may be filled from this announcement up to 90 days after it closes. Responsibilities Serves as a Retail Data Analyst at a Defense Commissary Agency (DeCA) HQ facility. The primary purpose of this position is to serve as a data & grocery pricing analyst providing essential analytical and pricing execution support for the DeCA's centralized category management function. Position responsibilities include: This position is located in the Defense Commissary Agency (DECA) HQ, Sales, Marketing and Logistics Group, Strategic Revenue Management Office. Executes and refines a retail pricing strategy across categories with strategic and financial goals defines by senior leadership. Calculates factors which drive revenue, margins and savings. Provides frameworks, recommendations and subject matter expertise, to guide and support pricing decisions. Requirements Conditions of Employment Qualifications See the OPM Qualification Standards for more information. This position is covered under Clerical and Administrative Positions. To qualify for this position your resume and supporting documents must show that you possess one year of specialized experience equivalent to at least the GS-12 grade level or equivalent to at least GS-12 under other Federal service pay systems, private sector, or military. SELECTIVE PLACEMENT FACTORS: Selection will be based on the judgment of the selecting official as to which applicant is best qualified to perform the duties of the position. The breadth and depth of relevant experience and knowledge, and the quality of past performance, will be the primary considerations used for selection. Important selection factors are: knowledge to write computer code and build reports from raw data, trouble-shoot errors, anomalies or disconnects in data sets while validating data or accuracy. Thorough understanding of relational database concepts and the capability to read and write in various database languages such as SQL. Commercial retail grocery industry pricing data and familiarity with grocery products, Relational Database Concepts, Data Integration, Advanced Spreadsheet Understanding, Concepts in Data Visualization, Statistics and Predictive Modeling Understanding of price elasticity of demand, product substitution and item cannibalization concepts, Market-share analysis and the role of syndicated data in category management. Ability to perform pricing and market analysis and coordinate pricing for DeCA's products and/or service in order to maximize savings, optimize revenue and meet marketing, financial and corporate growth objectives. Comprehensive knowledge of retail grocery accounting, finance analysis, pricing, revenue optimization, or economics is required in order to execute financial models to access and build effective retail pricing structures. Knowledge of an experience in commercial retail grocery industry and pricing strategies is required advised in order to compile and review internal and external data leverage optimization tools to make informed pricing recommendations. Knowledge of grocery store-based price elasticity and discrete choice pricing studies. Comprehensive knowledge of and experience with specific commercial retail grocery pricing concepts such as price elasticity, transaction profitability assessment, margin and revenue analysis, price band analysis, and price waterfall analysis, or equivalent relevant experience in professional consulting services. QUALITY RANKING FACTORS: Possesses knowledge of Consumer-Packaged Goods (CPG) market research, including established business, new product and new business introductions. This knowledge is used to conduct intensive data driven studies to support the pricing function and the category at large. Possesses knowledge of advanced retail grocery analytics (pricing, marketing mix, market structure and annual sales plan), financial measurements, syndicated sales tools, databases, forecasting, and and understanding of industry category management practices and internal CPG processes: Sales, Marketing, Finance, Strategic Planning, Discrete Product Groups, Product Attributes, Consumer decision trees, Supply Chain, Custom-defined Trade areas, etc. This knowledge is used to support the pricing analysis function. Possesses mastery of management principles, practices, concepts, and a wide range of analytical, quantitative and statistical techniques and tools. This knowledge is used to conduct wide ranging business studies and interpretation of retail pricing data and processes and to derive pricing insights from large, complex data environments. Possesses knowledge and working experience in, identifying and evaluating retail grocery pricing opportunities, and knowledge of the various retail performance levers. Ability to model economics and analyze sensitivity and ability to model markdowns, discounts, and other conditions related to retail pricing strategies. Experience refers to paid and unpaid experience, 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). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience. Examples of qualifying specialized experience: Performs pricing and market analysis to maximize savings, optimize revenue and meet marketing, financial and corporate growth objectives. Provides financial analysis and analytical support and improves performance across policy, sales, and profit goals. Researches and tracks competitor pricing and market trends. You must also meet the following requirements by the announcement closing date: Current and former federal employees in either the competitive or excepted service and current federal employees applying under VEOA eligibility are subject to time-in-grade. You must have served 52 weeks at the next lower grade level to be eligible for promotion. See the Required Documents section to learn what documents are necessary to show you meet this requirement. The next lower grade level for this position is GS-12. Current civilian employees must have completed at least 90 days of federal civilian service since their latest non temporary appointment from a competitive referral certificate, known as time after competitive appointment. For this requirement, a competitive appointment is one where you applied to and were appointed from an announcement open to "All US Citizens." Education You may not use education to qualify. Additional Information We encourage you to review the Safer Federal Workplace information regarding COVID-19. To ensure compliance with an applicable preliminary nationwide injunction, which may be supplemented, modified, or vacated, depending on the course of ongoing litigation, the Federal Government will take no action to implement or enforce the COVID-19 vaccination requirement pursuant to Executive Order 14043 on Requiring Coronavirus Disease 2019 Vaccination for Federal Employees. Therefore, to the extent a Federal job announcement includes the requirement that applicants must be fully vaccinated against COVID-19 pursuant to E.O. 14043, that requirement does not currently apply. Federal agencies may request information regarding the vaccination status of selected applicants for the purposes of implementing other workplace safety protocols, such as protocols related to masking, physical distancing, testing, travel, and quarantine. Applicants with a Permanent Resident Card (aka Green Card) are authorized to live and work in the U.S. but are not eligible for employment in positions requiring U.S. citizenship. This position requires U.S. citizenship. The minimum age requirement is generally 18 years of age. Employing those under 18 may be possible under certain circumstances. If under 18 years of age, ensure you provide documentation showing how you are eligible. Subject to occasional overtime. Position is exempt from Fair Labor Standards Act (FLSA). Position is not covered by a bargaining unit. Position is not obligated. Financial Difficulty does not automatically remove you from consideration for a position. Position does not meet the DoD criteria for re-employing former Federal employees who retired under either the Civil Service Retirement System (CSRS) or the Federal Employees Retirement System (FERS). Deliberate attempts to falsify your application information, such as copying portions of this job announcement into your resume, may result in you being removed from consideration for this position. PCS is Authorized. Most civilian PCS entitlements are now taxable. The Relocation Income Tax Allowance (RITA) reimburses eligible employees for additional Federal, State, and local income taxes incurred as a result of receiving taxable travel income. More information is available at Civilian Relocation/PCS Tax Changes Position requires access to personal/private sensitive but unclassified/controlled unclassified information the unauthorized disclosure of which could cause moderate damage to individuals, business entities; or government programs and operations. Incumbent must exercise strong interpersonal, organizational, and written/oral communication skills as well as a high degree if initiative and judgement in a day to day activities. This position requires the ability to manage several projects simultaneously. Incumbent must be able to write code and build reports from raw data, trouble shoot errors, anomalies or disconnects in datasets while validating data for accuracy. Incumbent should posses a basic understanding of relational database concepts, capable in the ability to read and write in various database languages such as SQL. Position requires access to DeCA's business systems and is designated IT Level II. Therefore, incumbent must be able to obtain and maintain security clearance eligibility based on appropriate background investigation. Required completion of a conflict of interest questionnaire as a condition of employment.
