Job Information
City of Durham Sr. Business Systems Analyst in Durham, North Carolina
Sr. Business Systems Analyst
Print (https://www.governmentjobs.com/careers/durhamnc/jobs/newprint/4877058)
Apply
Sr. Business Systems Analyst
Salary
$70,284.00 - $108,951.00 Annually
Location
Durham, NC
Job Type
Full time with benefits
Remote Employment
Flexible/Hybrid
Job Number
25-05374
Department
Water Management
Opening Date
03/20/2025
Closing Date
4/3/2025 11:59 PM Eastern
Description
Benefits
Questions
Position Description
Work, Serve, Thrive. With the City of Durham
Advance in your career while making a real difference in the community you serve.
Hiring Range: $70,284 - $78,214
Hours: 8:00 a.m. -5:00 p.m.
The City of Durham’s Department of Water Management (DWM) (https://www.durhamnc.gov/944/Water-Management) wants YOU to join our team of more than 380 talented and dedicated employees that provide critical water and sewer services for Durham’s 309,000 plus residents. Not only do we deliver the Best Tasting Water in the state to our customers each and every day, but we also make sure that the wastewater leaving our facilities is carefully treated to protect the environment. We have a wide-ranging variety of positions open to match your skill set – mechanics, engineers, maintenance specialists, technicians, customer billing techs, and much more. If you have a passion for managing vital water resources, protecting the environment, providing excellent customer service, and keeping the water and wastewater in the pipes, bring your skills and talent to Durham!
The Senior Business Systems Analyst will collaborate with cross-functional teams to gather and define business requirements, transforming them into efficient SQL queries and Power BI dashboards that drive informed decision-making. This role will involve designing, creating, and maintaining reports and dashboards while ensuring the accuracy, integrity, and consistency of all data presented. The analyst will conduct thorough data analysis to uncover trends, insights, and areas for process optimization, delivering findings through well-crafted visual reports and presentations to key stakeholders. Additionally, the analyst will work with the utility technology team to establish and implement data cleansing strategies, focusing on data validation, enrichment, and standardization.
In addition to managing ongoing projects, the Senior Business Systems Analyst will contribute to the planning and execution of legacy system cleanup efforts, ensuring alignment with established timelines, resource distribution, and key objectives. They will act as the main point of contact for technology projects, fostering effective communication between business teams and technical departments to ensure project success. The role will also involve overseeing any ad hoc or unanticipated projects, ensuring that these initiatives are thoroughly evaluated, planned, and executed with the same level of precision and quality as regular projects.
Duties/Responsibilities
Collaborate with team members to gather business requirements and translate them into SQL queries and Power BI dashboards.
Design, develop, and maintain reports and dashboards to support business decision-making.
Analyze data to identify trends, insights, and opportunities for process improvements.
Ensure data accuracy, integrity, and consistency across all reports and dashboards.
Communicate findings and insights clearly to stakeholders through visual reports and presentations.
Collaborate with the utility technology team to develop and implement data cleansing strategies, including data validation, enrichment, and standardization procedures.
Participate in the development and enactment of detailed plans for legacy system cleanup, including timelines, resource allocation, and key milestones.
Serve as the primary point of contact for existing technology projects, facilitating communication between business units and technical teams to address concerns and ensure project success.
Manage additional, unexpected projects that arise, ensuring they are assessed, planned, and executed with the same level of attention to detail and quality as ongoing projects.
Minimum Qualifications & Experience
Bachelor’s degree Or equivalent in computer science, information technology, or directly related field,
Five years of related professional information technology experience.
Proficiency in SQL to extract, manipulate, and analyze data from relational databases.
Experience with Power BI or another data visualization tool to design, develop, and maintain interactive dashboards and reports for data-driven decision-making.
Additional Preferred Skills
Advanced Excel skills: Proficient in using complex formulas, pivot tables, macros, and other advanced Excel features.
Experience working in a utility organization, with a solid understanding of industry processes and operations.
Knowledge of ArcGIS or other geographic information systems (GIS), including the ability to analyze and visualize spatial data to support business decisions.
Proficiency in Python, with experience in data manipulation and simple machine learning algorithms
Benefits – General Full-Time Employees
12-13 paid holidays per year
13 standard work days of vacation per year
13 standard work days of sick leave per year, which accumulates indefinitely; sick leave may be used toward early retirement
2 weeks paid military leave per year
Medical, dental, vision, and supplemental life insurance plans
State and City retirement plans
Short and long term disability plans
Paid temporary disability leave for specified conditions
City contribution of 13.6% into the N.C. State Retirement System
Paid funeral leave
Employee Assistance Program - personal and family counseling
Paid life insurance equal to annual salary
48 hours for volunteer work each year*
4 hours parental leave each year
Workman's Compensation Insurance
457 Deferred Compensation Plans
Benefits - Part-Time (1,000 hours or more per year)
401(k) retirement plan (5.0% of salary)
State retirement plan
Benefits Part-Time (Average 30 hours per week over 12 month period)
401(k) retirement plan (5.0% of salary)
State retirement plan effective first day of the month following date of hire
Health insurance effective first day of the month following date of hire
Dental and life insurance, after one year of service
Pro-rated vacation, pro-rated sick, pro-rated floating holiday, parttime holiday pay (based on scheduled hours for that day) after one year of service
01
Where did you first hear about this opportunity?
City of Durham Website
Walk in
LOGO career event
Job fair
Employee referral
Professional organization Please list the organization in "other" box below
Internet posting Please list the specific web site in the "other" box below
Craig's List
Facebook
LinkedIn
GlassDoor
governmentjobs.com
Monster.com
Indeed.com
Employment Security Commission
Magazine/Newspaper
Other
02
If you listed "other" above please give specific web site, organization, or publication.
03
Please select your highest level of COMPLETED education.
Less than a High School Diploma or Equivalent (GED, HiSET, TASC)
High School Diploma or Equivalent (GED, HiSET, TASC)
Associates Degree
Bachelor's Degree
Master's Degree
Doctoral Degree (PhD, Juris Doctorate)
04
Please list the area of academic focus your degree is in: (such as Major, Minor or concentration).
05
How many years of related experience do you have in professional information technology?
No related experience
Less than 1 year of related experience
1 year but less than 5 years related experience
5 years but less than 9 years related experience
9 years but less than 13 years related experience
13 or more years related experience
06
How would you rate your experience level with Excel? (Such as using complex formulas, pivot tables, macros, and other Excel features)
No experience
Beginner level
Intermediate level
Advanced level
Expert level
07
How would you rate your experience level with SQL? (Such as extracting, manipulating, and analyzing data from relational databases)
No experience
Beginner level
Intermediate level
Advanced level
Expert level
08
How would you rate your knowledge level with ArcGIS or other geographic information systems (GIS)?
No experience
Beginner level
Intermediate level
Advanced level
Expert level
09
How would you rate your experience level with Python?
No experience
Beginner level
Intermediate level
Advanced level
Expert level
10
Do you have experience with Power BI or another data visualization tool?
Yes
No
11
Do you have experience working in a utility organization, with a solid understanding of industry processes and operations?
Yes
No
12
Have you used Power BI (or another data visualization tool) to design, develop, and maintain interactive dashboards and reports for data-driven decision-making?
Yes
No
Required Question