Data Warehouse Programmer​/Analyst

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time ANALYST II Carson City, NV, US

Salary Range: $82,254.46 To $ Annually

The 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.
Please note:
This position is inellegible to work fully remote. The selected candidate is required to work from the Carson City or Las Vegas office.

Examples of Duties

• Business 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,…