Power BI Data Visualization Analyst
State of North CarolinaDescription of Work
The mission of the Department of Public Instruction:
The North Carolina Department of Public Instruction (NCDPI) is charged with implementing the state's public school laws for pre-kindergarten through 12th grade public schools at the direction of the State Superintendent of Public Instruction and State Board of Education.
The North Carolina Department of Public Instruction is seeking applicants for an Applications Systems Analyst II(Working Title: Power BI Data Visualization Analyst) for the Office of School Business Services.
The Office of School Business of the Department of Public Instruction has four sections: Reporting and Analysis (12 staff), Monitoring and Compliance (11 staff), School Allotments (5 staff), and Program Support/Special Projects (8 staff). Overall, this area services the entire agency, the 115 Local Education Agencies (LEAs), all charter schools and other educational entities, the State Board of Education, the Governor’s Office, the General Assembly, and the taxpayers of North Carolina. It has the oversight of over $10.5 billion in State dollars, $7 billion of federal funds, $2.5 billion of capital funds, as well as other federal programs such as School Nutrition services, etc. This division is responsible for the State Public School Fund Budget, the allocations of funding to Public School Units and nonprofits; collecting and accounting for the expenditures; the monitoring and compliance of the use of the funds; the analysis and reporting of the financial, personnel and aggregate student data; the development of the policies related to public school salary, allotments of State and Federal funds and Student accounting.
The Power BI Data Visualization Analyst is responsible and accountable to the School Business Senior Director for the overall success (on time, on budget, on scope) of delivery for critical, larger, more complex and/or more visible projects within the School Business Systems Modernization Initiative (SBSM), including ERP initiatives.
The primary purpose of this position is to develop and implement Power BI Data Visualization and Reporting based on Public School Uniform Education Reporting Statistics (UERS) data files submitted to DPI monthly along with other Office of School Business Services data such as allotment formulas, salary data analytics, JLOC reporting requirements, etc. This position formulates and develops application system scope and objectives, provides detailed specifications for implementation.
This position will be developing, designing, modifying complex data projects and analytical databases and systems. This position must also implement the conversion of older technologies (Access, Excel, SQL, mainframe) currently used for data analytics and reporting requirements into the newer applications such as but not limited to Power BI, Tableau, etc. This role develops or modifies solutions for more complex projects and may provide guidance and training to other analysts and technicians. This position will also work on various applications and with software developers related to the quality assurance of their applications and the software testing to ensure the required legislative files under the Uniform Education Reporting system meet all applicable requirements.
This position must ensure quality data requirements gathering and documentation to support the modifications of systems and various data analytical strategies as may be developed. They will work closely with the Technology Services division as well as other areas with the Department. This position reports to the SBS Project Manager for Modernization and the PSU Support in the Office of School Business. Other duties as assigned.
This position requires 3 days onsite per week.EEO Statement:
The State of North Carolina and the Department of Public Instruction provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Knowledge, Skills and Abilities / Competencies
To receive credit for all of your work history and credentials, you must list the information on the application form. Any information listed under the text resume section or on an attachment will not be considered for qualifying credit. Qualified candidates must document on the application that they possess all of the following:
- Demonstrated experience with Microsoft Office Suite products and/or financial systems.
- Demonstrated experience in analyzing data and/or using tools such as Power BI, Power Query, MS Access.
- Demonstrated experience creating and/or utilizing Standard Operating Processes (SOP) and/or, Reports, and/or Manuals.
Minimum Education and Experience Requirements
Some state job postings say you can qualify by an “equivalent combination of education and experience.” If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See oshr.nc.gov/experience-guide for details.
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.Supplemental and Contact Information
All applicants must complete and submit a state application for employment using the NEOGOV Online Job Application System (Job Opportunities | Sorted by Job Title ascending | Careers (governmentjobs.com) for the State of North Carolina.
Any applications not received by the advertisement closing date and time will not be accepted outside of the portal. To receive credit for work history and credentials, the applicant must list the information on the online application form. Any information omitted from the application cannot be considered for qualifying credit. NC DPI welcomes attached or incorporated resumes, cover letters and reference information, but these items will not be used for screening for qualifying credit.
Please make sure the application is completed in full. If you put "See Resume" or "See Attachment" on your application instead of a completed application with detailed work duties, your application will NOT be accepted. Other attachments (except a DD-214 copy) will also be accepted, but not used in screening for qualifying credit.
Applicants are required to scan and attach a copy of their DD-214 (Form 4 or Certificate of Release or Discharge from Active Duty) or discharge orders if they wish to obtain Veteran's preference.
Reference checks will be performed on all selected candidates. If the position requires a background check and/or drug screening that will also be performed on all selected candidates.
Applicants may be subject to a criminal background check. All candidates selected for positions considered "Positions of Trust" will be subject to a criminal background check. To check the status of an application, please log in to your NC Government Job Opportunities account and click "Application Status".
For technical issues with your application, please call the NeoGov Help Line at 877-204-4442. If you have a technical issue with your Government Jobs account, please call their Help Line at 1-855-524-5627.
NOTE: Applicants will be communicated with via email only for updates on the status of their application or any questions on their application.
If there are any questions about this posting other than your application status, please contact NC Department of Public Instruction Human Resources.
Contact Information
Houston Davis, Agency Recruiter
Email: houston.davis@dpi.nc.gov
Applications for positions requiring specific coursework must be accompanied by a copy of the applicant's transcript. Applicants with degrees not conferred at a United States college or university must attach verification that their degree is equivalent to a similar degree from a U.S. institution. The Office of State Human Resources uses the National Association of Credential Evaluation Services (NACES) as a referral resource for applicants who need to have their credentials certified as equivalent. For a list of organizations that perform this specialized service, please visit the NACES membership website at http://www.naces.org/members.htm. Transcripts, degree evaluations and cover letters may be uploaded with your application.