Position numberLocation of Employment: Kansas Judicial Center, Topeka, KS 66612
Position Title and Salary: IT Data & Analytics Manager, Pay Grade 50 $85,193.95 annually
Kansas Judicial Branch BenefitsState Employment Center - Benefits (ks.gov)
Primary Responsibilities: - Serve as the technical lead of the Data & Analytics team, guiding strategy, architecture, and best practices.
- Design and specify comprehensive data architectures for databases, data warehouses, and data lake based on functional and technical requirements.
- Develop logical and physical data models to ensure data integrity, consistency, and performance.
- Build and implement strategies for data acquisition, archival, recovery, and database deployment.
- Manage and troubleshoot data migrations, conversions, and processing issues to support application and business continuity.
- Create database schemas, indexes, and views aligned with application requirements and best practices.
- Write and optimize SQL queries, stored procedures, functions, and scripts to support efficient data manipulation and reporting.
- Enforce database security controls and compliance policies to safeguard sensitive data and meet regulatory requirements
- Support and automated deployment tools for database development and release management.
- Work with DevOps team to build pipelines that support data transformation, ETL processes, and metadata management.
- Work with IT Infrastructure team to build Cloud-based infrastructure that supports the Enterprise Data Warehouse.
- Collaborate with business units and developers to understand and satisfy organizational data needs including but not limited to data sourcing, integration, classification, access and reporting.
Required Education and Experience: Education:- Bachelor's degree in Computer Science, Information Technology, or a related field. (Education requirement can be substituted with equivalent work experience).
Work Experience:- Minimum of third (3) years of experience in database engineering, including:
- Designing, implementing, and maintaining databases and / or data warehouse
- Developing data models and database architecture
- Performance tuning and optimization
- Data migration, backup, and disaster recovery strategies
- Enforcing security protocols and regulatory compliance
Technical Skills:- Expert in SQL and writing complex stored procedures, triggers, and functions
- Proficient in database systems such as MySQL, PostgreSQL, Oracle, or Microsoft SQL Server
- Skilled in data transformation and pipeline development using ETL tools and scripting languages (e.g., Python, Java, C++, Scala)
- Strong troubleshooting and problem-solving skills related to database performance and data quality
Preferred Certifications:- Oracle Certified Professional (OCP) - Database Administrator
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft Certified: Azure Data Engineer Associate
- MongoDB Certified Database Administrator
- Certified Data Management Professional (CDMP)
Applications will be accepted until: Open until filled
