State of North Carolina
SQL/PowerBI/Tableau Data Visualization Analyst
State of North Carolina, Wilmington, North Carolina, United States, 28412
Salary:
$75,814.00 - $113,721.00 Annually
Location :
Wake County, NC
Job Type:
Time-Limited Full-Time
Job Number:
24-09841 60091183
Department:
Dept of Public Instruction
Opening Date:
08/09/2024
Closing Date:
8/19/2024 5:00 PM Eastern
Job Class Title:
Applications Systems Analyst II
Position Number:
60091183
Section:
Financial Business Services Division/School Business Services
Work Location:
301 North Wilmington Street, Raleigh, NC (On Site Minimum of 3 Days a Week)
Salary Grade:
DT09
Recruitment Range:
$75,814 - $94,683
Description of Work
**********THIS IS A FULL-TIME, 3 Year TIME LIMITED POSITION **********
The mission of the Department of Public Instruction:
The State Board of Education has the constitutional authority to lead and uphold the system of public education in North Carolina.
The North Carolina Department of Public Instruction
is seeking applicants for an Applications Systems Analyst II (Working Title: PSQL/PowerBI/Tableau 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 currently used for data analytics and reporting requirements into the newer applications such as but not limited to Power BI, Tableau, Access, Excel, SQL, mainframe 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.
Note : To receive credit for your work history and credentials, you must list the information on the State of North Carolina application in the Education and Work Experience sections of the 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.
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
Knowledge, Skills, and Abilities Competencies
Demonstrated experience with and Microsoft Office Suite product, and/or financial systems.Demonstrated experience analyzing data and/or using tools such as Power BI, Power Query, MS Access, Tableau, and SQL.
Demonstrated experience in written communication such as 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.
MANAGEMENT PREFERENCES:The ideal candidate will possess the ability to plan and manage the integration and implementation of new technology, solve highly technical and complex problems while guiding and directing projects through completion. The candidate should possess critical thinking skills, analytical skills, solid organizational skills, and excellent written and verbal communication skills.
Experience with Financial and Business Operational systems and data will be critical to ensure the data integrity of the work products are maintained. Experience collaborating with School Business Processes and Functions to ensure appropriate guidance can be established for process workflow improvements that will not adversely impact the 300+ PSUs we serve. A thorough knowledge of specific computer environments and a board range of programming and/or developmental languages is key as we have PSU operating mainframe (green screen) systems to web-based ERP solutions. The ideal candidate will have the ability to learn emerging technologies and apply those technologies (Power BI, Power Query, MS Access, Tableau, and SQL).Supplemental and Contact Information
All applicants must complete and submit a State application for employment using the NEOGOV Online Job Application System ( 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. For inquiries, please send questions to .
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.
NOTE: For temporary, contract or other supplemental staffing appointments:There are no paid leave, retirement or other benefits associated with these appointment types.
For permanent and time-limited appointments:Eligible employees have benefits that include employee health insurance options, standard and supplemental retirement plans, NC Flex (a variety of high-quality, low-cost benefits on a pre-tax basis), and paid vacation, sick, and community service leave, to name a few. Paid parental leave is available for eligible employees. Some benefits require 30 + hours work/week for participation.
01
The salary offered will be within the recruitment range posted on job advertisement and based on education, experience, and equity. If selected for this position, would the salary between $75,814 - $94,683 be acceptable to you?
YesNo
02
(Please ensure experience relating to the answer to the following question is documented in detail on your application). How many years of documented experience do you have with Microsoft Office Suite product, and/or financial systems?
More than 5 years4 - 5 years3 - 4 years2 - 3 years1 - 2 yearsLess than 1 yearNone
03
(Please ensure experience relating to the answer to the following question is documented in detail on your application). How many years of documented experience do you have analyzing data and using tools such as Power BI, Power Query, MS Access, Tableau, and SQL.?
More than 5 years4 - 5 years3 - 4 years2 - 3 years1 - 2 yearsLess than 1 yearNone
04
(Please ensure experience relating to the answer to the following question is documented in detail on your application). How many years of documented experience do you have in written communication such as Standard Operating Processes (SOP) and/or, Reports, and/or Manuals?
More than 5 years4 - 5 years3 - 4 years2 - 3 years1 - 2 yearsLess than 1 yearNone
05
To receive credit for the supplemental questions you have answered here, you must provide supporting information related to these questions within the body of your application to support your answer. It is critical in our screening and salary determination process that applications contain comprehensive candidate information. G.S.126-30 speaks to fraudulent disclosures given to meet position qualifications. Have you provided written information to these appropriate areas to include the following: education, work experience, certificates and licenses, and documented competencies as they relate to the position you are applying for?
YesNo
06
How did you learn about this opportunity?
OSHR WebsiteProfessional Association WebsiteProfessional AssociationProfessional JournalSocial MediaLinkedInEmployment Security CommissionLa NoticiaFriend/ ColleagueTV/ RadioCollege/ University Recruitment Fair/ PresentationCollege/ University WebsiteOther
Required Question
$75,814.00 - $113,721.00 Annually
Location :
Wake County, NC
Job Type:
Time-Limited Full-Time
Job Number:
24-09841 60091183
Department:
Dept of Public Instruction
Opening Date:
08/09/2024
Closing Date:
8/19/2024 5:00 PM Eastern
Job Class Title:
Applications Systems Analyst II
Position Number:
60091183
Section:
Financial Business Services Division/School Business Services
Work Location:
301 North Wilmington Street, Raleigh, NC (On Site Minimum of 3 Days a Week)
Salary Grade:
DT09
Recruitment Range:
$75,814 - $94,683
Description of Work
**********THIS IS A FULL-TIME, 3 Year TIME LIMITED POSITION **********
The mission of the Department of Public Instruction:
The State Board of Education has the constitutional authority to lead and uphold the system of public education in North Carolina.
The North Carolina Department of Public Instruction
is seeking applicants for an Applications Systems Analyst II (Working Title: PSQL/PowerBI/Tableau 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 currently used for data analytics and reporting requirements into the newer applications such as but not limited to Power BI, Tableau, Access, Excel, SQL, mainframe 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.
Note : To receive credit for your work history and credentials, you must list the information on the State of North Carolina application in the Education and Work Experience sections of the 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.
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
Knowledge, Skills, and Abilities Competencies
Demonstrated experience with and Microsoft Office Suite product, and/or financial systems.Demonstrated experience analyzing data and/or using tools such as Power BI, Power Query, MS Access, Tableau, and SQL.
Demonstrated experience in written communication such as 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.
MANAGEMENT PREFERENCES:The ideal candidate will possess the ability to plan and manage the integration and implementation of new technology, solve highly technical and complex problems while guiding and directing projects through completion. The candidate should possess critical thinking skills, analytical skills, solid organizational skills, and excellent written and verbal communication skills.
Experience with Financial and Business Operational systems and data will be critical to ensure the data integrity of the work products are maintained. Experience collaborating with School Business Processes and Functions to ensure appropriate guidance can be established for process workflow improvements that will not adversely impact the 300+ PSUs we serve. A thorough knowledge of specific computer environments and a board range of programming and/or developmental languages is key as we have PSU operating mainframe (green screen) systems to web-based ERP solutions. The ideal candidate will have the ability to learn emerging technologies and apply those technologies (Power BI, Power Query, MS Access, Tableau, and SQL).Supplemental and Contact Information
All applicants must complete and submit a State application for employment using the NEOGOV Online Job Application System ( 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. For inquiries, please send questions to .
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.
NOTE: For temporary, contract or other supplemental staffing appointments:There are no paid leave, retirement or other benefits associated with these appointment types.
For permanent and time-limited appointments:Eligible employees have benefits that include employee health insurance options, standard and supplemental retirement plans, NC Flex (a variety of high-quality, low-cost benefits on a pre-tax basis), and paid vacation, sick, and community service leave, to name a few. Paid parental leave is available for eligible employees. Some benefits require 30 + hours work/week for participation.
01
The salary offered will be within the recruitment range posted on job advertisement and based on education, experience, and equity. If selected for this position, would the salary between $75,814 - $94,683 be acceptable to you?
YesNo
02
(Please ensure experience relating to the answer to the following question is documented in detail on your application). How many years of documented experience do you have with Microsoft Office Suite product, and/or financial systems?
More than 5 years4 - 5 years3 - 4 years2 - 3 years1 - 2 yearsLess than 1 yearNone
03
(Please ensure experience relating to the answer to the following question is documented in detail on your application). How many years of documented experience do you have analyzing data and using tools such as Power BI, Power Query, MS Access, Tableau, and SQL.?
More than 5 years4 - 5 years3 - 4 years2 - 3 years1 - 2 yearsLess than 1 yearNone
04
(Please ensure experience relating to the answer to the following question is documented in detail on your application). How many years of documented experience do you have in written communication such as Standard Operating Processes (SOP) and/or, Reports, and/or Manuals?
More than 5 years4 - 5 years3 - 4 years2 - 3 years1 - 2 yearsLess than 1 yearNone
05
To receive credit for the supplemental questions you have answered here, you must provide supporting information related to these questions within the body of your application to support your answer. It is critical in our screening and salary determination process that applications contain comprehensive candidate information. G.S.126-30 speaks to fraudulent disclosures given to meet position qualifications. Have you provided written information to these appropriate areas to include the following: education, work experience, certificates and licenses, and documented competencies as they relate to the position you are applying for?
YesNo
06
How did you learn about this opportunity?
OSHR WebsiteProfessional Association WebsiteProfessional AssociationProfessional JournalSocial MediaLinkedInEmployment Security CommissionLa NoticiaFriend/ ColleagueTV/ RadioCollege/ University Recruitment Fair/ PresentationCollege/ University WebsiteOther
Required Question