County of San Mateo, CA
Data Analyst - Limited Term (Open)
County of San Mateo, CA, San Mateo, California, United States, 94409
Salary :
$117,457.60 - $146,806.40 Annually
Location :
County of San Mateo, CA
Job Type:
Limited Term
Job Number:
POSTING ONLY (V273E)
Department:
Health IT
Opening Date:
07/31/2024
Closing Date:
Continuous
Bargaining Unit:
35
Description
San Mateo County Health is looking for a highly skilled individual to fill the role of
Data Analyst . This position is ideal for someone with a keen interest in data analysis, documentation, and the implementation of robust data systems. As a Data Analyst, you will be pivotal in examining and interpreting vast amounts of data to drive informed decision-making within the County. Your responsibilities will cover a diverse range of tasks focused on data accuracy, quality, and utility.
You will be responsible for analyzing and documenting data sources, profiles, populations, requirements, profiling methods, test scenarios, test cases, business objectives, analytical metrics, and data collection methods. This comprehensive analysis will help ensure data integrity and support effective decision-making processes.
The
i
deal candidate
will possess:
Bachelor's degree in Data Analytics, Data Science, or Computer Science. Equivalent experience will be considered.
Minimum of 3 years of experience working with database systems in a healthcare environment. At least 1 year experience on an implementation project.
Experience with report validation and verification.
Experience optimizing reports for performance and usability.
Experience communicating with technical and non-technical staff regarding data and reports.
Excellent requirements gathering, analytical, problem-solving, and troubleshooting skills.
Ability to manage multiple priorities in a fast-paced environment and work effectively both independently and as part of a team. This is a limited term, at-will position Limited Term Employees are assigned to assignments not to exceed three years. They receive medical and dental benefits, similar to regular employees, and a defined contribution retirement plan.
Information for current County employees:
Current and regular San Mateo County Employees who are interested in this assignment must submit application materials and compete in the selection process. If you are successful in the selection process and are being considered for the assignment, HR will work directly with you and/or your department for options. Please note that there is no guarantee that you will be allowed by your department to rotate into this assignment nor are your departments obligated to allow you to take on this assignment. The salary range for this position is "as is" and non-negotiable.
Examples Of Duties
Management reserves the rights to add, modify, change, or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees can perform the functions of the job.
Analyzing and documenting:
Data sources. Data profiles. Populations. Data requirements. Data profiling methods. Test scenarios. Test cases. Business objectives. Analytical metrics. Data Collection Methods.
Performing data modeling. Maintaining and improving Measure Certification & Validation Processes. Maintaining subject matter expertise on Innovaccer products. Exploring, examining, and interpreting large volumes of data. Migrating data/workflows/pipelines. Programming in SQL and scripting languages, such as:
Groovy. JavaScript. Python (Numpy, Scipy, Scikit-Learn).
Administering Snowflake and Postgres. Comparing and contrasting data before and after system builds/code updates. Importing and exporting clinical data from other EMRs or health system data sources. Mapping clinical taxonomies such as ICD, CPT, LOINC, NDC, SNOMED, etc. Manage healthcare data transmissions (X12, HL7, CCDA).
Qualifications
Knowledge of:
Various software packages including word processing, spreadsheet, SQL database and database management, and reporting tools. Principles and practices of configuring and implementing system backup solutions. Principles and practices used in the operations, maintenance, repair, and administration of assigned systems and equipment. Basic data management theory, principles, and practices. Recent and on-going developments, current literature, and sources of information related to the operations of the assigned programs. Principles and procedures of record keeping. Customer service and telephone techniques. Modern office practices, methods, and computer equipment and applications related to the work. English usage, spelling, vocabulary, grammar, and punctuation. Techniques for providing a high level of customer service by effectively dealing with vendors and County staff. Skill/Ability to: Perform basic technical support functions for assigned responsibilities; troubleshoot problems and take appropriate action or escalate to appropriate staff as needed. Participate in design sessions or process improvement sessions and provide sound recommendations, and technical input. Identify, troubleshoot, and resolve basic database problems and perform minor repairs. Install, configure, test, upgrade, and tune databases. Create and manipulate data layers within GIS. Create and manipulate visualizations of data and load data into the Open Data and Open Government portals Use methods of ETL for data loads between disparate systems. Deal tactfully with the customers and staff in providing information, answering questions, and providing customer service. Respond to and effectively prioritize a high volume of phone calls and other requests for service. Learn and understand the organization, operation, and functions of the department as necessary to assume assigned responsibilities. Learn, interpret, and apply applicable Federal, State, and local laws, regulatory codes, ordinances, and procedures relevant to assigned area of responsibility. Organize, maintain, and update records systems. Operate modern office equipment including computer equipment and specialized software applications programs. Use English effectively to communicate in person, over the telephone, and in writing. Use tact and prudence within general policy, procedural, and legal guidelines. Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work. Additional Qualifications at the Data Analyst
Level: Knowledge of:
Specific (UNIX) procedures/commands related to Relational Database Management System (RDBMS) analysis and programming. Data management theory, principles, and practices and their application to a wide variety of services and programs. Technology, hardware and software, and current applications and practices related to data platforms such as GIS, Open Data, and Open Government. Techniques and methods of database system evaluation, implementation, and documentation. Troubleshooting, configuration, and installation techniques. The organization, operation, and functions of the department as necessary to assume assigned responsibilities and to determine appropriate point of escalation. Applicable regulatory relevant to assigned area of responsibility. Ability to:
Diagnose problems, perform remedial actions to correct problems, and/or recommend and determine solutions. Lead focus groups or working sessions to establish new processes or technical design for improvement Perform routine to complex functions in the installation, implementation, testing, and maintenance of a variety of database systems and other components. Implement a GIS program that includes effective database development, management, accessibility, and systems integration. Implement an Open Data and/or Open Government portal that includes effective data classification, management, accessibility and systems integration. Perform basic analyses of informational requirements and needs, identify problems, provide technical advice and consultation, and ensure efficient computer system utilization. Analyze data and recommend logical solutions to problems. Interpret, apply, explain, and ensure compliance with Federal, State, and local policies, procedures, laws, rules, and regulations. Establish and maintain a variety of filing, record keeping, and tracking systems. Organize own work, set priorities, and meet critical time deadlines. Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines. 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:
Education: Equivalent to graduation from an accredited four-year college or university with major coursework in management information systems, computer science, or a related field. Additional related experience may substitute for education requirement on a year-for-year basis, up to four (4) years.
IS Data Specialist II: Two (2) years of progressively responsible experience in database management, equivalent to an IS Data Specialist I at the County of San Mateo, and specific to the specialty area assigned which includes logical and physical database administration; integration; business intelligence, analytics, and report scripting; and/or data quality and integrity.
Licenses and Certifications:
Some positions may require the ability to pass a security background check. Application/Examination
If you are interested in being considered for this limited term position the following items must be submitted via e-mail:
Cover letter with responses to Supplemental Questions (maximum of 2 pages) Resume
Supplemental Questions: Describe your overall experience working as a data analyst. Be sure to discuss any experience in healthcare and database implementation projects. For each experience include your role, responsibilities, and accomplishments.
Describe any experience you have as a database architect, informaticist, data engineer, report writer.
Provide a specific example that best demonstrates your experience on an implementation and your influence on it. Include the name of the system that was implemented, your role/responsibilities, stakeholders directly impacted by the build, lessons learned, and any wins due to your involvement.
Please include the words
"Data Analyst - Limited Term"
in the subject line of email submission. All submitted materials must be in a Word or PDF format.
Please submit the above listed materials via email to:
Steph Griffin
sgriffin@smcgov.org
Application materials will be reviewed as they are received, and well-qualified candidates will be contacted for an interview.
Apply immediately. Application materials will be accepted until position is filled. This posting is open on a continuous basis and selection may be made at any time within the process.
NOTE:
Application materials are only accepted via e-mail. Materials sent via regular mail and/or fax will not be accepted. Submittals that do not include all required elements (cover letter with responses to supplemental questions and a resume) will not be considered.
About the County San Mateo County is centrally located between San Francisco, San Jose, and the East Bay. With over 750,000 residents, San Mateo is one of the largest and most diverse counties in California and serves a multitude of culturally, ethnically, and linguistically diverse communities.
The County of San Mateo, as an employer, is committed to advancing equity to ensure that all employees are welcomed in a safe and inclusive environment. The County seeks to hire, support, and retain employees who reflect our diverse community. We encourage applicants with diverse backgrounds and lived experiences to apply. Eighty percent of employees surveyed stated that they would recommend the County as a great place to work.
The County of San Mateo is an equal opportunity employer committed to fostering diversity, equity, and inclusion at all levels.
Please visit for a complete listing of all benefits for this classification.
Benefits are offered to eligible employees of the County of San Mateo. All benefits are subject to change.
NOTE: Employees hired on or after January 1, 2013 may be subject to new Pension Reform retirement laws.
As an additional benefit, the County offers extensive training and development programs designed to improve skills and enhance career opportunities. Most programs are offered on County time at no cost to you.
County employees are also covered by the federal Social Security system and earn benefits for retirement based on salary and time worked.
$117,457.60 - $146,806.40 Annually
Location :
County of San Mateo, CA
Job Type:
Limited Term
Job Number:
POSTING ONLY (V273E)
Department:
Health IT
Opening Date:
07/31/2024
Closing Date:
Continuous
Bargaining Unit:
35
Description
San Mateo County Health is looking for a highly skilled individual to fill the role of
Data Analyst . This position is ideal for someone with a keen interest in data analysis, documentation, and the implementation of robust data systems. As a Data Analyst, you will be pivotal in examining and interpreting vast amounts of data to drive informed decision-making within the County. Your responsibilities will cover a diverse range of tasks focused on data accuracy, quality, and utility.
You will be responsible for analyzing and documenting data sources, profiles, populations, requirements, profiling methods, test scenarios, test cases, business objectives, analytical metrics, and data collection methods. This comprehensive analysis will help ensure data integrity and support effective decision-making processes.
The
i
deal candidate
will possess:
Bachelor's degree in Data Analytics, Data Science, or Computer Science. Equivalent experience will be considered.
Minimum of 3 years of experience working with database systems in a healthcare environment. At least 1 year experience on an implementation project.
Experience with report validation and verification.
Experience optimizing reports for performance and usability.
Experience communicating with technical and non-technical staff regarding data and reports.
Excellent requirements gathering, analytical, problem-solving, and troubleshooting skills.
Ability to manage multiple priorities in a fast-paced environment and work effectively both independently and as part of a team. This is a limited term, at-will position Limited Term Employees are assigned to assignments not to exceed three years. They receive medical and dental benefits, similar to regular employees, and a defined contribution retirement plan.
Information for current County employees:
Current and regular San Mateo County Employees who are interested in this assignment must submit application materials and compete in the selection process. If you are successful in the selection process and are being considered for the assignment, HR will work directly with you and/or your department for options. Please note that there is no guarantee that you will be allowed by your department to rotate into this assignment nor are your departments obligated to allow you to take on this assignment. The salary range for this position is "as is" and non-negotiable.
Examples Of Duties
Management reserves the rights to add, modify, change, or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees can perform the functions of the job.
Analyzing and documenting:
Data sources. Data profiles. Populations. Data requirements. Data profiling methods. Test scenarios. Test cases. Business objectives. Analytical metrics. Data Collection Methods.
Performing data modeling. Maintaining and improving Measure Certification & Validation Processes. Maintaining subject matter expertise on Innovaccer products. Exploring, examining, and interpreting large volumes of data. Migrating data/workflows/pipelines. Programming in SQL and scripting languages, such as:
Groovy. JavaScript. Python (Numpy, Scipy, Scikit-Learn).
Administering Snowflake and Postgres. Comparing and contrasting data before and after system builds/code updates. Importing and exporting clinical data from other EMRs or health system data sources. Mapping clinical taxonomies such as ICD, CPT, LOINC, NDC, SNOMED, etc. Manage healthcare data transmissions (X12, HL7, CCDA).
Qualifications
Knowledge of:
Various software packages including word processing, spreadsheet, SQL database and database management, and reporting tools. Principles and practices of configuring and implementing system backup solutions. Principles and practices used in the operations, maintenance, repair, and administration of assigned systems and equipment. Basic data management theory, principles, and practices. Recent and on-going developments, current literature, and sources of information related to the operations of the assigned programs. Principles and procedures of record keeping. Customer service and telephone techniques. Modern office practices, methods, and computer equipment and applications related to the work. English usage, spelling, vocabulary, grammar, and punctuation. Techniques for providing a high level of customer service by effectively dealing with vendors and County staff. Skill/Ability to: Perform basic technical support functions for assigned responsibilities; troubleshoot problems and take appropriate action or escalate to appropriate staff as needed. Participate in design sessions or process improvement sessions and provide sound recommendations, and technical input. Identify, troubleshoot, and resolve basic database problems and perform minor repairs. Install, configure, test, upgrade, and tune databases. Create and manipulate data layers within GIS. Create and manipulate visualizations of data and load data into the Open Data and Open Government portals Use methods of ETL for data loads between disparate systems. Deal tactfully with the customers and staff in providing information, answering questions, and providing customer service. Respond to and effectively prioritize a high volume of phone calls and other requests for service. Learn and understand the organization, operation, and functions of the department as necessary to assume assigned responsibilities. Learn, interpret, and apply applicable Federal, State, and local laws, regulatory codes, ordinances, and procedures relevant to assigned area of responsibility. Organize, maintain, and update records systems. Operate modern office equipment including computer equipment and specialized software applications programs. Use English effectively to communicate in person, over the telephone, and in writing. Use tact and prudence within general policy, procedural, and legal guidelines. Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work. Additional Qualifications at the Data Analyst
Level: Knowledge of:
Specific (UNIX) procedures/commands related to Relational Database Management System (RDBMS) analysis and programming. Data management theory, principles, and practices and their application to a wide variety of services and programs. Technology, hardware and software, and current applications and practices related to data platforms such as GIS, Open Data, and Open Government. Techniques and methods of database system evaluation, implementation, and documentation. Troubleshooting, configuration, and installation techniques. The organization, operation, and functions of the department as necessary to assume assigned responsibilities and to determine appropriate point of escalation. Applicable regulatory relevant to assigned area of responsibility. Ability to:
Diagnose problems, perform remedial actions to correct problems, and/or recommend and determine solutions. Lead focus groups or working sessions to establish new processes or technical design for improvement Perform routine to complex functions in the installation, implementation, testing, and maintenance of a variety of database systems and other components. Implement a GIS program that includes effective database development, management, accessibility, and systems integration. Implement an Open Data and/or Open Government portal that includes effective data classification, management, accessibility and systems integration. Perform basic analyses of informational requirements and needs, identify problems, provide technical advice and consultation, and ensure efficient computer system utilization. Analyze data and recommend logical solutions to problems. Interpret, apply, explain, and ensure compliance with Federal, State, and local policies, procedures, laws, rules, and regulations. Establish and maintain a variety of filing, record keeping, and tracking systems. Organize own work, set priorities, and meet critical time deadlines. Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines. 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:
Education: Equivalent to graduation from an accredited four-year college or university with major coursework in management information systems, computer science, or a related field. Additional related experience may substitute for education requirement on a year-for-year basis, up to four (4) years.
IS Data Specialist II: Two (2) years of progressively responsible experience in database management, equivalent to an IS Data Specialist I at the County of San Mateo, and specific to the specialty area assigned which includes logical and physical database administration; integration; business intelligence, analytics, and report scripting; and/or data quality and integrity.
Licenses and Certifications:
Some positions may require the ability to pass a security background check. Application/Examination
If you are interested in being considered for this limited term position the following items must be submitted via e-mail:
Cover letter with responses to Supplemental Questions (maximum of 2 pages) Resume
Supplemental Questions: Describe your overall experience working as a data analyst. Be sure to discuss any experience in healthcare and database implementation projects. For each experience include your role, responsibilities, and accomplishments.
Describe any experience you have as a database architect, informaticist, data engineer, report writer.
Provide a specific example that best demonstrates your experience on an implementation and your influence on it. Include the name of the system that was implemented, your role/responsibilities, stakeholders directly impacted by the build, lessons learned, and any wins due to your involvement.
Please include the words
"Data Analyst - Limited Term"
in the subject line of email submission. All submitted materials must be in a Word or PDF format.
Please submit the above listed materials via email to:
Steph Griffin
sgriffin@smcgov.org
Application materials will be reviewed as they are received, and well-qualified candidates will be contacted for an interview.
Apply immediately. Application materials will be accepted until position is filled. This posting is open on a continuous basis and selection may be made at any time within the process.
NOTE:
Application materials are only accepted via e-mail. Materials sent via regular mail and/or fax will not be accepted. Submittals that do not include all required elements (cover letter with responses to supplemental questions and a resume) will not be considered.
About the County San Mateo County is centrally located between San Francisco, San Jose, and the East Bay. With over 750,000 residents, San Mateo is one of the largest and most diverse counties in California and serves a multitude of culturally, ethnically, and linguistically diverse communities.
The County of San Mateo, as an employer, is committed to advancing equity to ensure that all employees are welcomed in a safe and inclusive environment. The County seeks to hire, support, and retain employees who reflect our diverse community. We encourage applicants with diverse backgrounds and lived experiences to apply. Eighty percent of employees surveyed stated that they would recommend the County as a great place to work.
The County of San Mateo is an equal opportunity employer committed to fostering diversity, equity, and inclusion at all levels.
Please visit for a complete listing of all benefits for this classification.
Benefits are offered to eligible employees of the County of San Mateo. All benefits are subject to change.
NOTE: Employees hired on or after January 1, 2013 may be subject to new Pension Reform retirement laws.
As an additional benefit, the County offers extensive training and development programs designed to improve skills and enhance career opportunities. Most programs are offered on County time at no cost to you.
County employees are also covered by the federal Social Security system and earn benefits for retirement based on salary and time worked.