Experience Inc. Jobs

Job Information

San Mateo County, CA Lead Data Analyst - Limited Term (Open) in United States

Lead Data Analyst - Limited Term (Open)

Print (https://www.governmentjobs.com/careers/sanmateo/jobs/newprint/4584901)



Lead Data Analyst - Limited Term (Open)

Salary

$126,193.60 - $157,726.40 Annually

Location

County of San Mateo, CA

Job Type

Limited Term

Job Number

POSTING ONLY (V274F)

Department

Health IT

Opening Date

07/31/2024

Closing Date

Continuous

  • Description

  • Benefits

Description

San Mateo County Health is seeking a highly skilled and motivated individual for the position of Lead Data Analyst - Limited Term to join our innovative team. This position is ideal for someone who excels in both leadership and technical expertise and is passionate about optimizing data processes and driving technological advancements. The Lead Data Analyst role encompasses planning, designing, implementing, and maintaining the Health Data Platform. Additionally, you will guide and mentor co-workers in data migration processes, technical refinement of code, technical processes, and process improvement, while identifying potential use cases for automation.

The i deal candidate will possess:

  • Bachelor’s degree in Data Analytics, Data Science, or Computer Science. Equivalent experience will be considered.

  • Minimum of 5 years of experience working with database systems in a healthcare environment. At least 2 years Lead Data Analyst experience on an implementation project.

  • Experience with report validation and verification.

  • Experience optimizing reports for performance and usability.

  • Strong requirements gathering skill set and ability to recognize when requests are connected to larger efforts.

  • Excellent analytical, problem-solving, and troubleshooting skills.

  • Ability to present multiple solutions, and their trade-offs to teammates and customers.

  • Ability to manage multiple priorities in a fast-paced environment and work effectively both independently and as part of a team.

  • Experience mentoring less experienced teammates.

  • Experience communicating with executive, clinical, technical, and non-technical staff regarding data and reports.

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.

Technical Lead Duties

  • Designing, developing, and documenting:

  • Best practices

  • Data migration processes

  • Technical specifications

  • Monitoring and providing feedback on:

  • Data Migration Processes

  • ETL Process Efficiency

  • Deliverables

  • Dependencies

  • Cross-functional Team interactions

  • Guiding and mentoring co-workers in:

  • Data migration processes

  • Technical refinement of code

  • Technical processes

  • Process improvement

  • Identifying potential use cases for automation

  • Driving recurring technical meetings and maintaining technical status reporting

Data Specialist Duties

  • 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 procedures/commands related to Relational Database Management System (RDBMS) design, analysis, and programming.

  • Advanced data management theory, principles, and practices and their application to a wide variety of services and programs.

  • Various software packages including word processing, spreadsheet, SQL database and database management, and reporting tools.

  • Advanced principles and practices of designing, configuring, and implementing system backup solutions.

  • Principles and practices used in the operations, maintenance, repair, and administration of assigned systems and equipment.

  • Technology, hardware and software, and current applications related to GIS.

  • Technology, hardware and software, current applications and methods related to Open Data and/or Open Government.

  • ETL processes for data loads between disparate systems.

  • 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.

  • Principles and procedures of record keeping.

  • 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 complex technical support functions for assigned responsibilities; troubleshoot problems and take appropriate action or escalate to appropriate staff as needed.

  • Diagnose complex problems, perform remedial actions to correct problems, and/or recommend and determine solutions.

  • Oversee and perform complex functions in the installation, implementation, testing, and maintenance of a variety of database systems and other components.

  • Perform advanced 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.

  • Deal tactfully with the customers and staff in providing information, answering questions, and providing customer service.

  • Establish and maintain a variety of filing, record keeping, and tracking 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.

  • Organize and prioritize a variety of projects and multiple tasks in an effective and timely manner; organize own work, set priorities, and meet critical time deadlines.

  • Use tact, initiative, prudence, and independent judgment within general policy, procedural, and legal guidelines.

  • Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.

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 graduation from an accredited four-year college or university with major coursework in management information systems, computer science, or a related field and four (4) years of progressively responsible experience in database management 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. Additional related experience may substitute for education requirement on a year-for-year basis, up to four (4) years.

Licenses and Certifications:

  • Some positions may require possession of, or ability to obtain, a valid California Driver's License.

  • Some positions may require possession of information technology industry recognized certifications.

  • Some positions may require ability to pass 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 experience as a Data Analyst AND Lead/Supervisor of a PaaS database implementation, including your responsibilities, the clinical systems you worked with, and length of time in a Data Analyst role and in a Lead/Supervisor capacity.

  • Describe any experience you have as a database architect, informaticist, data engineer, report writer. Be sure to discuss any experience in healthcare projects.

  • Describe your approach to managing a team within a IT setting. Include the methods and processes you employ to have analysts meet performance goals, the number of staff members on your teams, and an example of managing projects and people in a fast-paced environment with strict deadlines.

    Please include the words "Lead 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.

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 is committed to advancing equity in order 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 https://www.smcgov.org/media/100206/download?inline= 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.

Agency

County of San Mateo

Address

County of San Mateo Human Resources Department 500 County Center, 4th Floor Redwood City, California, 94063-1663

Phone

(650) 363-4343

Website

https://jobs.smcgov.org

Please verify your email address Verify Email

DirectEmployers