Data Analyst - Open Data Program
Apply NowCompany: City of Norfolk, VA
Location: Norfolk, VA 23503
Description:
Salary : $68,675.00 - $111,968.00 Annually
Location : Norfolk, VA
Job Type: Permanent Full-time
Remote Employment: Flexible/Hybrid
Job Number: 12952
Department: Budget & Strategic Planning
Opening Date: 03/11/2025
Closing Date: 3/26/2025 11:59 PM Eastern
Description
Norfolk, Virginia is America's most authentic and urban waterfront city. Home to the world's largest naval station and the business, arts, and cultural center of Coastal Virginia, Norfolk has been rated a top place to live, work, play, and raise a family by numerous publications. Working for the City of Norfolk is an opportunity to make a real difference in the lives of others. With our commitment to competitive pay and a strong retirement package, you can do good for your community and do well for yourself. Join a caring workplace that proudly celebrates uniqueness, authenticity, and a shared commitment to improving the lives of our residents.
Join Norfolk's Department of Budget & Strategic Planning to make a difference in our dynamic and diverse community. A career with the Department of Budget & Strategic Planning puts you on a rich and rewarding professional path in local government. CivicLab is a division of the City of Norfolk's Department of Budget and Strategic Planning that uses data science, process improvement, and transparency to create a culture of innovation and efficient public services.
The Department of Budget and Strategic Planning is seeking to hire a Data Analyst to join its Open Data Program, which leads the city's initiative to promote transparency through the publication of data. This role consists of the technical responsibilities of automating the collection and publication of data, as well as the communications responsibilities of ensuring the data is accessible and understandable. It will also assist other teams and departments with more general data analysis work as needed.
Department Hiring Salary Range: $68,675 - $78,976
Essential Functions
Essential functions include but are not limited to:
Education/Experience
Work requires broad knowledge in a general professional or technical field. Knowledge is normally acquired through four years of college resulting in a Bachelor's degree or equivalent. Preferred academic coursework in Computer Science/Data Science/Statistics or related area of study.
Three years' experience in data analysis or related field, or an equivalent combination of education and experience
Additional preferred experience:
Additional Information & Requirements
Work Location: 810 Union Street, Norfolk, VA 23510
Work Hours: Monday through Friday, 8:30AM - 5PM
Signing Bonus: This position is eligible for a one-time $5,000 signing bonus for applications received on or after February 22, 2022. The signing bonus will be paid in two (2) increments: $2,500 upon completion of 60 days of employment, and $2,500 upon completion of your probationary period. To receive the signing bonus, you must be an active employee in good standing.
If you are hired January 1, 2022, or after to a position with Virginia Retirement System (VRS) benefits, you will be required to contribute five percent (5%) of your salary toward your retirement benefit. This will be a pre-tax payroll deduction.
NOTE:
The benefits described above are broad generalizations. The specific benefits that an employee may be eligible for are governed by City regulations, as applicable to job type.
Non-City
Positions listed with a job type designation of "Non-City" are not subject to the benefits descriptions above. Refer to the content of the job posting for information regarding these positions.
01
The following Supplemental Questions are specific to the position for which you have applied to assist the hiring manager in screening applications for specific experience being sought. Please be specific in answering these questions as they will be used to evaluate which applications will be given further consideration in the process. Do not answer "see resume" or "see application" as these are not valid answers. Please note that if you are invited to be interviewed by the department, your responses to the following questions may be subject to verification.
02
Please select the highest level of education you have completed.
03
How many years of experience do you have using Python for data analysis?
04
Do you hold a bachelor's degree or higher in Computer Science, Data Science, Statistics or related area of study?
05
Which of the following data sources and data types are you experienced with? (Select all that apply)
06
Do you have experience presenting technical concepts to a non-technical audience?
07
Describe your experience presenting technical concepts to a non-technical audience.
08
Which data analysis libraries/languages do you have experience programming in? (Select all that apply)
09
Do you have experience creating data visualizations in tools such as Power BI?
10
Please indicate your veteran status. (A copy of your long form DD-214 may be required)
11
Are you a current or previous City of Norfolk employee?
12
If you were referred for this position by a current City of Norfolk employee, please provide the employee's full name, department, and job title. If not, please indicate by typing "N/A."
Required Question
Location : Norfolk, VA
Job Type: Permanent Full-time
Remote Employment: Flexible/Hybrid
Job Number: 12952
Department: Budget & Strategic Planning
Opening Date: 03/11/2025
Closing Date: 3/26/2025 11:59 PM Eastern
Description
Norfolk, Virginia is America's most authentic and urban waterfront city. Home to the world's largest naval station and the business, arts, and cultural center of Coastal Virginia, Norfolk has been rated a top place to live, work, play, and raise a family by numerous publications. Working for the City of Norfolk is an opportunity to make a real difference in the lives of others. With our commitment to competitive pay and a strong retirement package, you can do good for your community and do well for yourself. Join a caring workplace that proudly celebrates uniqueness, authenticity, and a shared commitment to improving the lives of our residents.
Join Norfolk's Department of Budget & Strategic Planning to make a difference in our dynamic and diverse community. A career with the Department of Budget & Strategic Planning puts you on a rich and rewarding professional path in local government. CivicLab is a division of the City of Norfolk's Department of Budget and Strategic Planning that uses data science, process improvement, and transparency to create a culture of innovation and efficient public services.
The Department of Budget and Strategic Planning is seeking to hire a Data Analyst to join its Open Data Program, which leads the city's initiative to promote transparency through the publication of data. This role consists of the technical responsibilities of automating the collection and publication of data, as well as the communications responsibilities of ensuring the data is accessible and understandable. It will also assist other teams and departments with more general data analysis work as needed.
Department Hiring Salary Range: $68,675 - $78,976
Essential Functions
Essential functions include but are not limited to:
- Build scripts using Python to automate the extraction, load, and transformation (ELT) of internal city data to the public-facing open data portal
- Conduct data quality checks to ensure that data is accurate, consistent, and understandable
- Produce charts, reports, and documentation to communicate city data to non-technical audiences
- Work with subject matter experts in all city departments to understand the importance of their data and how it is structured
- Encourage the use of innovation, automation, and data-informed decision-making across the city by providing consultations and delivering presentations to city staff
- Assist in developing and updating guidance on topics such as data sharing, data privacy, and generative AI
Education/Experience
Work requires broad knowledge in a general professional or technical field. Knowledge is normally acquired through four years of college resulting in a Bachelor's degree or equivalent. Preferred academic coursework in Computer Science/Data Science/Statistics or related area of study.
Three years' experience in data analysis or related field, or an equivalent combination of education and experience
Additional preferred experience:
- Extensive programming experience in Python, with a focus in data analysis libraries such as Pandas and Polars
- Experience working with data from a variety of sources, including SQL databases and external APIs
- Experience creating data visualizations in tools such as Power BI
- Familiarity with working with sensitive data
- Familiarity with related fields such as GIS, statistics, and machine learning
Additional Information & Requirements
Work Location: 810 Union Street, Norfolk, VA 23510
Work Hours: Monday through Friday, 8:30AM - 5PM
Signing Bonus: This position is eligible for a one-time $5,000 signing bonus for applications received on or after February 22, 2022. The signing bonus will be paid in two (2) increments: $2,500 upon completion of 60 days of employment, and $2,500 upon completion of your probationary period. To receive the signing bonus, you must be an active employee in good standing.
- Regular full-time and permanent part-time employees may receive paid holidays, vacation and sick leave, employer paid pension plan, basic life insurance, voluntary participation in medical and dental, Section 457 deferred compensation, long-term disability, optional life insurance for self, spouse and children, medical and dependent care reimbursement plans, access to membership in credit union and employer provided parking.
- Special project/grant employees are generally eligible for the same benefits of regular full-time employees; however, retirement, life insurance and participation in health plans vary depending upon funding and authorization.
- Temporary/seasonal and part-time employees are generally only eligible for employer provided parking and access to membership in credit union.
- Retirement
If you are hired January 1, 2022, or after to a position with Virginia Retirement System (VRS) benefits, you will be required to contribute five percent (5%) of your salary toward your retirement benefit. This will be a pre-tax payroll deduction.
- The Tuition Assistance Program is established to encourage employees toward continued self-development and education. Permanent full-time and permanent part-time classified, unclassified permanent, full-time special projects, and constitutional employees who have completed six months continuous service will be eligible to apply. The applicant's school of enrollment must be an accredited institution.
NOTE:
The benefits described above are broad generalizations. The specific benefits that an employee may be eligible for are governed by City regulations, as applicable to job type.
Non-City
Positions listed with a job type designation of "Non-City" are not subject to the benefits descriptions above. Refer to the content of the job posting for information regarding these positions.
01
The following Supplemental Questions are specific to the position for which you have applied to assist the hiring manager in screening applications for specific experience being sought. Please be specific in answering these questions as they will be used to evaluate which applications will be given further consideration in the process. Do not answer "see resume" or "see application" as these are not valid answers. Please note that if you are invited to be interviewed by the department, your responses to the following questions may be subject to verification.
- I understand and will answer the following supplemental questions completely and thoroughly.
02
Please select the highest level of education you have completed.
- High School Diploma/GED
- Some College (6 months or more)
- Vocational/Technical Degree
- Associate's Degree
- Bachelor's Degree
- Master's Degree or higher
03
How many years of experience do you have using Python for data analysis?
- Less than 1 year
- 1-2 years
- 2-3 years
- 3-5 years
- More than 5 years
04
Do you hold a bachelor's degree or higher in Computer Science, Data Science, Statistics or related area of study?
- Yes
- No
05
Which of the following data sources and data types are you experienced with? (Select all that apply)
- GIS
- SQL Databases
- Web-based APIs
06
Do you have experience presenting technical concepts to a non-technical audience?
- Yes
- No
07
Describe your experience presenting technical concepts to a non-technical audience.
08
Which data analysis libraries/languages do you have experience programming in? (Select all that apply)
- Pandas
- Polars
- R
- Other
09
Do you have experience creating data visualizations in tools such as Power BI?
- Yes
- No
10
Please indicate your veteran status. (A copy of your long form DD-214 may be required)
- I am not a Veteran
- I am a Veteran
- I am a Disabled Veteran
11
Are you a current or previous City of Norfolk employee?
- Yes - I am a current City of Norfolk Employee
- Yes - I am a previous City of Norfolk Employee
- No - I am not a previous or current City of Norfolk employee
12
If you were referred for this position by a current City of Norfolk employee, please provide the employee's full name, department, and job title. If not, please indicate by typing "N/A."
Required Question