Data and Reporting Analyst

Salary:

$54,197.00 - $94,844.00 Annually

Location :

Durham County, NC

Job Type:

Time-Limited Full-Time

Remote Employment:

Flexible/Hybrid

Job Number:

24-07948

Department:

Dept of Public Safety

Division:

Chief of Staff

Opening Date:

06/24/2024

Closing Date:

7/1/2024 5:00 PM Eastern

Job Class Title:

Administrative Officer

Position Number:

65026404

Section:

NCORR

Work Location:

Remote

Salary Grade:

NC16

Recruitment Range:

54,197 - 78,000

Description of Work

The North Carolina Office of Recovery and Resiliency (NCORR) in the Department of Public Safety (DPS) is responsible for executing multi-year recovery and resiliency projects related to damage sustained in Hurricanes Matthew and Florence. The Office headquarters is in Research Triangle Park. The Office's work focuses on supporting long-term recovery for storm survivors and communities impacted by the two storms. The Office actively engages in projects in the following areas: Single-Family Homeowner Rehabilitation/Repair, Housing Repair Reimbursement, Single-family Homeowner Reconstruction, Homeowner Buyout, Mobile Home Repair, Mobile Home Replacement, Homeowner Assistance, Infrastructure, Affordable Housing and Mitigation.

North Carolina Office of Recovery & Resiliency is fully funded on grants and positions will be maintained as long as funding is available. The position is EHRA, which means it is exempt from the rules and regulations of the NC Office of Human Resources Act (GS126), except for Articles 6 and 7 of that Chapter, due to state statutory and/or funding requirements.
This position qualifies for teleworking on a part-time basis as part of a State Teleworking Program. Any telework will be under the conditions of the State Teleworking Program Policy, and the employer may end any teleworking arrangement at any time at the employer's sole discretion.

The selected candidate will work within Salesforce and other systems to provide support to NCORR teams or leadership by collecting and analyzing data and reporting results based on the needs of end users and collaborates with various functional teams based on their area of focus, and IT to achieve business results. The Analyst will develop and enable solutions (reports, visualizations, dashboards) for information that is frequently asked for and assist in the development and management of those dashboards. The selected candidate will write ad hoc queries and reports using various reporting/database tools to support NCORR initiatives. The Analyst will be responsible for the design, development, configuration, testing, implementation, maintenance, and security of reporting and associated applications to ensure timely and accurate outputs that inform data-driven decisions that align with NCORR's business strategy and vision. If you selected, the candidate will coordinate with various partners for regular distribution of data and track receipt of data; set up and maintain systems or processes for securely storing data received, especially data sets that contain Personal Identifiable Identification (PII). The Data and Reporting Analyst will develop, implement, and update new user orientation for Salesforce, Tableau and other reporting applications. They will also develop and implement training for the system of record and conduct training as needed. The selected candidate is also responsible for coordinating recovery data from various sources, such as FEMA, SBA, HMGP, etc., and serve as NCORR's primary liaison with the associated agencies. The position reports to the NCORR Director of Reporting and Business Systems.
Knowledge, Skills and Abilities / Competencies

Minimum Education and Experience are REQUIRED to qualify for this position. Candidates should possess 4 of the 9 Knowledge, Skills and Abilities listed below. We will not review resumes in lieu of Experience and Education listed on the application. Click these links for additional information: Introduction to the Job Application and Addressing Knowledge, Skills and Abilities. (Note: These links were created for applicants of Dept. of Public Safety jobs and may not reflect the policies or procedures of other State agencies).

Understanding of Salesforce reporting capabilities, limitations, and experience in building complex reports.
Proficiency in creating dashboards and visualizations within Salesforce.
Experience collecting, analyzing, evaluating and reporting data to track performance and trends.
Experience analyzing data and provide actionable insights to support business decisions.
Experience in proactively identifying and managing situations requiring complex communication for internal and/or external audiences.
Skilled in making recommendations on issues that affect the direction of business systems and business.
Skilled in planning, organizing, and conducting training in multiple settings.
Skilled in working independently to meet goals and deadlines.
Strong capabilities in Microsoft Office Suite, especially Excel.

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 for details.

Bachelor's degree from appropriately accredited institution in a discipline related to the area of assignment plus two years of programmatic experience related to the area of assignment; or equivalent combination of training and experience.
Supplemental and Contact Information

The North Carolina Department of Public Safety (DPS) is an Equal Opportunity Employer who embraces an Employment First philosophy which consists of complying with all federal laws, state laws and Executive Orders. We are committed to reviewing requests for reasonable accommodation at any time during the hiring process or while on the job.
DPS uses the Merit-Based Recruitment and Selection Plan to fill positions with the most qualified individuals. Hiring salary will be based on relevant qualifications, internal equity and budgetary considerations pertinent to the advertised position.

It is critical to our screening and salary determination process that applications contain comprehensive information. Information should be provided in the appropriate areas to include the beginning and ending dates of jobs worked, education with the date graduated, all work experience, and certificates / licenses. Resumes will not be accepted in lieu of completing this application. Answers to Supplemental Questions must refer to education or work experience listed on this application to receive credit. Degrees must be received from appropriately accredited institutions.
• Applicants seeking Veteran's Preference must attach a DD-214 Member-4 Form (Certificate of Release or Discharge from Active Duty) to their applications.
• Applicants seeking National Guard Preference must attach a NGB 23A (RPAS) if they are a current member of the NC National Guard in good standing. If a former member of the NC National Guard who served for at least 6 years and was discharged under honorable conditions, they must attach either a DD256 or NGB 22.
• If applicants earned college credit hours but did not complete a degree program, they must attach an unofficial transcript to each application to receive credit for this education.
• The NC Dept. of Public Safety must adhere to the US Dept. of Justice Final Rule on the "National Standards to Prevent, Detect, and Respond to Prison Rape." Click this link for information on hiring and promotion prohibition requirements in the Division of Juvenile Justice & Delinquency Prevention: Per NC General Statute 143B-972.1, applicants hired into a position certified as a criminal justice officer or justice officer are required to electronically submit fingerprints to the NC State Bureau of Investigation for a state and national criminal history record check and enrollment in the FBI's Next Generation Identification System: Criminal Justice Record of Arrest and Prosecution Background Service ("RAP Back"). This is in addition to submitting fingerprints during the application process.

Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account and click "Application Status." If you are selected for an interview, you will be contacted by management. If you are no longer under consideration, you will receive an email notification.
For technical issues with your application, please call the GovernmentJobs.com Applicant Support Help Line at 855-524-5627. If there are any questions about this posting other than your application status, please contact Ashley Minnick at [email protected].

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

North Carolina Office of Recovery & Resiliency is fully funded on grants and positions will be maintained as long as funding is available. The position is ERHA, which means it is exempt from the rules and regulations of the NC Office of Human Resources Act (GS126), except for Articles 6 and 7 of that Chapter, due to state statutory and/or funding requirements. Do you understand this statement?

Yes
No

02

To qualify for this position, applicants must possess the required "Minimum Education and Experience" AND 4 out of 9 "Knowledge, Skills and Abilities" listed on the job posting. I understand that my application MUST include a complete work history in the "Work Experience" section, all education in the "Education" section, and credentials in the" Certificates and Licenses" section. I understand that a resume is NOT a substitute for completing the sections listed above. Also, I understand that Supplemental Questions are part of the application and the answers are used in the screening process; all questions must be answered completely and accurately.

Yes, I understand.

03

Which of the following is the highest level of education you have COMPLETED?

High School Diploma
GED
Associates Degree
Bachelors Degree
Masters Degree or Higher

04

Do you have experience working in Salesforce with reporting capabilities, limitations, and building complex reports?

Yes
No

05

If you indicated having experience to the previous question, please describe your experience, and indicate in which job(s) or educational experience(s) you gained this experience. If you do not have this experience, write "N/A."

06

How many years of experience do you have creating dashboards and visualizations within Salesforce?

None
Less than 1 year
1 - 3 years
3 - 5 years
5 + years

07

If you indicated having experience to the previous question, please describe your experience, and indicate in which job(s) or educational experience(s) you gained this experience. If you do not have this experience, write "N/A."

08

Which of the answer choices below best describes your experience collecting, analyzing, evaluating and reporting data to track performance and trends?

None
Limited
Intermediate
Advanced

09

If you indicated having experience to the previous question, please describe your experience, and indicate in which job(s) or educational experience(s) you gained this experience. If you do not have this experience, write "N/A."

10

Do you possess experience analyzing data and provide actionable insights to support business decisions?

Yes
No

11

If you indicated having experience to the previous question, please describe your experience, and indicate in which job(s) or educational experience(s) you gained this experience. If you do not have this experience, write "N/A."

12

Do you have thorough knowledge of proactively identifying and managing situations requiring complex communication for internal and/or external audiences?

Yes
No

13

If you indicated having experience to the previous question, please describe your experience, and indicate in which job(s) or educational experience(s) you gained this experience. If you do not have this experience, write "N/A."

14

How many years of experience do you have planning, organizing, and conducting training in multiple settings?

None
Less than 1 year
1 - 3 years
3 - 5 years
5 + years

15

If you indicated having experience to the previous question, please describe your experience, and indicate in which job(s) or educational experience(s) you gained this experience. If you do not have this experience, write "N/A."

16

Which answer choice best describes your experience working independently to meet goals and deadlines?

None
Limited
Intermediate
Advanced

17

How many years of experience do you have in Microsoft Office Suite, especially Excel?

None
Less than 1 year
1 - 3 years
3 - 5 years
5 + years

Required Question