Job Description

Under general supervision to direction provides informatics (health data) support to manage data collection analysis and presentation for health programs projects and initiatives; maintains and optimizes databases such as Geographic Information System (GIS) Electronic Health Records (EHR) Structured Query Language (SQL) and other information management systems; performs data cleaning workflow design system implementation and advanced data visualizations; troubleshoots researches and resolves difficult and complex data analysis applications problems conducts needs analyses feasibility studies and evaluations for projects; recommends improvements for organizational policy and procedures; manages data and generates reports; makes improvements to database systems; provides technical assistance to staff; and performs related duties as assigned.

Supervision Received and Exercised
Receives general supervision from assigned supervisory or management personnel. May exercise technical and functional direction over and provide training to lower-level staff supervision over staff. Exercises no direct supervision over staff.

Examples of Duties

The job functions listed below are not inclusive or exclusive and are intended only as illustrations or examples of the various types of work that may be performed in various divisions/departments. Types of work performed shall be within the scope and licensure (if required). Reasonable accommodation will be made when requested and determined by the County to be appropriate under applicable law. Some duties knowledge and abilities may be performed in a learning capacity by positions at the entry (I) level.

• Creates and maintains health and administrative databases including GIS EHR state registries and SQL databases.
• Monitors system storage and performance sets parameters for optimal function; coordinates upgrades and testing processes.
• Coordinates data collection defines database requirements and ensures quality control.
• Conducts comprehensive data analysis including data cleaning statistical work and support for department initiatives.
• Designs and implements efficient data workflows and systems.
• Develops written reports including technical preparation determining appropriate formatting and design and compilation of final reports.
• Develops designs and supports advanced data visualizations like GIS mapping dashboards and web-based displays.
• Participates in and actively contributes to performance management and quality improvement through identification of goals monitoring data and implementing new processes; applies public health quality improvement methods tools and techniques to address root causes and improve effectiveness of programs.
• Completes data requests and supports epidemiological investigations; assists in conducting special studies and research.
• Identifies prepares maintains and updates department records files and other documentation.
• Types and proofreads forms documents correspondence and reports.
• Disseminates information stored in information systems.
• Provides technical assistance and guidance on systems to department and staff.
• Conducts regular risk assessments to identify data and system vulnerabilities assess potential threats and recommend mitigation strategies to minimize risks.
• Operates computer systems to enter and retrieve information.
• Responds to inquiries and requests for information.
• Maintains security and confidentiality of sensitive information.
• Classifies and organizes data for ease of use; reviews and validates data for accuracy; identifies clarifies and resolves data discrepancies in information systems.
• Assists other department staff in disseminating information interpreting database entries and performing corrective procedures.
• Contacts system administrator appropriate County Information Technology staff or contracted vendor for assistance as needed for maintenance and correction of information systems.
• Advises department in interpreting system records.
• Works with open datasets including populating and extracting data from internal and public datasets.
• Assists with the design development and assessment of surveys and data collection techniques to meet the needs of assigned projects or programs.
• Contributes to the accomplishment of assigned objectives in the department strategic plan and community health improvement plan.
• Maintains and operates modern office equipment including computer equipment.
• Establishes and maintains standard work procedures governing the appropriate use of data.
• Ensures accuracy and compliance with medical billing coding and follow-up requirements and lack of documentation issues.
• Reviews and follows up on denial codes analyzes reasons for denials submits appeals and reconsideration requests and makes appropriate corrections and retransmits claims.
• Gathers compiles and analyzes medical billing and statistical data and reviews encounters for payment accuracy based on services and contracts.
• Configure and maintain medical billing software settings to align with organizational workflows and payer requirements.
• Ensure proper integration of coding libraries (e.g. ICD-10 CPT) and fee schedules within the billing platform.
• Performs related duties as assigned.

Employment Standards / Minimum Qualifications

Knowledge of:

• Applicable federal state and local laws regulatory codes ordinances and procedures relevant to confidentiality including HIPAA HITECH and all other relevant laws.
• Database creation maintenance and advanced data visualization techniques (GIS dashboards web-based displays).
• Data cleaning workflow creation system design and implementation.
• Social determinants of health.
• Impacts of socioeconomic and cultural differences in public health.
• Principles of health equity as it applies to public health policy planning and practice.
• Operations services activities policies and procedures of the assigned department or division.
• Operational characteristics functions and procedures of the database and information systems used in the assigned office.
• Current computer software programs applicable to the departments information technology requirements.
• Department program terminology phraseology forms documents and procedures.
• Methods and techniques of data analysis.
• Principles and practices of data collection and report preparation.
• Principles and procedures of record-keeping.
• Principles of report preparation and writing.
• English usage spelling grammar and punctuation.
• Mathematical principles and standard statistical tools and techniques.
• Uses and limitations of computer information and operating systems.
• Modern office practices methods and computer equipment.
• Applied experience coordinating or supporting changes to system workflows configurations or documentation in systems.

Ability to:

• Perform a variety of specialized data management and statistical record keeping assignments.
• Enter and retrieve information using various a variety of information management systems such as financial accounting systems human resource information systems electronic medical or health record systems public health surveillance systems customer relationship management systems and Microsoft SharePoint 365.
• Organize work and set priorities to meet critical reporting deadlines.
• Learn principles and applications of Java Script Object Notation (JSON) and Structured Query Language (SQL).
• Learn the policies procedures functions and regulations of department records functions.
• Learn interpret and apply the policies procedures laws regulations related to records maintenance and information release.
• Learn department record keeping methods.
• Perform a variety of complex clerical record maintenance and office assistance functions.
• Research collect compile and analyze information and data.
• Assume responsibility and exercise judgement in various situations.
• Exercise good judgment flexibility creativity and sensitivity in response to changing situations and needs.
• Prepare and maintain accurate and complete records.
• Prepare clear concise and complete reports and other written materials.
• Prepare data visualization reports including tables charts graphs.
• Perform comparisons of data quickly and accurately.
• Respond to requests and inquiries about department policies and procedures.
• Deal tactfully and courteously with the public and other staff members.
• Adhere to attention to detail as per federal and state statute regulations.
• Understand and follow oral and written instructions.
• Maintain confidentiality of sensitive information and data.
• Communicate clearly and concisely both orally and in writing.
• Establish maintain and foster positive and harmonious working relationships with those contacted in the course of work.
• Review medical billing claims analyze and correct errors and manage denials.
• Obtain CHDA (Certified Health Data Analyst) certification. Obtain SQL certification demonstrating proficiency in database management and querying.

Education and Experience
Any combination of training and experience that would provide the required knowledge skills and abilities is qualifying. A typical way to obtain the required qualifications would be:

• Equivalent to a bachelors degree from an accredited four-year college or university with major coursework in biostatistics epidemiology mathematics public health information systems computer science business administration or a closely related field.

Licenses and Certifications

• Some positions may require possession of or ability to obtain by the time of appointment an appropriate California drivers license.
• Some positions may require possession of or ability to obtain nationally recognized industry specific technical certification(s) pertinent to the assigned area(s) of responsibility.

Physical Demands
Must possess mobility to work in standard office setting and use standard office equipment including a computer and to operate a motor vehicle and visit various County sites; vision to read printed materials and a computer screen; and hearing and speech to communicate in person and over the telephone. Standing in and walking between work areas is frequently required. Finger dexterity is needed to access enter and retrieve data using a computer keyboard or calculator and to operate above mentioned equipment. Positions in this classification frequently bend stoop kneel and reach to perform assigned duties as well as push and pull drawers open and closed to retrieve and file information. Employees must possess the ability to lift carry push and pull materials and objects up to 10 pounds.

Environmental Conditions
Employees predominately work in an office environment with moderate noise levels controlled temperature conditions and no direct exposure to hazardous physical substances. Employees may work in the field and occasionally be exposed to loud noise levels cold and hot temperatures inclement weather conditions and may have direct exposure to hazardous substances. Employees may interact with members of the public or with staff under emotionally stressful conditions while interpreting and enforcing departmental policies and procedures.

Application Process

The application review process will include screening to ensure applications are complete and meet all minimum addition to the application the applicant is required to complete the Supplemental Questions to further evaluate their education training and experience relative to the required knowledge and abilities for the position. Applicants must submit answers that are as complete as possible.

Only the most qualified applicants who pass the minimum qualifications review will be invited to the examination process which may be administered by a written examination oral interview or any combination of qualifications appraisal determined by the Department of Human Resources to be appropriate. The Department of Human Resources will make reasonable accommodation in the examination process for disabled applicants. If you have an accommodation request please indicate such on your application.

Depending upon the number of applicants meeting the minimum qualifications applicants may be scheduled for the assessment listed below. Passing score is 70% out of 100%.

THE ASSESSMENT (100%) IS TENTATIVELY SCHEDULED FOR THUR SDAY OCTOBER 22 2026.

To move forward in the application process you must complete an online application through our website All job postings are also included via the TDD phone at and the 24-hour job line at . Please attach a copy of your unofficial transcripts (indicating when degree was awarded) licenses and certificates to your application or your application may be considered incomplete. Resumes may be uploaded but cannot be used in place of a completed application.

Those applicants claiming veterans preference must submit a copy of their DD-214 form along with the application. Candidates who attain ranking on an eligible list and are involuntarily called to active duty may be considered for eligibility reinstatement upon their return.

Placement on Eligible List:

The Civil Service Commission may limit the number of qualified applicants eligible to participate in the examination process. If two or more candidates have the same total final score on an examination they shall be ranked in order of their scores in that portion of the examination which has the greatest weight. The names of two or more eligibles having final ratings which are identical shall be grouped on the eligible list as tie names with equal rank for certification and appointment purposes.

Candidates who are successful in all phases of the examination process will be placed on an eligible list in rank order based on a calculation of their total score from the examination process. The eligible list established by this recruitment will be active for a minimum of six (6) months or one (1) year unless otherwise determined by the Director pursuant to section 6-4 (b) and may be extended for up to an additional year by the Commission.

PRE-EMPLOYMENT MEDICAL REQUIREMENTS:
As a condition of employment with the County of Madera a candidate must submit to a Tuberculosis (TB) screening and related follow up testing as necessary. Designated classifications* are also subject to a medical examination which includes a review of medical history. TB screenings and medical exams are administered by the Madera County Public Health Department and/or health care professional designated by the County.

Designated classifications required to submit to an employment medical examination generally include those that are physical in nature or as may be required by law. If you have any questions about the pre-employment requirements please contact the Department of Human Resources at or .

ELIGIBILITY FOR EMPLOYMENT:
You will be required to submit verification of your identity and citizenship or legal right to work in the United States at the time of and as a condition of an offer of employment.

As a condition of employment all prospective employees shall be required to be fingerprinted.

EQUAL EMPLOYMENT OPPORTUNITY

Madera County does not discriminate on the basis of race color religion sex gender gender identity gender expression transgender status national origin age disability (physical or mental) medical condition pregnancy genetic information ancestry marital status sexual orientation veteran or military status political affiliation or any other basis protected by Federal or State law.

Required Experience:

IC

Job Tags

Similar Jobs