Apply on Employer Site

Kansas Office of Judicial Administration · 1 month ago

IT Data & Analytics Engineer - Office of Judicial Administration

Topeka, KS

Full-time

Onsite

Mid Level

$82K/yr - $82K/yr

The Kansas Office of Judicial Administration is responsible for overseeing the judicial branch's data initiatives. They are seeking a Data Systems Engineer to support the development, modernization, and daily operation of the data environment, focusing on data engineering, analytics, and AI initiatives.

ConsultingGovernmentLaw EnforcementLegal

Responsibilities

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, ADF, Databricks, and related services

Maintain metadata tables, pipeline configuration, data quality rules, and automated monitoring scripts

Support and troubleshoot SQL Server environments related to analytics workloads, including stored procedures, ETL queries, schema updates, and performance tuning when needed

Assist with replication-based ingestion processes from legacy case management systems

Monitor extraction processes, troubleshoot data integrity or latency issues, and coordinate fixes

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

Assist the IT Solution Architect in developing, training and supporting AI agents, chatbots, or retrieval workflows on Databricks (training provided)

Support vectorization tasks, document processing, or metadata preparation for AI projects

Maintain internal model registry assets and contribute to responsible AI practices

Support data quality, metadata, glossary, and classification work in collaboration with business units

Contribute to Service Agreements (SAs), process documentation, SOPs, and governance deliverables

Participate in backlog reviews, sprint planning, and DAOSC working sessions

Work with Architecture, 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 as Assigned

Qualification

Azure Data FactoryDatabricksSQLPythonPower BIETL/ELT solutionsData modelingRelational databasesData governanceAI/ML toolingSoft skills

Required

High school diploma, GED, or technical program in information technology, computer science, data analytics, or relevant field. Education may be substituted with relevant professional experience

Experience in at least two of the categories below and willingness to learn the others:

Data & Platform Engineering: Experience with SQL, data modeling, ETL/ELT solutions, or pipeline development. Familiarity with cloud concepts (Azure preferred)

Programming / Automation: Hands-on experience with one or more: Python, PowerShell, SQL, or similar scripting languages

Analytics: Experience preparing datasets or supporting dashboards in tools like Power BI, Tableau, or similar. Experience building KPIs, metrics, or calculations

Database Work: Experience with relational databases (SQL Server, Oracle, Postgres, etc.). Knowledge of indexing, querying, and performance tuning fundamentals

Systems / Infrastructure: Understanding of identity, networking, storage, or DevOps concepts helpful

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