IT Data & Analytics Engineer - Office of Judicial Administration

About the Role

The IT Data & Analytics Engineer is a key technical contributor within the Kansas Judicial Branch’s Data & Analytics team. This hybrid, cross-disciplinary position supports the development, modernization, and daily operation of the Branch’s data environment, including modern data platform engineering, data modeling, SQL and database administration, dashboard and analytics enablement, and applied AI and automation initiatives. The role works closely with internal stakeholders and agency leadership to deliver high-impact data solutions that improve judicial operations statewide. This position is expected to work on site at the Kansas Judicial Center in Topeka, KS.

Responsibilities

• Data Engineering & Platform Work (Core):
  • Build, test, and maintain data ingestion pipelines using Azure Data Factory, Databricks, SQL, and Python
  • Support medallion architecture workflows (Bronze → Silver → Gold) for structured and unstructured data
  • Assist with configuration and administration of Azure Data Lake Storage, Key Vault, Azure Data Factory, Databricks, and related services
  • Maintain metadata tables, pipeline configuration, data quality rules, and automated monitoring scripts
• Database & SQL Responsibilities:
  • Support, troubleshoot, and monitor SQL Server environments related to analytic and operational workloads
  • Assist with replication-based ingestion processes from legacy case management systems
  • Monitor extraction processes, troubleshoot data integrity or latency issues, and coordinate fixes
• Analytics & Reporting Support:
  • Prepare curated datasets for dashboard developers and analysts
  • Build semantic models, business logic, and KPIs in SQL, Python, or Power BI
  • Assist with dashboard UAT, quality review, and deployment processes
• Governance & Process Support:
  • Support data quality, metadata, glossary, and classification work in collaboration with business units
  • Contribute to Service Agreements (SAs), process documentation, SOPs, and governance deliverables
• Cross-Team Collaboration:
  • Work with Infrastructure, Security, Application, PMO, and eCourt teams to ensure reliable data movement and access
  • Provide technical assistance to stakeholders, SMEs, and leadership when data issues arise
  • Help refine intake, triage, documentation, and incident response for data services
• Other Duties:
  • This position will evolve as the Branch matures its data program and adopts new technologies

Requirements

• Education: Minimum Bachelor’s degree in computer science, information systems, or related field (may be substituted with relevant professional experience)
• Experience:
  • Experience working with relational databases (SQL Server, Oracle, Postgres, etc.) and knowledge of indexing, querying, and performance tuning
  • Experience in at least two of the following categories:
    • Data & Platform Engineering: SQL, data modeling, ETL/ELT solutions, pipeline development; familiarity with cloud concepts (Azure preferred)
    • Programming / Automation: Hands-on experience with Python, PowerShell, SQL, or similar scripting languages
    • Analytics: Preparing datasets or supporting dashboards in tools like Power BI, Tableau; building KPIs, metrics, or calculations
    • Systems / Infrastructure: Understanding of identity, networking, storage, and DevOps concepts
• Soft Skills:
  • Ability to communicate with technical and non-technical staff
  • Ability to learn new tools and adapt quickly
  • Ability to work both independently and collaboratively
  • Ability to train adjacent IT team members

Qualifications

• Preferred experience with:
  • Azure Data Factory, Databricks, or cloud analytics platforms
  • Version control (Git), CI/CD (Azure DevOps), or infrastructure-as-code
  • Data governance, metadata, data quality, or cataloging
  • AI/ML tooling (MLflow, vector search, RAG frameworks)
  • Government, courts, or public-sector data environments
• Certifications in Azure data/AI (DP-203, DP-100, AI-102, AI-900, etc.) or equivalent practical experience

Pay Grade: 49 ($83,122.88 annually)

Location: Kansas Judicial Center — Topeka, KS

Work Sponsorship: Not available for this position