Wic Statistician

Perform highly advanced (senior-level) statistical analysis work for the Vendor Management & Operations Unit within the Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) Program. Oversee development and testing of data sets to target fraud, waste, and abuse among WIC vendors. Develop test data gathering designs, sampling techniques, and analytical methods for analysis of WIC program vendor data. Collaborate with Information Resources and WIC staff on data gathering for USDA and WIC studies. Responsible for statistical methodology for identifying high risk vendors. Conduct statistical analysis of vendor reports and other documentation to identify trends in vendor compliance. Design complex reports and databases using various systems and software (for example, SQL, PowerBI, Tableau, Statistica and SPSS). Utilize Microsoft Office, including Excel, for complex projects requiring extensive knowledge of the software and its functions. Collaborate with WIC staff on preparation of WIC program and vendor reports. Utilize Qualtrics or other software to create, distribute, and analyze surveys. Analyze data for preparation of various WIC program and vendor reports to ensure data integrity. Build business cases from data. Communicate both verbally and in writing with a wide variety of internal and external stakeholders. Work under mínimal supervision, with extensive latitude for the use of initiative and independent judgment.

**Essential Job Functions**:
Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.
- 1. Oversee development and testing of data sets, which includes database development, database query tests, validation of data, and development of methodologies that will detect fraud, waste, and abuse among WIC vendors. Requires the utilization of various systems and software (SQL, PowerBI, Tableau, Statistica, SPSS, and Microsoft Office, including Excel, etc). (15%)
- 2. Responsible for statistical methodology for identifying high risk vendors, which includes being part of a project team, interfacing with staff and vendors, data and requirements gathering, trend analysis, retail industry research, and conducting statistical tests. (15%)
- 3. Develop test data gathering designs, sampling techniques, and analytical methods for analysis of WIC program vendor data and build business cases from data, including surveys. (15%)
- 4. Conduct statistical analysis of vendor reports and other documentation to identify trends in vendor compliance. (15%)
- 5. Analyze grocer retail data for preparation of monthly, quarterly, ad-hoc and yearly report requirements. Data must be validated and formatted to specific templates. Analysis includes trend, forecast, financial, statically based and supported, and industry cluster related. (10%)
- 6. Oversee development of monthly, quarterly, yearly, and ad-hoc reporting. Responsible for working with WIC staff to determine reporting needs, prepare templates, then recommend action. (10%)
- 7. Collaborate with WIC staff, and internal and external stakeholders on data gathering for reporting purposes to ensure data integrity. (5%)
- 8. Serve as statistical Subject Matter Expert for the Unit and WIC and provide expert advice on national and regional WIC studies. This includes expert data analysis, comprehension of reported information, and recommended action. (5%)
- 9. Communicate clearly both verbally and in writing with a wide variety of internal and external stakeholders. (5%)
- 10. Perform other duties as assigned including but not limited to actively participating and/or serving in a supporting role to meet the agency's obligations for disaster response and/or recovery or Continuity of Operations (COOP) activation. Such participation may require an alternate shift pattern assignment and/or locations. (5%)

**Knowledge Skills Abilities**:
Knowledge of:

- Statistics and mathematics
- Statistical methods and formulas
- Research techniques, and of the sources and availability of information
- Fraud, waste, and abuse statistical methodologies
- Quality assurance procedures
- WIC Program, and WIC federal regulations and guidelines
- Basic economic principles

Skill in:

- Organizing, managing, and prioritizing tasks and schedules
- Report preparation of a scientific topic for internal and external stakeholders
- Retrieving and analyzing data using, for example, SQL, PowerBI, Tableau, Statistica, SPSS
- Using Microsoft Office, including Excel
- Developing and designing sampling techniques and statistical methodologies
- Data analysis methods and statistical analysis, statistical tools and databases
- Organizing, coordinating, and directing statistical research projects and reports
- Evaluating statistical data, conducting qualitative and quantitative analysis
- Directing the development of data collection methods
- Presenting and explaining analytical results clearly and concisely
- Building