Senior Application Developer (Data & Analytics)
Role details
Job location
Tech stack
Job description
Under direction, performs a wide range of application development related duties including analysis, design, evaluation, development, coding, testing and maintenance of complex application systems in a healthcare data and analytics unit.
Check Out Our Outstanding Benefits! CLICK HERE (https://hr.lacounty.gov/benefits/) to see a list of employee benefits!
Essential Job Functions
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., *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 attbuggs@dhs.lacounty.govwithin 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., 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., 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., 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 tbuggs@dhs.lacounty.gov 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.
Requirements
Bachelor's degree* from an accredited college or university in Computer Science, Information Systems, or Data ScienceAND(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., 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., 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?, 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?, 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?, 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?