Idealforce has contract position available immediately for a PRAMS Data Analyst to join our customer in Phoenix,AZ. This a Remote Position Please find below additional details about this job. Only Local Candidates are considered for this role. LOCAL TO PHOENIX ONLY
Position Summary:
Position Title: PRAMS Data Analyst and Dashboard Contractor Arizona Department of Health Services – Bureau of Assessment and Evaluation – Office of Population Surveys Program: Pregnancy Risk Assessment Monitoring System (PRAMS)
1. Position Summary
The contractor will update the Arizona Pregnancy Risk Assessment Monitoring System (PRAMS) data dashboard by incorporating the most recent available Phase 9 survey data. The existing dashboard contains Phase 8 data and is built in Microsoft Power BI using SQL Server. PRAMS is an ongoing, site-specific, population-based surveillance system that collects data from women who recently had a live birth on their experiences before, during, and after pregnancy. The purpose of PRAMS is to identify groups of women and infants at high risk for health problems, to monitor changes in health status, and to measure progress towards goals in improving the health of mothers and infants. The contractor will modify existing SAS programs to recalculate PRAMS weighted estimates, assess comparability between Phase 8 and Phase 9 variables, and update dashboard visualizations in Power BI and supporting content. The contractor will ensure that estimates are statistically appropriate, validated, and clearly presented, with appropriate documentation of variables that are not comparable across survey phases. A draft dashboard must be completed by the end of month five, with final revisions and dashboard launch by the end of the six-month contract period.
2. Key Responsibilities
-Data analysis: Review and modify existing SAS programs to incorporate two to three years of Phase 9 data with over 2,400 observations and recalculate PRAMS estimates using appropriate complex survey methods, including 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. Document differences and recommend appropriate approaches for cross-phase comparisons.
-Dashboard updates: Integrate validated estimates into the existing SQL Server and Power BI workflow and update relevant tables, visualizations, indicators, filters, and explanatory text. Complete minor corrections to the existing dashboard.
-Quality assurance: Validate estimates and dashboard outputs, investigate discrepancies, and ensure that comparisons are methodologically appropriate and limitations are clearly communicated.
- Documentation: Provide modified SAS programs, a variable comparability matrix, analytical documentation, and instructions to support future dashboard maintenance.
-Collaboration: Communicate progress, consult with project staff on analytical decisions, incorporate feedback, and meet established project milestones.
-Confidentiality: Comply with all applicable confidentiality requirements, data-use agreements, privacy protections, data suppression standards, and information security policies.
3. Preferred Competencies
-Experience analyzing complex survey data and calculating weighted estimates.
Proficiency in SAS, SQL, and Microsoft Power BI.
-Experience assessing variable comparability and harmonizing data across survey phases or reporting periods.
-Knowledge of survey methodology, data visualization, and public health reporting.
-Strong analytical, documentation, quality assurance, and project management skills.
- Familiarity with maternal and infant health data or public health surveillance systems.
4. Qualifications Required:
-Bachelor's degree in public health, epidemiology, biostatistics, statistics, data science, or a related field, or equivalent relevant professional experience.
- Demonstrated experience using SAS to analyze data and modify existing analytical programs.
- Experience analyzing complex survey data using appropriate statistical methods.
- Proficiency in SQL and experience working with relational databases.
-Experience developing or maintaining Microsoft Power BI dashboards.
- Ability to validate analytical results, document methods, and meet project deadlines.
- Ability to comply with applicable confidentiality and information security requirements.
-Ability to provide and maintain the necessary analytical software, including a valid, authorized SAS environment, at the contractor's expense unless otherwise agreed upon in writing.
4.Preferred:
-Experience with PRAMS or similar public health survey data.
-Experience comparing survey variables across different phases or survey cycles.
-Familiarity with SQL Server–Power BI workflows and survey estimation procedures in SAS.
5. Work Environment This is a fully remote, part-time contract position requiring up to 20 hours per week for up to six months. The contractor will work independently and coordinate with project staff through virtual meetings, email, and other approved communication platforms. The contractor is responsible for providing their own reliable internet access and required analytical software unless otherwise agreed upon in writing. ADHS will provide a laptop and access to project data and organizational systems. The contractor must use authorized systems and comply with all applicable confidentiality, datause, and security requirements when accessing, processing, storing, or transferring PRAMS data.
Required Skills
Experience analyzing complex survey data
Power BI
SAS The Resource must provide their own licensed SAS statistical analysis software (SAS 9.4 or later, or SAS Viya)
Preferred Skills
THIRD PARTY CANDIDATES: Email your candidate/s resume to jb dot resumes at idealforce.com along with the following details: Rate, Current location and Availability.
Disclaimer :The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.
