Data Engineer

The Wisconsin Court System has an exciting opportunity for a skilled and experienced full-time Data Engineer. Under the supervision of the Manager of Court Data and Analytics the Data Engineer will focus on building and maintaining the Circuit Court Data Warehouse using advanced extraction, transformation, and loading (ETL) software, as well as providing (e.g. business intelligence tools) tools to allow analysts and policy-makers reliable access to circuit court data and information. This position may also be involved in the preparation and development of high-level analyses including machine learning. The incumbent will serve as a subject matter expert as it relates to the Circuit Court Data Warehouse., LOCATION: Madison, WI. Certain positions with this Department may allow remote work for a portion of their work schedule, depending on the needs of the position and the work unit. This topic may be discussed in the interview process. The position is headquartered in Wisconsin and selected candidates may be expected to report to office locations in Wisconsin on short notice. Employees residing outside the state of Wisconsin are not eligible for full-time remote work., 1) Design, develop, optimize, test and document data models, ETL solutions, stored procedures, and perform data warehousing tasks including: Developing, constructing, testing, and maintaining architectures for large-scale data management and analysis; test all work product to ensure accuracy; document data warehouse ecosystem and processes; monitor and recommend enhancements to the Circuit Court Data Warehouse ecosystem as needed in order to update data warehouse scope and capabilities; and administer and manage ETL applications using relevant tools and techniques. 2) Create and maintain data visualizations, reports, dashboards, analyses, and business intelligence solutions. This may include the analysis of data using statistical techniques like regression and other machine learning algorithms using software like Python or R. 3) Complete ad hoc data requests and analytical assistance to judicial policymakers and court officials to support court system decision making.

Required: 1) Bachelor's Degree in Computer Science, Information Technology, or a related field, or equivalent experience. 2) At least three years of data engineering experience. 3) Excellent knowledge of data modeling and data warehousing. 4) Excellent knowledge of database security and administration. 5) Skill in communicating technical information effectively to non-technical users of data warehouse. 6) Skill in managing and manipulating data using advanced SQL queries. 7) Ability to maintain accurate records and documentation with a strong attention to detail. 8) Ability to work independently on projects assigned by supervisor. 9) Experience creating data visualizations, reports, dashboards, and other analytical solutions using Tableau, pivot tables, or other data visualization tools. 10) Experience managing and transforming large data sets with programming languages such as Python or PL/SQL. 11) Experience with database management, including automated report generation and job scheduling tools. 12) Experience in Data Warehouse ETL platforms using ETL tools and solutions.

SALARY: $82,134 to $102,600 annually with a State of Wisconsin benefits package. Salary will be determined based on the selected candidate's qualifications and experience.