IT Data & Analytics Engineer - Office of Judicial Administration

Overview The IT Data & Analytics Engineer is a key technical contributor within the Kansas Judicial Branch’s Data & Analytics team. This role supports the development, modernization, and daily operation of the Branch’s data environment, including:

• Modern data platform engineering (Azure, Databricks, ADLS, Azure Data Factory)
• Data modeling and ingestion pipelines
• SQL and database administration (light-to-moderate)
• Dashboard and analytics enablement
• Operational support for data processes across the Branch
• Applied AI and automation initiatives

This is a hybrid, cross-disciplinary position-ideal for someone who enjoys learning new technologies, solving complex data problems, and working across infrastructure, application development, security, and business units. The role supports both technical delivery and data governance foundation efforts and will work 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., 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 as Assigned This position will evolve as the Branch matures its data program and adopts new technologies.

Required Education Minimum: Bachelor’s degree in computer science, information systems, or related field. Education may be substituted with relevant professional experience. Required Experience Candidates should have experience working with relational databases (SQL Server, Oracle, Postgres, etc.) and knowledge of indexing, querying, and performance tuning. Candidates should also have 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, and pipeline development.
• Familiarity with cloud concepts (Azure preferred).

Programming / Automation

• Hands-on experience in production environments with one or more of the following: 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.

Systems / Infrastructure

• Understanding of identity, networking, storage, and DevOps concepts.

Required 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.

Preferred Qualifications

• Experience with Azure Data Factory, Databricks, or cloud analytics platforms.
• Experience with version control (Git), CI/CD (Azure DevOps), or infrastructure-as-code.
• Experience with data governance, metadata, data quality, or cataloging.
• Experience with AI/ML tooling (MLflow, vector search, RAG frameworks).
• Experience in 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.