Los Angeles County Health Services
What does a Senior Application Developer do?
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 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.
Requirements
REQUIREMENTS TO QUALIFY
Bachelor's degree* from an accredited college or university in Computer Science, Information Systems, or Data Science AND three (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.