Job Title: PRAMS Data Analyst and Dashboard Contractor (Part-Time) Job Code: AZDHS 14462 Client: State of Arizona – Arizona Department of Health Services (AZDHS) Department: Division of Public Health Prevention – Bureau of Assessment and Evaluation, Office of Population Surveys Program: Pregnancy Risk Assessment Monitoring System (PRAMS) Location: Arizona (Phoenix, AZ 85007) Duration: 5 Months from Projected Start Date Work Hours: Monday–Friday, 8:00 AM–5:00 PM (20 hours/week) Work Arrangement: 100% Remote – Arizona Residents Only Work Location Address: 1802 West Jackson, Suite 100, Phoenix, AZ 85007 Closing Date: 11/11/2026 at 3:00 PM
Position Overview
The Arizona Department of Health Services is seeking a PRAMS Data Analyst and Dashboard Contractor to update the Arizona Pregnancy Risk Assessment Monitoring System (PRAMS) data dashboard by incorporating the latest available Phase 9 survey data.
The existing dashboard is built using Microsoft Power BI and SQL Server and currently contains Phase 8 data.
The selected candidate will modify existing SAS programs to recalculate PRAMS weighted estimates, evaluate comparability between Phase 8 and Phase 9 survey variables, and update dashboard visualizations and supporting content.
The contractor will ensure that analytical estimates are statistically appropriate, validated, and clearly presented, with proper documentation of variables that are not comparable across survey phases.
Required Qualifications
- Bachelor's degree in Public Health, Epidemiology, Biostatistics, Statistics, Data Science, or a related field, or equivalent relevant professional experience.
- Demonstrated experience analyzing complex survey data using appropriate statistical methods.
- Experience using SAS to analyze data and modify existing analytical programs.
- Proficiency in Microsoft Power BI and experience developing or maintaining dashboards.
- Experience working with SQL and relational databases.
- Ability to validate analytical results and document analytical methods.
- Strong analytical, problem-solving, and communication skills.
- Ability to meet project deadlines and comply with confidentiality and information security requirements.
Preferred Qualifications
- Experience with PRAMS or similar public health survey data.
- Experience comparing survey variables across different phases or survey cycles.
- Proficiency in SAS, SQL, and Microsoft Power BI.
- Experience calculating weighted estimates and working with complex survey methodologies.
- Familiarity with SQL Server–Power BI workflows.
- Knowledge of public health reporting, survey methodology, and data visualization.
- Experience with maternal and infant health data or public health surveillance systems.
- Strong documentation, quality assurance, and project management skills.
Key Responsibilities
- Data Analysis: Review and modify existing SAS programs to incorporate 2–3 years of Phase 9 data, covering more than 2,400 observations, and recalculate PRAMS estimates using survey weights and variance estimation.
- Phase Comparability Assessment: Review Phase 8 and Phase 9 survey instruments, codebooks, and variable definitions to identify comparable, conditionally comparable, and non-comparable variables.
- Dashboard Updates: Integrate validated estimates into the existing SQL Server and Power BI workflow and update tables, visualizations, indicators, filters, and explanatory content.
- Quality Assurance: Validate estimates and dashboard outputs, investigate discrepancies, and ensure comparisons are methodologically appropriate.
- Documentation: Provide modified SAS programs, a variable comparability matrix, analytical documentation, and instructions for future dashboard maintenance.
- Collaboration: Coordinate with project staff, communicate progress, discuss analytical decisions, incorporate feedback, and meet project milestones.
- Confidentiality: Follow applicable data-use agreements, privacy protections, data suppression standards, and information security policies.
Project Deliverables
- Updated PRAMS dashboard incorporating Phase 9 survey data.
- Modified SAS programs for calculating weighted estimates.
- Variable comparability matrix covering Phase 8 and Phase 9.
- Analytical documentation and validation results.
- Instructions to support future dashboard maintenance.
Project timeline
- Draft dashboard: By the end of month five.
- Final revisions and dashboard launch: By the end of the six-month contract period.
