{"success":true,"message":"","validationErrors":[],"value":{"jobInfo":{"jobId":5990972,"jobTitle":"Assistant Director of AID - Business IT (2027-28)","infoURL":"https://columbia.tedk12.com/hire/ViewJob.aspx?JobID=11652","externalJobCode":"11652","applicationDeadline":"2026-12-11T23:00:00","displayDate":"2026-11-12T06:00:00","internalDisplayDate":"2026-11-12T06:00:00","postDate":"2026-11-12T19:47:16","startDateShowDay":1,"startDate":null,"jobStatusID":30,"unionID":0,"unionName":null,"jobDescription":"<p><span style=\"color: #ff0000; font-size: 12pt;\"><strong>(Using a computer is suggested to complete application. Phones are not always compatible.)</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>POSITION PROPERTIES</strong></span></p>\r\n<p>&nbsp;</p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Position Title: </strong>Assistant Director of AID - Business IT</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Schedule / Grade: </strong>Salaried Support / 7</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Job Code: </strong>94ASTDR542</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>FLSA: </strong>Exempt</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Calendar: </strong>ADSUP-S</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Benefits: </strong>Eligible (Retirees not Eligible)</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Contract Type: </strong>ADMIN</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Bargaining Unit: </strong>None</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Revised Date:&nbsp;</strong>11/12/2026</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>&nbsp;</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>&nbsp;</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>PURPOSE</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\">The Assistant Director of Assessment, Intervention, and Data (AID) &ndash; Business IT is responsible for oversight of all business-related software systems in the systems in the district. This includes, but is not limited to, the main financial, human resources, payroll and benefit systems as well as any other software systems that exchange data or interact with the business systems. This position is also the lead position for any state and federal reporting requirements for the business systems.</span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>ESSENTIAL RESPONSIBILITIES AND DUTIES</strong>&nbsp;</span></p>\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\">Supervision of the AID business team members</span></li>\r\n<li><span style=\"font-size: 12pt;\">State and federal reporting and compliance, including MOSIS, EEOC, retirement systems, audits, W2 and payroll reporting for fiscal and calendar year end, ACA compliance, OCR reporting</span></li>\r\n<li><span style=\"font-size: 12pt;\">Creation of reports and scripts to support the business, payroll, human resources and benefits offices.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Data exchange between the business systems and any third-party software systems, including the BenefitFocus system, UKG, Frontline (substitute system), Talented, Parentlink, Salesforce, and various bank and retirement files for benefits and payroll</span></li>\r\n<li><span style=\"font-size: 12pt;\">Creation and maintenance of workflow processes to support the business systems</span></li>\r\n<li><span style=\"font-size: 12pt;\">Open record requests related to school district business and human resources systems</span></li>\r\n<li><span style=\"font-size: 12pt;\">Coordination of release loads and updates, including testing</span></li>\r\n<li><span style=\"font-size: 12pt;\">Special requests from administration for board meetings and budget documents</span></li>\r\n<li><span style=\"font-size: 12pt;\">End user support for the power users in the Business, Human Resources, Benefits and Payroll offices</span></li>\r\n<li><span style=\"font-size: 12pt;\">End user support for the district building users for the business software</span></li>\r\n<li><span style=\"font-size: 12pt;\">Configuration and support for the Employee Online system</span></li>\r\n</ul>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;Perform other duties as necessary to support the mission and vision of Columbia Public School District.</span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>DISTRICT EXPECTATIONS</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\">All employees of the District are expected to adhere to the policies and regulations of the Board of Education, maintain appropriate certification and competencies necessary for the position, and demonstrate the values of the district at all times. For information on polices, regulations and values, visit&nbsp;http://www.cpsk12.org</span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>REPORTING RELATIONSHIPS</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Reports To:&nbsp;&nbsp;&nbsp;&nbsp; </strong>Executive Director of Assessment, Intervention, Data, and Innovation</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Supervises:&nbsp;&nbsp;&nbsp;&nbsp; </strong>Programmer/Analyst II for Business IT Systems</span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>QUALIFICATIONS</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Minimum:</strong> Bachelor&rsquo;s degree and 3 years of experience demonstrating complex data analysis responsibilities around business and HR operations.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>&nbsp;</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Preferred:</strong> Successful candidate will have organizational, analysis, and troubleshooting skills; strong writing and documentation skills; experience with MS Office Suites, Business Plus, Tableau, SQL, and Python programming; and experience with needs assessments and report creation to meet end-user and administrative requirements. Experience in project management.</span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Ideal Candidate:</strong>&nbsp;The ideal candidate is an analytical, highly organized, and detail-oriented technical professional who excels at translating complex data into actionable administrative insights. Possessing a strong balance of technical fluency and effective communication skills, this individual acts as a bridge between end-users, operational teams, and executive leadership to optimize organizational processes and reporting.</span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><em>To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills and abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.</em></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>ADA REQUIREMENTS</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Language: </strong>Present information to teachers, staff, other administrators, and boards. Respond to common questions and concerns. Read, analyze, and interpret professional journals, memoranda, policies, administrative procedures, and statutes. Write business correspondence, including staff memoranda and newsletter articles. Keep information confidential when required by law, policy, or the nature of a particular situation. These are essential functions of the job.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>&nbsp;</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Computation: </strong>Work with mathematical concepts, such as probability and statistical inference, and analyze data for instruction. Apply concepts such as fractions, percentages, ratios and proportions to practical situations. Perform computer word processing (including spreadsheets) and internet research. Access and create reports using the Districts student information software and databases. These are essential functions of the job.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>&nbsp;</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Reasoning: </strong>Define problems, collect data, establish facts, and draw valid conclusions. Solve a variety of problems in many different situations. Interpret instructions presented in written, oral, diagram or schedule form. Demonstrate executive functions such as planning, organizing, remembering, and regulating information and behavior as they pertain to student performance and achievement. These are essential functions of the job.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>&nbsp;</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Technology: </strong>Present information using a variety of media/technology sources. Access and create reports using the District&rsquo;s student information software and databases. Readily utilize smart boards, projectors and other instructional technology provided by the district. Adhere to all District policies and procedures regarding technology use. These are essential functions of the job.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>&nbsp;</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Physical demands: </strong>Requires sedentary work involving standing or walking for brief periods, exerting up to 10 pounds of force on a regular basis, and considerable dexterity in operating office equipment. Consistent and regular attendance is an essential function of this position. These are essential functions of the job.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong><br /> Environmental conditions: </strong>The work environment is consistent with a typical office environment. The individual who holds this position is frequently required to work irregular or extended hours. These are essential functions of the job.</span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p><span style=\"font-size: 12pt;\"><em>Prospective and current employees with disabilities are encouraged to contact human resources to discuss reasonable accommodations to perform the essential job functions.&nbsp;</em></span></p>\r\n<p><span style=\"font-size: 12pt;\">&nbsp;</span></p>\r\n<p style=\"text-align: center;\"><span style=\"font-size: 12pt;\"><strong>Equal Opportunity Employer</strong></span></p>","jobTypeName":"Full-time","positions":1,"payDisplay":1,"payMin":93840.88,"payMax":140771.68,"payTypeName":"","employerID":106934,"employerTypeID":1,"employerName":"Columbia","employerDescription":null,"employerShowImage":0,"eoeStatement":null,"requirements":null,"experienceRequired":null,"degreePreferred":0,"eligibleRequired":0,"degreeTypeName":"Not Provided","instructions":null,"internalQuestionsRequired":0,"employerAccountTypeID":21,"contactFirstName":"Joe Lauchstaedt","contactLastName":null,"contactTitle":"Director of Data Services","contactAddress1":"Assessment, Intervention, and Data","contactAddress2":null,"contactCity":null,"contactCountryID":0,"stateName":null,"countryName":null,"contactPostalCode":null,"contactPhone":"","contactFax":null,"contactEmail":"JLauchstaedt@cpsk12.org","shiftType":"Full-Time","salaryCode":"Annual","contactUserID":0,"displayEmployer":"Columbia Public Schools","closeDate":"2026-12-11T23:00:00","timeZone":"Central Standard Time","internalCloseDate":"2026-12-11T23:00:00","employmentStartDateTBD":true,"activeEmployer":true},"jobCategories":[{"category":"Administration","subCategory":"Director/Coordinator/Manager"}],"applicationQuestions":null,"jobBoards":[{"jobBoardName":"Columbia Public Schools","jobBoardUrl":"https://columbia.schoolspring.com"}],"jobLocations":[{"locationID":203369,"locationName":"Assessment, Intervention, and Data","displayLocation":"Columbia, Missouri","latitude":38.9601,"longitude":-92.366,"locationDescription":null,"locationShowImage":0}],"baseDomainURL":null,"jobApplicationId":null,"jobApplicationStatusId":null,"jobBoardDistrict":true,"formattedExternalCloseDate":"Dec 11, 2026 5:00 PM (Central Standard Time)","formattedInternalCloseDate":"Dec 11, 2026 5:00 PM (Central Standard Time)","isAtsJob":true,"jobApplicationDate":null}}