Data Analyst

SANTA CLARA COUNTY, CA
Published
September 16, 2022
Location
San Jose, CA
Job Type
 

Description

Under general supervision, to identify, capture, manage, and analyze the County's data to provide data analysis including the conceptualization, modeling and presentation of data.

* * * * * * * * * * * * IMPORTANT * * * * * * * * * * *
EXAMINATION DATES: Candidates who meet the employment standards will be invited to take an online written examination through a secure third party, tentatively scheduled for the week of October 17, 2022. Qualifying candidates will be notified with examination instructions via the email address attached to their applications.

COVID-19 Risk Tier - Lower Risk
#INDTSS
Typical Tasks

  • Maintains up-to-date knowledge of regulatory requirements and industry best practices as it relates to data stewardship;
  • Trains business users on data structure and meaning within analytics platforms to enable self-service reporting;
  • Triages data-related issues around quality and analytical production;
  • Pinpoints trends, correlations and patterns in complicated data sets;
  • Documents and maintains all data management procedures and specifications;
  • Provides guidance to data stewards in the range of stewardship activities and best practices;
  • Identifies opportunities to increase data quality, including automation and data entry procedural training;
  • Catalogs existing data sources;
  • Monitors and provides status reports on data lifecycle and analytical workflow processes;
  • Queries and profiles data to determine conformance to standards and fit for purpose;
  • Classifies and organizes data for ease of use and access control purposes;
  • Works with open datasets, including populating and extracting data from internal and public open datasets;
  • Creates data visualizations and reports using business intelligence tools;
  • Extracts and manages multiple sets of data from various databases and sources, bringing together data from several channels for comparative analysis;
  • Mines and analyzes data using standard statistical tools and techniques;
  • Reviews and validates data for accuracy; performs data cleansing as needed;
  • Documents and maintains record of all data management activities;
  • May be assigned as a Disaster Service Worker, as required;
  • Performs other related duties as required.

Employment Standards
Sufficient education, training, and experience to demonstrate the possession and direct application of the following knowledge and abilities:

Training and Experience Note:
Possession of a Bachelor's degree from an accredited college in Computer Science, Information Technology, Mathematics, Statistics or Engineering,

and

Three (3) years of experience directly related to data analysis, or statistical analysis at a level comparable to the County's Associate Data Analyst classification.

OR

Possession of a Bachelor's Degree from an accredited college,

and

Five (5) years of experience directly related to data analysis or statistical analysis. Three (3) years of this experience must be at a level comparable to the County's Associate Data Analyst classification.

Special Requirements

  • Ability to travel to alternate locations in the course of work.If driving, possession of a valid California Driver's License prior to appointment and the ability to qualify for and maintain a County driver authorization.
  • Depending on the position, other related certifications may be required or desirable.

Knowledge of:

  • Data stewardship regulatory requirements and industry best practices;
  • Trends, correlations and patterns in data sets;
  • Methods to increase data quality;
  • Spreadsheets and databases, such as MS Access;
  • Relational databases, NoSQL databases, data extraction, querying, and scripting;
  • Scripting and coding to automate and monitor data management processes;
  • Data visualizations and reporting tools to present information to a variety of audiences using presentation layer tools;
  • Extracting and managing multiple sets of data from various databases and sources, bringing together data from several channels for comparative analysis;
  • Initial data exploration steps (binning, pivoting, summarizing and finding correlations, for example);
  • Standard statistical tools and techniques.

For positions assigned to the healthcare vertical, the following knowledge is required:

  • Specific data handling requirements for patient identifiable information and protected health information.
  • Healthcare data standards, taxonomies and reference data coding systems (i.e. ICD 10, CPT, SNOMED-CT, etc.)
  • EPIC Certification in appropriate functional area, or ability to become certified within 6 months
  • For positions assigned to the healthcare vertical, the following knowledge is desirable:
  • Healthcare integration technologies and techniques (HL7 v2 or higher, EDI, etc.)
  • EPIC data warehousing and reporting environments (Caboodle, Clarity, Business Objects, etc.)

Ability to:

  • Triage code problems;
  • Implement statistical modes to identify trends, correlations and patterns in data sets;
  • Increase data quality;
  • Catalog data sources;
  • Maintain, design and create relational databases and data systems;
  • Design reporting dashboards;
  • Use presentations tools;
  • Manage multiple sets of data;
  • Mine and analyze data;
  • Perform data cleansing;
  • Document and maintain records.

Closing Date/Time: 9/28/2022 11:59 PM Pacific

Apply
Drop files here browse files ...

Related Jobs

OMMA Data Scientist   Oklahoma County, OK new
September 25, 2022
Data Analyst   Coconut Creek, FL new
September 24, 2022
Data Analyst   Roseville, MN new
September 22, 2022
Associate Data Analyst   San Jose, CA new
September 22, 2022
Report Writer/Data Analyst (518234)   San Luis Obispo, CA
September 17, 2022