Data Analyst

Data Analyst

Salary

$30.88 - $39.43 Hourly

Location

Lincoln, NE

Job Type

Full time/probationary or status

Job Number

202600468

Department

Transportation & Utilities Department

Opening Date

09/01/2026

Closing Date

9/13/2026 11:59 PM Central

• Description
• Benefits
• Questions

Job Posting Information

Data Analyst

Transportation & Utilities (LTU)

Join a department that's investing in smarter tools, clearer reporting, and stronger data foundations. As LTU's Data Analyst, you'll collaborate with staff across LTU to maintain high-quality data, refine reporting processes, and develop visualizations that help people make better decisions.

Nature of Work

Under general supervision, the Data Analyst performs essential technical and analytical duties to support data management, reporting, documentation, and process improvement across LTU. This role ensures departmental data is accurate, accessible, well-documented, secure, and used effectively to support operations.

What You'll Do

• Maintain and update departmental databases, spreadsheets, electronic records, and reporting files to ensure accuracy, reliability, accessibility, and proper documentation.
• Collect, organize, verify, and analyze data from multiple sources; develop and improve reports, dashboards, and spreadsheets using Excel, Power BI, and other Microsoft tools.
• Translate complex data into clear charts, dashboards, summaries, and recommendations for both technical and nontechnical audiences; support staff in understanding and using departmental data.
• Document data processes, maintain SOPs, identify workflow inefficiencies, and assist with testing and implementing process improvements and automated solutions.
• Demonstrate professionalism through dependable attendance, positive working relationships, initiative, independent work, and completion of required training and development activities.

Minimum Qualifications

Graduation from a four-year college or university with major course work in computer science, research methods, statistics or related field and two years of experience in research or analysis; or any equivalent combination of training and experience that provides the desirable knowledge, abilities and skills.

We value each City of Lincoln employee and one way we demonstrate this is by providing an attractive and competitive total compensation package that adds value to our employees professional and personal lives. The following benefits are available for this position:

• Pay increases are available upon completion of the 6-month new employee probationary period, and annually thereafter based on performance.
• We encourage a healthy work-life balance by offering 11 days of vacation leave and 12 days of sick leave annually that you begin accruing upon hire; plus 11 paid holidays and 2 personal convenience days.
• All medical, dental, and vision benefits for you and your family begin the first of the month following hire, no need to wait!
• 30 days of Paid Parental Leave
• Employee Assistance Programs offering work/life services, wellness coaching, short-term counseling, legal assistance, and financial coaching.
• Up to 4 days of Funeral and Bereavement Leave
• $70,000 of Life Insurance
• $1,250 of Tuition Reimbursement
• 401(a) Retirement Plan. If you make a 7% contribution, the City will contribute 9%
• Employer provided Post Employment Health Plan for eligible medical expenses that occur after you leave City employment.
• Optional benefits include:
• Medical and/or Dependent Care Flexible Spending Accounts
• Allstate Voluntary Plans
• Supplemental Term Life
• Deferred Compensation Plans

01

I understand that applicants will be screened based upon the information listed on their application and their responses to all of the following Supplemental Questions. All employers, work and volunteer experience, and education described in the following Supplemental Questions must also be listed on the application. A resume cannot be used as a substitute for any part of the application or supplemental questions. I understand that failure to list all employers and education, and to describe related work duties on the application and Supplemental Questions could be cause for rejection based on insufficient information.

• Yes
• No

02

Describe your experience maintaining databases or spreadsheets, including entering and verifying data from multiple sources. How did you ensure accuracy and readability?

03

Provide an example of organizing complex raw data to help answer questions and guide decisions. What were your steps to clean the data, how did you make it reproducible, and what tools did you use?

04

Describe a dashboard or report you developed using Excel, Power BI, or similar tools. What problem did it solve, who used it, how did you maintain it, and how did you measure success?

05

Describe a time you identified data inconsistencies or errors. How did you identify the error, and what steps did you take to resolve and communicate these findings?

06

Provide an example of translating complex data into a clear, understandable output for nontechnical audiences. What made your communication effective?

07

Describe a workflow inefficiency you identified and improved. How did you communicate this change, document it for future users, and ensure adoption?

08

Explain how you have trained staff on reporting tools or supported them in using departmental data. What methods were most successful?

09

Describe how you demonstrate professionalism, dependability, and initiative in your work environment. Include how you maintain positive working relationships.

Required Question

Employer City of Lincoln/Lancaster County

Address 555 South 10th Street, Room 302

Lincoln, Nebraska, 68508

Phone (402) 441-7597

Website http://agency.governmentjobs.com/lincolnne/default.cfm