Statistical Analyst

San Bernardino County; San Bernardino (CA); On-site; USD 85,000 - 110,000; Full time

Job summary

San Bernardino County's Department of Public Health is seeking a Statistical Analyst to plan, organize, and implement analyses across departmental programs, with a focus on health equity in underserved communities.

You will design evaluations, build automated data pipelines, and develop interactive dashboards using Python, R, SQL, Tableau, Power BI, and GIS tools to translate data into actionable insights for policy and program improvements.

Qualifications

• Master's or Bachelor's in Statistics, Math, or related field with required graduate coursework in Statistics or Research Methodology
• One year of technical or professional experience with SAS, SPSS, or other statistical software
• Accredited degree; foreign degrees require evaluation for US equivalency
• Experience designing studies, program evaluation, and data visualization

Responsibilities

• Design, conduct and support program evaluations; develop surveys, data collection forms, and sampling criteria
• Collect, clean, and organize data ensuring accuracy and data quality
• Create automated data pipelines and dashboards using Python, R, SQL, Tableau, and SAS
• Develop dashboards using Power BI, ESRI ArcGIS, Tableau for stakeholder communication
• Coordinate with County agencies to obtain data and support grant proposals
• Provide statistical consultation and guidance to stakeholders

Skills

Multivariate analysis

SQL queries

Python/R data analysis

Data visualization

GIS for spatial analysis

Education

Master's degree in Statistics or related field

Bachelor's degree in Statistics or related field

Tools

SAS

SPSS

Tableau

Power BI

ArcGIS

SQL

R

Job description

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.

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

EXCELLENT BENEFITS

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

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

• 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

Assessment

• Statistical Concepts
• Research Methods and Design
• Qualitative andQuantitative 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 Disabilities Act (ADA) compliant employer, dedicated to ensuring equal employment opportunities for all employees and applicants.

ADA Accommodation: If you have a disability and need accommodations during the testing process, please submit the Special Testing Accommodations Request Form within one week of the recruitment filing deadline.

Veterans' Preference: Eligible veterans, their spouses, or widows/widowers who are not current County employees may receive additional Veterans' Preference points. For details and instructions on how to request these points, please refer to the Veterans' Preference Information.

For more important details, review the Applicant Information and County Employment Process.