[Hiring] Data Analyst @S R INTERNATIONAL INC

Role Description

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.
• Update dashboard visualizations and supporting content.
• Ensure that analytical estimates are statistically appropriate, validated, and clearly presented.
• Document variables that are not comparable across survey phases.

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.

Requirements

• 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.