Data Warehouse Programmer/Analyst

Data Warehouse Programmer/AnalystThe Supreme Court of Nevada, Administrative Office of the Courts (AOC), is seeking a Data Warehouse Programmer/Analyst to support and expand the Nevada Courts Data Warehouse. The Data Warehouse Programmer/Analyst plays a crucial role in Nevada Courts Data Warehouse in developing, maintaining, testing, and supporting the programming and data transformations that move court data into reliable statewide reporting structures. The incumbent applies advanced programming and database skills to develop complex queries, stored procedures, data transformations, and automated processes. This position works closely with stakeholders to understand business requirements, implement approved business rules, resolve data and programming issues, and expand the Data Warehouse and related data services to support current and future AOC initiatives.This position may require travel to various court locations throughout Nevada and occasional travel outside of Nevada. Occasional overtime and work on holidays, nights, and/or weekends may be required.This position can be located in Carson City or Las Vegas. After an initial training period, there may be an opportunity for a hybrid remote/in-office schedule.Examples of DutiesBusiness Analysis and Solutions Design: Work closely with business stakeholders to gather and document requirements, understand business processes, and identify opportunities for improvement. Create detailed technical designs and implement solutions that align with business requirements and architectural standards.Translate business needs into technical specifications and actionable plans.Support integration of new court systems, data sources, and AOC applications into the Data Warehouse and related reporting environment.Support future AOC initiatives that depend on consistent data collection, transformation, integration, and reporting.Participate in requirements analysis, technical design, coding, testing, deployment, and post-implementation support for Data Warehouse enhancements.Develop and execute test plans to validate solutions.Work with other units of the AOC to ensure transformations reflect approved business rules and produce reliable reporting data and/or metrics.Database Development: Develop, maintain, and support Data Warehouse code, scripts, queries, procedures, jobs, and data-transformation processes.Build and maintain extract, transform, and load processes that collect, standardize, validate, and load court data from approved source systems.Develop and maintain SQL queries, stored procedures, views, functions, and other code used for data integration, validation, reporting, and analysis.Optimize code and data-processing workflows for performance, scalability, maintainability, and efficient use of resources.Technical Support and Documentation: Provide support for production databases and applications, troubleshoot issues, and implement solutions in a timely manner. Monitor and enhance system performance. Develop and maintain comprehensive documentation for database structures, processes, and system configurations. Ensure documentation is up-to-date and accessible.Troubleshoot failed or incomplete data loads, transformation errors, mapping issues, performance problems, and other programming defects.Maintain source-to-target mappings, transformation specifications, code documentation, dependencies, version history, and operational runbooks.Assist with user acceptance testing and validation of data transformations, reports, and interfaces before production release.Collaboration: Work with cross-functional teams, including end users, developers, data analysts, and project managers, to ensure successful project delivery and integration. Participate in code reviews and knowledge sharing.Security: Apply secure coding, change-management, source-control, and release-management practices established by the AOC.Protect confidential, restricted, and sensitive court information and comply with applicable judiciary policies governing data access and use.Follow department policies and procedures.Perform other duties as assigned.QualificationsProfessional programming or data-engineering experience involving relational databases, structured data, integrations, or enterprise reporting environments.Strong SQL skills and experience developing queries, stored procedures, scripts, or comparable database programming components.Experience developing or maintaining ETL/ELT processes, data transformations, interfaces, or automated data workflows.Knowledge of data structures, database concepts, testing, error handling, logging, source control, and software development practices.Ability to analyze technical problems, trace data through multiple processing steps, and develop maintainable solutions.Skilled at delivering precise, high-quality documentation for system requirements, codebases, data mappings, test results, and technical dependencies.Strong communication skills, with the ability to convey technical concepts to non-technical stakeholders.Experience with Microsoft SQL Server, integration services, scripting languages, or the technologies used by the AOC Data Warehouse (AWS services including Redshift and Glue) is preferred.If this position is approved for remote/hybrid work, the incumbent is required to work a minimum of 40 hours in the office per pay period, in accordance with a supervisor-approved schedule. The remaining work hours are eligible to be performed remotely in accordance with operational needs and applicable remote-work policies. The incumbent must be able to work effectively and collaborate with employees while working remotely. The individual must be proficient in virtual meeting platforms such as Microsoft Teams and be able to perform all duties through a reliable internet connection provided by the employee. The internet connection must be sufficient to support all job functions, with a minimum download speed of 50–100 Mbps. Higher speeds may be necessary if the connection is shared with other members of the household.Additional Benefits include:Health Insurance: medical, dental, prescription, vision, life and disability insurance programs for employees and dependents/family are offered through the Public Employees' Benefits Program (PEBP).Vacation: accrual of three weeks of annual leave each year.Sick Leave: accrual of three weeks of sick leave each year.Holidays: 12 paid holidays per year.Retirement: participation in the Nevada Public Employees' Retirement System (PERS).Deferred Compensation: The State has a voluntary deferred compensation program.No Nevada state income tax.Positions are eligible for Public Service Loan Forgiveness.Flexibility: a work-life balance beyond compare!Applicants should submit a cover letter and resume.This recruitment is scheduled to close at 11:59 p.m. on October 29, 2026. Based on the number of applications received, the recruitment may close early. Qualified applicants are encouraged to apply as soon as possible.