> Markdown version of [/jobs/ext/3797057-data-warehouse-programmer-analyst](https://www.wearedevelopers.com/jobs/ext/3797057-data-warehouse-programmer-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Programmer/Analyst - **Company:** State of Nevada - **Location:** Carson City, NV, United States (Remote available) - **Salary:** $82,254.0 - $104,881.0 - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Software Documentation, Software Code Optimization, Code Review, Databases, System Configuration, Data as a Services, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Security, Data Structures, Data Warehousing, Relational Databases, Database Development, Database Queries, Database Storage Structures, Database Theory, Microsoft SQL Server, Release Management, Secure Coding, Software Engineering, Software Requirements Analysis, SQL Stored Procedures, SQL Databases, Systems Integration, Data Logging, Data Processing, Scripting, Codebase, Software Version Control - **Published:** October 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1354c45425061265 ## About the Role * Professional 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. ## Description 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 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, 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.