SENIOR APPLICATION DEVELOPER (DATA & ANALYTICS)

About the Department

Check Out Our Outstanding Benefits! CLICK HERE to see a list of employee benefits!

Position Duties

Writes, troubleshoots, and optimizes complex Transact and PL SQL (Procedural Language/Structured Query Language) codes to ensure that implementation of pay-for-performance program measures and sub-measures are aligned with the annual expansions and changes required by the state.

Investigates and fixes data anomalies through root cause analysis in pay-for-performance program measure implementations through root cause analysis using a variety of analytics tools and methods such as merging records from various tables, comparing results using Excel, Tableau and other ETL processors (Extract, Transform, Load).

Builds complex data models for business intelligence solutions consumption and creates dashboards and reports using data visualization tools such as Tableau and Business Objects using those models.

Applies transformations, data cleansing, normalization best practices, as well as abstraction and inheritance programming concepts to ensure quality data solutions.

Responsible for eliciting and documenting user requirements for large, highly complex new systems or system enhancements; ensures functional and technical requirements are fully documented. Translates technical tasks to a non-technical audience.

Minimum Qualifications

REQUIREMENTS TO QUALIFY

Bachelor's degree* from an accredited college or university in Computer Science, Information Systems, or Data Science AND (3) years of enterprise-level**, full-time, paid experience, obtained within the last three (3) years, in a data and analytics unit, designing, developing, troubleshooting, and optimizing complex Transact-SQL and PL/SQL (Procedural Language/Structured Query Language) code, including stored procedures, queries, and database performance tuning.

The required experience must also include the following technologies and practices:

• Investigating and resolving data anomalies using root cause analysis and tools such as Excel, Tableau, and ETL platforms 
• Building advanced data models and delivering actionable business intelligence through dashboards and reports with Tableau and Business Objects
• Applying data transformation and quality best practices and documenting detailed user requirements for complex data products while effectively communicating technical concepts to non-technical stakeholders.

**Enterprise-level refers to data projects (involving solutions, strategies, or systems) designed to meet the complex needs of large organizations, often focusing on scalability and integration across multiple departments.

PHYSICAL CLASS 2– Light: This class includes administrative and clerical positions requiring light physical effort that may include occasional light lifting to a 10-pound limit and some bending, stooping, or squatting. Considerable ambulation may be involved.

LICENSE: A valid California Class C Driver License or the ability to use an alternative method of transportation when needed to carry out job-related essential functions.

No Out of Class experience or withholds are allowed for this examination. Required experience must be fully met at the time of filing and clearly indicated on the application.

SPECIAL REQUIREMENT INFORMATION: 
*To receive credit for your education, include a legible copy of your official diploma, official transcript, or letter/certificate from an accredited institution with your application. The document should show the date the degree was conferred and be in English. If not in English, then translation is required. International degrees must be evaluated for equivalency to U.S. standards if not listed in the International Handbook of Universities or World Higher Education Database. If you are unable to attach required/supporting documents at the time of filing, you must email the documents to Tanisha Buggs at [email protected] within seven (7) calendar days of filing your online application or you will not receive credit. Please include your name (as it appears on your online application), the examination title and number in the subject of your email. 

For more information on our standards for educational documents, please visit: https://file.lacounty.gov/SDSInter/dhr/070812_PPG123.pdf

We do not accept password-protected documents. Ensure documents are unlocked before attaching to your application or sending to the exam analyst.

DESIRABLE QUALIFICATIONS:
Additional credit will be given to applicants that possess the following desirable qualifications:

One (1) year of experience performing one or more of the following:

• Working with cloud-based data platforms such as Microsoft Azure, Amazon Web Services (AWS), or Google Cloud Platform to build data pipelines, manage cloud data warehouses, or implement ETL processes.

• Analyzing pay-for-performance (P4P) program measures in a healthcare environment (e.g., Healthcare Effectiveness Data and Information Set (HEDIS), Quality Incentive Pool (QIP), Centers for Medicare & Medicaid Services (CMS) Five-Star Quality Rating System), including evaluating healthcare quality metrics, validating measure calculations, and supporting reporting requirements.

• Applying Agile project management methodology and use of JIRA to track project progress, manage workflows, and coordinate tasks across cross-functional teams.  

• Experience using health data exchange formats such as Electronic Data Interchange (EDI) or Fast Healthcare Interoperability Resources (FHIR) for data integration, exchange, or interoperability.

• Applying standardized medical coding systems, including Current Procedural Terminology, Fourth Edition (CPT-4), International Classification of Diseases, Tenth Revision (ICD-10), and Systematized Nomenclature of Medicine – Clinical Terms (SNOMED CT) to support clinical documentation, billing processes, and healthcare data reporting.

Other Qualifications

EXAMINATION CONTENT

This examination will consist of an Evaluation of Training & Experience (T&E): This assessment type will evaluate the training and experience you list on the online application and supplemental questionnaire and assign a score based on a standardized scoring system. This part of the assessment is worth 100% of your total score and assesses: Requirements, Desirable Qualifications, and Supplemental Questionnaire.

Applicants must receive a passing score of 70% or higher on the assessment to be added to the list.

ELIGIBILITY AND VACANCY INFORMATION

Applications will be processed as they are received and added to the list accordingly.

Applicants who passed the assessment(s) are placed on a list for a period of twelve (12) months. We will use this list to fill vacancies in the Department of Health Services as they occur.

SPECIAL INFORMATION
Appointees may be required to work any shift, including evenings, nights, weekends, and holidays.

APPLICATION AND FILING INFORMATION
We only accept applications filed online. Applications submitted by U.S. mail, fax, or in person are not accepted. Apply online by clicking on the green "Apply" button at the top right of this posting. This website can also be used to get application status updates. 

Please fill out the application completely. Provide relevant job experience including employer's name and address, job title, beginning and ending dates, number of hours worked per week, and description of work performed.  

We may verify information included in the application at any point during the examination and hiring process, including after an appointment has been made. Falsification of information could result in refusal of application or rescission of appointment. Copying verbiage from the Requirements or class specification as your work experience will not be sufficient to demonstrate meeting the requirements. Doing so may result in an incomplete application and may lead to disqualification. Comments such as “See Resume” or referencing other unsolicited materials/documents will not be considered a response.

SOCIAL SECURITY NUMBER
Federal law requires that all employed persons have a Social Security Number, so include yours when applying.

COMPUTER AND INTERNET ACCESS AT PUBLIC LIBRARIES
For candidates who may not have regular access to a computer or the internet, applications can be completed on computers at public libraries throughout Los Angeles County. Please refer to their website for updated information https://lacountylibrary.org/library-locator.

NO SHARING OF USER ID, E-MAIL, AND PASSWORD
All applicants must file their application using their own user ID and password. Using a family member's or friend's user ID and password may erase a candidate's original application record.

ANTI-RACISM, DIVERSITY, AND INCLUSION (ARDI)
The County of Los Angeles recognizes and affirms that all people are created equal and are entitled to all rights afforded by the Constitution of the United States. We are committed to promoting Anti-racism, Diversity, and Inclusion efforts to address the inequalities and disparities amongst race. We support the ARDI Strategic Plan and its goals by improving equality, diversity, and inclusion in recruitment, selection, and employment practices.

DEPARTMENT CONTACT:
Tanisha Buggs, Exam Analyst
(213) 288-7000
[email protected]

CALIFORNIA RELAY SERVICES PHONE:
(800) 735-2922 

Benefits

For detailed information, please click here

Supplemental Questions

01

We will send notifications to the email address provided on the application, so it is important that you provide a valid email address. If you choose to unsubscribe or opt out from receiving our emails, it is possible to view notices by logging into governmentjobs.com and checking the profile inbox. It is every applicant's responsibility to take steps to view correspondence, and we will not consider claims of missing notices to be a valid reason for an extension of appeals rights period. Register the below domains as approved senders to prevent email notifications from being filtered as spam/junk mail.

• [email protected]
• [email protected]
• [email protected]

New email addresses need to be verified. This only needs to be done once per email address and can be done at any time by logging in to governmentjobs.com and following the prompts. This is to enhance the security of the online application and to prevent incorrectly entered email addresses.

• I understand the above information.

02

The information you provide on this supplemental questionnaire will be evaluated and used to determine your eligibility to participate in the next phase of the examination process.

CHECK YOUR ANSWERS CAREFULLY.

Any mistakes you make and/or any incomplete responses you provide in completing these questions will be used to disqualify your application even if you possess the qualifying experience or education. Please read each question carefully and be as specific as possible when answering by including all the information requested; please do not COPY AND PASTE all your Duties as stated in the application under the Work Experience section, from your resume, and/or from the Class Specifications. In doing so, your application will be rejected as INCOMPLETE. It is the applicant's sole responsibility to complete this questionnaire completely, correctly, and accurately. The experience you claim in this Supplemental Questionnaire MUST be consistent with the experience listed in your application.

All information is subject to verification at any time in the examination and hiring process. Falsification of any information may result in disqualification or dismissal.

• I understand the above information and instructions.

03

VETERAN'S CREDIT

Are you a veteran? If you are a veteran, you may be eligible for veteran’s credit, which is an additional 10% of the total points added to a passing score. We will need a copy of your form DD214 to review, so please include that with your application or email it to the exam analyst at [email protected] as soon as possible to ensure smooth processing. Please include your name (as it appears on your online application), the examination title and number in the subject of your email.

• Yes
• No

04

Do you possess a Bachelor's degree or higher from an accredited college or university?

To receive credit for your education, include a legible copy of your official diploma, official transcript, or letter/certificate from an accredited institution with your application. The document should show the date the degree was conferred and be in English. If not in English, then translation is required. International degrees must be evaluated for equivalency to U.S. standards if not listed in the International Handbook of Universities or World Higher Education Database. If you are unable to attach required/supporting documents at the time of filing, you must email the documents to Tanisha Buggs at [email protected] within seven (7) calendar days of filing your online application or you will not receive credit. Please include your name (as it appears on your online application), the examination title and number in the subject of your email.

For more information on our standards for educational documents, please visit: https://file.lacounty.gov/SDSInter/dhr/070812_PPG123.pdf

We do not accept password-protected documents. Ensure documents are unlocked before attaching to your application or sending to the exam analyst.

• Yes, and in order for me to receive credit, I have attached proof of my Bachelor's degree to my online application.
• Yes, and in order for me to receive credit, I will email proof of my Bachelor's degree to [email protected] within seven (7) calendar days.
• No, I do not have a Bachelor's degree.

05

If you indicated YES to possessing a Bachelor's degree or higher from an accredited college or university, please select the area of specialization in which the degree was awarded.

• Computer Science
• Information Systems
• Data Science
• Other
• No Degree

06

Do you possess enterprise-level** experience, obtained within the last three (3) years, in a data and analytics unit designing, developing, troubleshooting, and optimizing complex Transact-SQL (T-SQL) and PL/SQL (Procedural Language/Structured Query Language) code, including stored procedures, queries, and database performance tuning?

**Enterprise-level refers to data projects (involving solutions, strategies, or systems) designed to meet the complex needs of large organizations, often focusing on scalability and integration across multiple departments.

• Yes, I possess enterprise-level experience in a data and analytics unit designing, developing, troubleshooting, and optimizing complex Transact-SQL (T-SQL) and PL/SQL (Procedural Language/Structured Query Language) code, including stored procedures, queries, and database performance tuning.
• No, I do have such experience.

07

Describe your experience that supports your response to the previous question. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

08

Do you possess experience with the following technologies and practices:

NOTE: To qualify, applicants must possess experience with all of the functional areas described below. The software programs and tools referenced are examples of the types of technologies that may have been used to perform the work.

- Investigating and resolving data anomalies using root cause analysis and tools such as Excel, Tableau, and ETL platforms.
- Building advanced data models and delivering actionable business intelligence through dashboards and reports with Tableau and Business Objects.
- Applying data transformation and quality best practices and documenting detailed user requirements for complex data products while effectively communicating technical concepts to non-technical stakeholders.

• Yes, I possess experience with all of the technologies and practices mentioned.
• No, I do not have such experience.

09

If you answered YES to question #8, describe your experience investigating and resolving data anomalies using root cause analysis and tools such as Excel, Tableau, and ETL platforms. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

10

If you answered YES to question #8, describe your experience building advanced data models and delivering actionable business intelligence through dashboards and reports with Tableau and Business Objects. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

11

If you answered YES to question #8, describe your experience applying data transformation and quality best practices and documenting detailed user requirements for complex data products while effectively communicating technical concepts to non-technical stakeholders. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

12

Do you possess experience working with cloud-based data platforms such as Microsoft Azure, Amazon Web Services (AWS), or Google Cloud Platform to build data pipelines, manage cloud data warehouses, or implement ETL processes?

• Yes
• No

13

Describe your experience that supports your response to the previous question. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

14

Do you possess experience analyzing pay-for-performance (P4P) program measures in a healthcare environment (e.g., Healthcare Effectiveness Data and Information Set (HEDIS), Quality Incentive Pool (QIP), Centers for Medicare & Medicaid Services (CMS) Five-Star Quality Rating System), including evaluating healthcare quality metrics, validating measure calculations, and supporting reporting requirements?

• Yes
• No

15

Describe your experience that supports your response to the previous question. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

16

Do you possess experience applying Agile project management methodology and use of JIRA to track project progress, manage workflows, and coordinate tasks across cross-functional teams?

• Yes
• No

17

Describe your experience that supports your response to the previous question. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

18

Do you possess experience using health data exchange formats such as Electronic Data Interchange (EDI) or Fast Healthcare Interoperability Resources (FHIR) for data integration, exchange, or interoperability?

• Yes
• No

19

Describe your experience that supports your response to the previous question. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

20

Do you possess experience applying standardized medical coding systems, including Current Procedural Terminology, Fourth Edition (CPT-4), International Classification of Diseases, Tenth Revision (ICD-10), and Systematized Nomenclature of Medicine – Clinical Terms (SNOMED CT) to support clinical documentation, billing processes, and healthcare data reporting?

• Yes
• No

21

Describe your experience that supports your response to the previous question. For each experience, please provide the following information:

1) Name of Employer:
2 Job/Position Title:
3) Employment Date From (mm/dd/yy) - Date To (mm/dd/yy):
4) Hours Worked per Week:
5) Detailed Description of your relevant experience.


REPEAT FORMAT OF 1-5 for each employment where you gained relevant experience. IF NOT APPLICABLE, ENTER N/A.

Required Question

Agency Information

Employer

County of Los Angeles

Address

******************








Los Angeles, California, 90010

Website

http://hr.lacounty.gov