Job Location: Jacksonville, FL
Print (http://agency.governmentjobs.com/jacksonvillefl/job_bulletin.cfm?jobID=3631043&sharedWindow=0)
Apply
Excel and Data Analyst
Salary
$60,000.00 – $64,000.00 Annually
Location
Jacksonville, FL
Job Type
Civil Service
Department
EMPLOYEE SERVICES
Job Number
2022-04946
Closing
9/26/2022 11:59 PM Eastern
- Description
- Benefits
- Questions
Job Description
Are you looking for a position with a work/life balance? Do you want to earn four weeks off during your first year of employment? Do you want low and no cost health insurance options? If you answered yes to any of these questions, you need to complete your application now. Work for the city you love!!!
The Employee Services Department is actively seeking a Excel and Data Analyst.
Did you know as a City of Jacksonville employee, you would also have 12 paid holidays and a personal leave day as well? In addition, to health insurance, dental, vision, life insurance and flexible spending plans are also available. City of Jacksonville employees are also eligible for Federal Student Loan Forgiveness after 10 years of public service and on-time payments.
This is professional work providing consults, reports, data review and statistical research to support HR objectives and facilitate recommendations for process improvements. The work requires knowledge of and the ability to apply theories, principles and practices of data analysis and process improvement, which is usually gained through degree granting schools or related work experience. Contacts with others require skill in understanding and influencing people which are important in providing reporting and process improvement services, discussing, and resolving work-related issues and problems, presenting, and defending recommendations and decisions, and making presentations. Work is standardized in that tasks are covered by substantially diversified procedures and specialized standards and because of changing priorities or different situations, incumbents have the latitude to consider which of the many procedures or standards should be followed and in what sequence. The work involves differing situations requiring use of judgment in searching for solutions or new applications. Work is performed mainly in an office environment. Operates a personal computer and standard office equipment. Physical demands consist mainly of sitting or standing at a workstation for extended periods of time, using standard office equipment on an ongoing basis, and occasionally lifting and moving light objects. Work is performed under limited supervision where the work assignments are subject to established procedures, practices, precedents, methods, techniques, or well-defined policies; the worker plans and organizes the work, and determines priorities; and the work is generally reviewed upon completion for technical accuracy, acceptability of results, quality and timeliness.
Examples of Work
- Generates a variety of standard reports and performs ad hoc reports as requested.
- Performs audits of HRIS information to ensure data integrity, reporting efficiency and to identify software and hardware problems.
- Summarizes and translates report data into organized and useable/actionable content to drive strategic decision making.
- Analyzes current procedures and recommends process improvement through utilization of HRIS, Microsoft Office, database, or other appropriate software/platforms.
- Assists department coaches and management on employee performance management system (EPMS) and serves as the EPMS administrator.
- Gathers data, documentation, prepares reports, and coordinates responses for various internal and external requests.
- May participate in providing analytical support and document preparation for collective bargaining negotiations.
- Works with the IT Division on assets including audits of hardware and furniture.
- Demonstrates proficiency in the City of Jacksonville’s competencies.
- Performs related work as required.
Knowledge, Skills And Abilities
- Knowledge of the theories, principles and practices of data analysis and process improvement.
- Knowledge of principles, practices and techniques used to design, implement, maintain, and modify ERP, HRIS or related database systems. Knowledge of computer hardware, software, and database systems.
- Knowledge of human resources practices, policies, processes, and terminology preferred.
- Skill in developing complex reports using advanced knowledge of Microsoft Office programs, reporting tools, databases, and various ERP systems.
- Advanced skill in the use of Microsoft Excel including the ability to import, clean and reformat data from various sources; use advanced formulas to create relational connections, apply business rules and perform calculations; create pivot tables, graphs/charts, dashboards and professional summaries.
- Ability to analyze and recommend process and system design changes and upgrades.
- Ability to develop and conduct training for users on human resources processes and systems, which includes training manuals and reference materials.
- Ability to research, analyze and interpret rules, regulations, and policies.
- Ability to prepare documentation and reports for collective bargaining, public records requests, internal or external audit requests, and other internal or external reports as required.
- Ability to design, implement and maintain audit programs related to data integrity.
- Ability to communicate effectively both orally and in writing.
- Ability to establish effective working relationships.
- Ability to operate a computer utilizing Microsoft Office, HRIS systems, and related software and standard office equipment.
Open Requirements/Supplemental Information
- Six years of education and/or professional experience in data/metrics reporting, process improvement and/or data management or related field.
- Advanced knowledge of Microsoft Excel required including the ability to aggregate, manipulate and visualize data from multiple resources.
- Experience using VBA, PowerPivot, Access, SharePoint, or other advanced data reporting tools preferred. System implementation experience also highly preferred.
- A Bachelor’s degree with a major in a related field is preferred.
- Prior work experience with HRIS systems highly preferred.
OTHER REQUIREMENTS: The probationary period for this class is one year.
A FULLY COMPLETED ONLINE APPLICATION IS REQUIRED. Apply at www.coj.net. Work history is required for all employment/volunteer work in which qualifications are being based. When meeting/basing qualifications on education, a copy of your college transcript, with your social blacked out, is required with your application. Transcripts do not need to be official, but must state your name, the school’s name, classes taken, grades received, type of degree, and date degree was conferred.
The application system works best with Google Chrome or Edge with Chromium web browsers. Please try to apply using one of these browsers. Be sure to add coj.net to your safe senders list to ensure you receive email notifications. You may also track the status of your application and see notifications by logging into your account.
Certain servicemembers and veterans, and the spouses and the family members of such service members and veterans, receive preference and priority, and certain servicemembers may be eligible to receive waivers for postsecondary educational requirements, in employment and are encouraged to apply for positions being filled.
If claiming veteran’s preference, you must attach a DD-214 (Member Form-4 copy) or military discharge papers, or equivalent certification from the Department of Veterans Affairs listing military status, dates of service and character of discharge. You must also attach the Veterans Preference Certification Form and if applicable, the additional forms as noted here: http://www.coj.net/departments/employee-services/veterans-preference
If a Candidate Believes He Or She Was Not Afforded Veteran’s Preference, He Or She May File a Written Complaint, Within 60 Calendar Days Upon Receipt Of Notification Of The Hiring Decision, Requesting An Investigation To
Florida Department of Veterans Affairs
Attention: Veterans’ Preference Coordinator
11351 Ulmerton Road, Suite 311-K
Largo, FL 33778-1630
Email: VeteransPreference@fdva.state.fl.us
The City of Jacksonville provides a wide array of benefits to meet the diverse needs of our employees. Our comprehensive benefit programs include medical, dental and vision plans; life insurance coverage for you and your dependents; flexible spending plans for medical reimbursement, dependent care, parking, and transit expenses; an employee assistance program for you and your dependents; a 457(b) tax-deferred compensation plan to supplement your retirement, and a ROTH IRA plan. We also provide an extensive wellness program that includes a health intervention program if qualified, lunch and learns, health fairs, and discounted gym memberships. Please visit the Employee Benefits website for details on all the plans we offer.
www.coj.net/benefits
01
Each applicant must complete this supplemental questionnaire as a part of the application screening and selection process. The information you provide will be reviewed and used to determine your eligibility to move forward in the selection process. Copying and pasting your resume or stating “see resume” does NOT fulfill the requirements of the question. Incomplete responses, false statements, omissions, or partial information may result in disqualification from the selection process. Do you agree to answer each supplemental question truthfully and certify that your responses can be verified from information included within the application?
- Yes
- No
02
Are you authorized to work in the United States without sponsorship from the City of Jacksonville either now or in the future?
- Yes
- No
03
The budgeted annual salary range for this position is 60,000.00-64,000.00. This is not negotiable. If selected, would you be willing to accept this position in this pay range?
- Yes
- No
04
Do you have six years of education and/or professional experience in data/metrics reporting, process improvement and/or data management or related field.
- Yes
- No
05
Indicate the organization(s) you worked for where you gained this experience.
06
Provide a detailed description (at least 3-4 complete sentences) of your experience.
07
Do you have prior work experience with HRIS systems?
- Yes
- No
08
Indicate the organization(s) you worked for where you gained this experience.
09
Provide a detailed description (at least 3-4 complete sentences) of your experience.
10
Do you have experience using VBA, PowerPivot, Access, SharePoint, or other advanced data reporting tools preferred. System implementation experience?
- Yes
- No
11
Indicate the organization(s) you worked for where you gained this experience.
12
Provide a detailed description (at least 3-4 complete sentences) of your experience.
13
Do you have advanced knowledge of Microsoft Excel required including the ability to aggregate, manipulate and visualize data from multiple resources?
- Yes
- No
14
Indicate the organization(s) you worked for where you gained this experience.
15
Provide a detailed description (at least 3-4 complete sentences) of your experience.
16
Do you have a bachelor’s degree or higher from an accredited college or university? If yes, you MUST attach a copy of your college transcripts to your application.
- Yes
- No
17
If basing/meeting qualifications based on education, a copy of your college transcript is required with your application. College transcripts do not need to be official, but must state your name, the name of the school, type of degree, classes taken, grades received and date degree was conferred. NOTE: A copy of your diploma does not meet this requirement. Transcripts from colleges outside of the U.S. must be converted to U.S. Standards. If required documents are not provided your application will be considered incomplete and may result in disqualification from the selection process.
- I have read the above statement and understand what is required.
18
If you are requesting veterans preference, you MUST download the appropriate state of Florida form (even if you don’t live in Florida) and attach it to your application. FAILURE TO DO SO WILL DELAY YOUR VETERANS PREFERENCE STATUS. Please download the forms at http://www.coj.net/departments/employee-services/veterans-preference
- Yes, I am claiming veterans preference and I understand that I MUST download the appropriate form and attach it to my application.
- No, I am not claiming veterans preference and this does not apply to me.
Required Question
Agency
City of Jacksonville
Address
117 W. Duval St. Suite 150 Jacksonville, Florida, 32202
Website
http://www.coj.net/departments/employee-services.aspx
Apply
Please verify your email address Verify Email
Submit CV To All Data Science Job Consultants Across United States For Free
