Statistical Analyst

SAN-Bernardino-Count; San Bernardino (CA); On-site; USD 85,000 - 120,000; Full time

Job summary

San Bernardino County's Department of Public Health seeks Statistical Analysts to plan, develop, and implement statistical applications for departmental programs, advancing health equity in underserved communities.

You will design evaluations, build data pipelines, create dashboards with Power BI, Tableau, and ESRI ArcGIS, and provide statistical consultation to stakeholders. Collaborate with cross-functional teams to translate data into actionable insights for policy and program improvements.

Qualifications

• Master's degree or higher in Statistics or related field with graduate coursework in Statistics or Research Methodology.
• Bachelor's degree with upper-division coursework in Statistics or Research Methodology; unofficial transcript required.
• One year of professional-level experience in statistical analysis using SAS, SPSS or similar software.

Responsibilities

• Design, conduct and support complex program evaluations and surveys; develop data collection forms and data infrastructure.
• Collect, clean, and organize data from multiple sources ensuring data quality for analysis.
• Create automated data pipelines and ETL workflows using Python, R, SQL, Tableau, or SAS.
• Develop dashboards and reports with Power BI, ArcGIS, Tableau to communicate insights to stakeholders.
• Coordinate with County and agencies to obtain data and support grant proposals with statistical input.
• Collaborate with cross-functional teams to define analytic requirements and provide actionable insights.
• Prepare recommendations and data-driven proposals; support internal and external partners with analyses.
• Translate complex data into clear visuals and coordinate stakeholder engagement and meetings.

Skills

Multivariate analysis

SQL

Tableau

Power BI

GIS

SAS

Python

R

Data visualization

Data cleaning

Education

Master's degree in Statistics or related field

Bachelor's degree with 12 semester units in Statistics or Research Methodology

Tools

SAS

SPSS

SQL

R

Python

Tableau

Power BI

ArcGIS

Excel

Job description

The Department of Public Health (DPH)

The Department of Public Health (DPH) is recruiting for Statistical Analysts who plan, organize, develop, and implement analysis and statistical applications for departmental programs. Statistical Analysts are key members of a team dedicated to advancing health equity in underserved communities. This role involves conducting rigorous statistical analyses to uncover disparities in health outcomes and access to healthcare services. The analyst will collaborate closely with cross-functional teams to generate evidence-based insights that drive interventions and policies aimed at reducing health inequalities. The incumbent assigned to this role will support the Community Vital Signs (CVS) Services.

Responsibilities

• Design, conduct and/or support complex program evaluations; develop and administer surveys and questionnaires; conduct focus groups and personal interviews; develop forms, procedures, schedules, and sampling criteria for field data collection; design develop and maintain databases; write queries to extract data for ongoing and ad hoc management reports.
• Collect, clean, and organize data from various sources, ensuring its accuracy and completeness of data quality and assurance for analysis.
• Create automated data pipelines and workflows to streamline data processing, integration, and analysis tasks using a variety of technologies and tools (e.g. Python, R, SQL, Tableau, SAS).
• Utilize automation tools and techniques to streamline data extraction, transformation, and load (ETL processing), and reduce manual effort and improving efficiency.
• Develop interactive and visually appealing dashboards and reports using data visualization tools like Power BI, ESRI ArcGIS, Tableau, or similar platforms to effectively communicate insights to stakeholders.
• Coordinate with County and other agencies to obtain data, design, organize and develop research evaluation plans and provide data for grant proposals, and provide statistical consultation and guidance for stakeholders.
• Collaborate with cross-functional teams to understand business objectives, define analytical requirements, and provide actionable insights to support organizational goals.
• Prepare written proposals, and recommendations for improvement; implement data analytic solutions; and provide statistical consultation and guidance for stakeholders.
• Provide data support to internal and external partners, including ad hoc analyses and special projects.
• Translate complex data into clear, visually compelling materials and coordinate stakeholder engagement, meetings, and workgroup support.

EXCELLENT BENEFITS

To review job-specific benefits, refer to: Summary of Benefits and the Memoranda of Understanding (MOU).

For more detailed information, refer to the Statistical Analyst job description.

CONDITIONS OF EMPLOYMENT

Pre-Employment Process: Prior to appointment, applicants must pass a background investigation which includes verification of employment history and education, fingerprinting, physical exam, and drug screening.

Travel: Travel throughout the County may be required and employees will be required to make provisions for such transportation.

Visa Sponsorship: Please note San Bernardino County is not able to consider candidates who will require visa sponsorship at the time of application or in the future.

Applicants must meet one of the following options

Option 1:
Education: A Master's Degree or higher from an accredited college or university recognized by the United States Department of Education in Statistics, Math, Physical/Behavioral/Social/Life/Other Science, or Public/Business Administration, which must include twelve (12) semester (18) quarter units of completed graduate level coursework in Statistics or Research Methodology. An unofficial transcript listing all completed coursework must be submitted with the application.

Option 2:
Education: A Bachelor's Degree from an accredited college or university recognized by the United States Department of Education in Statistics, Math, Physical/Behavioral/Social/Life/Other Science, or Public/Business Administration, which must include twelve (12) semester (18 quarter) units of completed upper division coursework in Statistics or Research Methodology. An unofficial transcript listing all completed and in-progress coursework must be submitted with the application. -AND-

Experience: One (1) year of technical or professional-level full-time equivalent experience conducting research studies, mathematical analysis, or statistical analysis using SAS, SPSS or other statistical software programs. Time spent in these duties must be clearly distinguished from time spent on other duties such as teaching.

Qualifying degrees or coursework must be completed at a college or university accredited by an accrediting association recognized by the United States Department of Education. In addition, degrees completed outside of the U.S. must be accompanied by an evaluation report from a reputable credential evaluation service indicating equivalency to degrees or coursework completed at a college or university accredited by an accrediting association recognized by the United States Department of Education.

Desirable skills include the ability to

• Manipulate data and prepare visualizations using Excel
• Conduct and interpret the results of multivariate analysis using statistical methods
• Prepare visualizations using business intelligence platforms (Tableau and Power BI)
• Utilize Geographic Information Systems (GIS) software products for spatial analysis
• Query data and write scripts using SQL; utilize relational database systems
• Program data-related commands using SAS, SPSS, STATA, R, Python, or equivalent
• Create automated reports and develop data dashboards for web publication
• Conduct studies and/or analysis of Demographic/Epidemiological/Health/Crime Statistics or evaluations to measure government program/policy effectiveness

An online examination and writing exercise will be administered to assess your knowledge and skillss on the following topics:

• Statistical Concepts
• Research Methods and Design
• Qualitative and Quantitative Data Analysis
• Geographic Information Systems (GIS)
• Data Interpretation

Equal Employment Opportunity (EEO) / Americans with Disabilities Act (ADA)

San Bernardino County is an Equal Employment Opportunity (EEO) and Americans with DisabilitiesAct (ADA) compliant employer, dedicated to ensuring equal employment opportunities for allemployees and applicants.