Performs complex statistical work. Work involves database administration of the family planning data for the Family Planning (FP) program staff and Office of Program Decision Support (OPDS) research staff. Support Family Planning Program staff by creating in-house applications to satisfy their internal and external reporting needs with applications that interface data with supplied by Texas Medicaid and Healthcare Partnerships (TMHP) using Access and Excel. Design and implement TMHP Business Objects ad hoc queries used to support data requests from FP, Pregnancy Risk Assessment Monitoring System (PRAMS), OPDS research staff, and dental. Familiarity with Medicaid data.
Function as a subject matter expert on family planning data structure and availability. Create user manuals for OPDS program staff for in-house applications. Act as a resource for Texas Health Steps (THSteps) TMHP Medicaid applications. Design and implement TMHP Business Objects ad hoc queries for the OPDS staff. Analyze data anomalies for the Family Planning Program staff including the source, cause, impact, and solution for rectifying the anomaly. Apply statistical theory and methods to collect, organize, interpret and summarize numerical data to provide useable information. Performs complex statistical analysis and interpretation of data used by Family and Community Health Services (FCHS) programs for planning, evaluation and assessment. Communicates with inter- and intra-agency staff and other state and national organizations to acquire data and respond to data requests. Prepares or assists in the preparation of annual publications, federal, state and other statistical reports. Works under limited supervision with considerable 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.
(50%) Applies a variety of sophisticated analytical techniques such as forecasting regression analysis to data. Acquires, compiles, edits, interprets and analyzes data for routine and special statistical reports for FCHS programs (Maternal and Child Health (MCH), FP, Children With Special Health Care Needs Services (CSHCN), Women, Infants, and Children (WIC), THSteps). The primary focus is supporting the Family Planning Program. Tracks and analyzes FCHS related vital events data at state and national levels by overseeing linkage with others state and national organizations. Disseminates FCHS related vital events data/information /reports to inter and intra-agency and external customers. Uses a wide variety of software to construct tables, graphs, charts, maps and complex reports to display results of analysis. Oversees, coordinates and prepares reports and/or materials for presentations and publications. Consults plans and executes report designs with FCHS programs, coordinating with various types of information specialists and graphic designers. Designs, plans, and prepares instructions pertaining to reports and assures updated documentation exists on all data files, analyses and materials. Provides detailed sources of information for customers as needed.
(40%) Responsible for collecting, compiling, manipulating, and editing data and information used in FCHS health status tracking, planning, evaluation, and needs assessment and included in annual program publications, other grant applications, and federal and legislative reporting. Manipulates large data sets using various types of software (e.g., Business Objects, ArcView, GIS, SAS, Excel, FoxPro, Access, Power Point and Word).
(5%) Participates in cross-functional training within the OPDS unit, supervises specific training on program related data sets and analytical techniques.
(5%) Performs 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 location
Knowledge Skills Abilities:
Knowledge: in major functions of public health; public health population, and other data sources useful to program performance; data collection and maintenance; public health informatics and data system creation; computer software (SAS, Business Objects web intelligence, Microsoft, FoxPro, ArcView). Thorough knowledge of statistics and research. Knowledge of management of health care data systems.
Skills: in the use of sophisticated statistical techniques; strong project management skills to organize major project activities into a logical sequence with a reasonable and achievable schedule of deadlines; effective oral and written communication.
Abilities: to facilitate meeting agendas to achieve planned outcomes and to convey planning alternatives or recommendations to a variety of audiences including FCHS program staff; to work independently; to gather information from a variety of sources and to synthesize and translate detailed information into simpler terms; to express ideas clearly and concisely orally and in writing; to develop and effectively deliver training and technical assistance about data methods and procedures; to plan, organize and conduct assigned phases of complex projects; to interpret complex data, charts and tables based on programmatic data. Ability to interpret policies and procedures, identify and define user needs; to compile, analyze and interpret complex statistical information; to communicate effectively; to establish and maintain effective working relationships and to work with others as part of a team.
Registration or Licensure Requirements:
Initial Selection Criteria:
1. Skill in querying data sets
2. Experience developing and analyzing reports
3. Experience developing or reporting performance measures
4. Experience with Business Objects
In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.