Data and Analytics Engineer

Data and Analytics Engineer Job ID222399 Location Shawnee County Full/Part TimeFull-Time AgencyJudicial Branch Job Posting ! Important Notice to those applying for this job ! To apply for this job, please see the Job Application Process section below. This job posting does not use this site's online application. The '' button will not work. Position number: K0076172 Position Title and Salary: IT Data & Analytics Engineer, Pay Grade – 49 ($83,122.88 annually) Location of Employment: Kansas Judicial Center — Topeka, KS 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. Key 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 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. This position is NOT available for work sponsorship. Applications Accepted Until Filled The Americans with Disabilities Act ensures your right to reasonable accommodations during the employment process. A request for accommodation will not affect your opportunities for employment with the Judicial Branch. If you wish to request an ADA accommodation, please contact ada@kscourts.gov or by TDD through the Kansas Relay Center at 800-766-3777 or 711. THE KANSAS JUDICIAL BRANCH IS AN EEO / AA EMPLOYER