Allotments Analyst and Visualization Specialist

State of North Carolina

1d

About The Position

This is a time-limited position. It is full-time (40 hours per week) with State Benefits for a limited time. If you have questions concerning the time-limited status of this position, you may inquire at the interview. The allotments system at NC DPI is responsible for the distribution of approximately $13 billion in state and federal funding to public school units (PSUs) throughout the state. The distribution of these funds is governed by over 70 formulas of varying complexity. Current work is done in Microsoft Excel. It is crucial for accuracy and efficiency that these calculations be moved to a more modern, automated platform. This position will help the operational output of the allotments team on a day-to-day basis while also working with DPI’s IT department to modernize the allotment process and system.

Requirements

• Bachelor's degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and two years of experience in business application consulting or development; or Associate degree in computer science or an IT related field from an appropriately accredited institution and three years of experience in application consulting or development; or High School or General Educational Development (GED) diploma and six years of experience in business application consulting or development; or an equivalent combination of education and experience.

Nice To Haves

• Experience in analyzing data and using tools such as SQL, R, Python, Power BI, Power Query, MS Access, Excel, and/or Tableau.

Responsibilities

• Developing dashboards and reports for school business services, the department more generally, and the public schools in Tableau.
• Maintain data and analytic models and perform analysis of data sets.
• Provide development expertise related to data visualization and transitioning from a legacy mainframe and Access based systems and data analytics to a new data environment.
• Ensure customer satisfaction and establish and manage a clear communication strategy with all business units.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level