SQL Analyst
Core
Develop, maintain, and optimize complex SQL queries, stored procedures, and scripts to extract, transform, and validate data for statewide judicial applications and case management systems.
Role type
Senior SQL Analyst (Data Migration & Modernization)
Builds
Data quality reports, migrated datasets, and validated data structures for court case management systems.
Domain
Public Sector / Judicial Systems / Data Warehousing
Required skills
SQL, T-SQL, Relational Database Design, Query Optimization, Data Extraction, Data Transformation, Data Validation, Stored Procedures, Views, Data Migration, Legacy System Modernization
Preferred skills
SSIS, Power BI, Data Warehousing, Application Integration Troubleshooting, Data Governance, Database Security
Technologies
SQL Server, T-SQL, SSIS, Power BI, Data Warehouse
Responsibilities
Develop and optimize complex SQL queries, stored procedures, and scripts for data extraction and validation. Assist with data conversion and migration between legacy and modernized case management systems. Reconcile converted data for accuracy and completeness. Coordinate with application analysts and vendors to resolve data-related defects. Prepare data for Power BI and other reporting tools. Document queries, data structures, and troubleshooting procedures.
Seniority
Senior, hands-on IC