Water-Business Information Analyst

City of Denton; Denton (TX); On-site; USD 65,000 - 105,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Retirement plan

Paid vacation days

Job summary

City of Denton seeks a data-driven professional to analyze, develop, and maintain division applications and systems that support strategic outcomes.

The role collaborates with multiple departments, provides reports to leadership, and drives best-practice analytics and data governance across programs.

Qualifications

• Bachelor’s degree or equivalent with data-focused coursework or experience.
• Proven ability to compile and analyze data from multiple sources.
• Experience supporting business solutions and reporting for multiple departments.

Responsibilities

• Lead data analysis and reporting to support division strategies and objectives.
• Coordinate with Technology Services on back-end configuration and project facilitation.
• Develop and monitor asset management and reporting processes.
• Provide end-user training and documentation for analytics tools.

Skills

SQL

Data analysis

Reporting

Project coordination

Education

Bachelor's degree in Computer Science or MIS or related field

Tools

MS SQL

Power BI

Smartsheet

Job description

Responsible for the ongoing analysis, development, improvement, and maintenance of division applications and systems to support division strategies and outcomes. Utilize analytical processes to evaluate and provide data reports on internal stakeholder projects and processes to deliver business intelligence and strategic recommendations.

ESSENTIAL FUNCTIONS

Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

DUTIES

• Act as lead for new project initiative and coordinate with Technology Services on back-end configuration changes;works as a facilitator of projects and process development for all aspects of the assigned systems and act as technical resource to division.
• Compile, audit, analyze, translate, and ensure data is reliable and valid; provide business data reports to support division strategies and objectives.
• Collaborate with internal stakeholders to identify business needs; support business solution implementation with internal and external stakeholders.
• Evaluate and provide recommendations, design, and implement process changes, and monitor progress and provide results.
• Identify and work with internal and external stakeholders to resolve application issues with assigned software; troubleshoot and document the issue and its resolution.
• Design, develop, guide, and manage infrastructure asset management programs including the development of concepts, procedures, guidelines, analytical methods, decision-making systems, risk mitigation, data collection, and best practices.
• Collaborate with internal and external stakeholders to integrate new systems and processes with existing ones to ensure systems meet long-term goals and objectives.
• Review, create, maintain, administer, and monitor standard operating procedures, work plans, performance standards and goals, and activities to ensure department/division objectives are achieved; notify leader when data trends do not support identified and/or expected outcomes.
• Provide technical expertise and assistance to other department staff.
• Provide end-user training developed processes, software, and systems; ensure users understand the relationship between operational practices and report outputs.

CUSTOMER SERVICE

• Provide data to leadership to support performance goals and training.
• Compile data, create and produce data audits and/or reports for internal and external stakeholders.
• Assist in the testing of new versions, products, software upgrades, or processes for all modules within the utility billing application and reporting systems.
• Assists with special projects, as appropriate.

ELECTRIC

• Provide staff with first line troubleshooting of issues and how-to guidance on applications.
• WriteRequest for Proposals (RFPs) for new Electric applications; prepare paperwork needed for purchasing upgrades/new applications.
• Perform querying of MS SQL databases connected to Electric applications; provide results as appropriate.
• Administer Electric front-end components of applications and document related processes.
• Participate in Electric software selection, front-end integration, testing, and implementation.
• Oversee Electric front-end licensing for Electric department applications.

ENGINEERING

• Assist in the testing of new versions, products, software updates, or processes for all Capital Improvement system modules.

FINANCE/DRAINAGE

• Oversee implementation and administration of asset management software; audit data to ensure quality data entry, accuracy of related GIS records, maps, asset data, and condition information.
• Collaborate with internal stakeholders to ensure syncing and regular software updates; provide analysis of the data obtained in reporting.
• Monitor and analyze performance metrics, including but not limited to, operational capacity, operational quality and efficiency, maintenance plans, the pavement management program, and traffic management program.
• Coordinate planning and facilitation of status updates for upcoming City projects between internal departments including but not limited to Water, Wastewater, Streets, Drainage, Bike Lanes, Denton Municipal Electric and Capital Projects.
• Assist in the planning, research, and implementation of special projects for all lines of service in Public Works.

FINANCE

• Assist in the testing of new versions, products, software updates, or processes for all finance system modules.
• Oversee Finance related Smartsheet projects, dashboards, and other projects, as assigned.
• Evaluate new visualization tools and perform research on best practices, as needed.

FIRE

• Develop tracking and trending tools to assist with forecasting to ensure achievement of Fire Department performance goals.
• Evaluate new visualization tools, perform research on best practices, as needed.
• Assist in the testing of new versions, products, software upgrades or processes for all modules within reporting systems.
• Identify project tasks; lead and/or assist with project timeline estimations.
• Coordinate projects with internal and external stakeholders and end users for deadline requirements.
• Assist with payroll functions and operations to include but not limited to serving as back-up, as needed.
• Assists with special projects, as needed.
• Serves as back up to other positions, as needed.

POLICE

• Assist in the testing of new versions, products, software updates, or processes for all Police Department system modules.
• Administer Police Department systems to ensure user access is appropriate and system updates meet compliance requirements.
• Collaborate with internal and external stakeholders on systems including, but not limited to, resolving technology-related issues, vendor evaluations, providing technical expertise and assistance, and cell phone troubleshooting and upgrades, as appropriate.
• Oversee Police Department related Smartsheet projects, dashboards, and other projects, as assigned.
• Develop the Police technology annual operating budget and track operational expenditures; advise and approve small technology purchases.
• Prepare, create, and maintain relevant information throughout the procurement process including, but not limited to, Technology Governance Committee reviews, Solicitation Review Committee meetings, agenda items, HUB checks, purchase orders and payments.
• Provide contract management and compliance oversight
• Collaborate with internal and external stakeholders to define scope, objectives, budget, and deliverables ensuring alignment and proper prioritization with business goals; evaluate and provide recommendations on new systems to meet business goals.
• Represent the Police Department in Texas Department of Transportation User Group Committee and be the primary point of contact (POC) for the Police department.

SUPERVISORY/BUDGET RESPONSIBILITIES

• None.

OTHER DUTIES

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

EDUCATION, EXPERIENCE, AND LICENSES/CERTIFICATIONS

• Bachelor’s Degree from an accredited college or university in Computer Science, Management Information Systems Business Administration, Business Computer Systems, or related field; and,
• Three (3) years’ experience in application administration, computer programming, data management, information systems, or related field,

OR

• Any combination of related education, experience, certifications, and licenses that will result in a candidate successfully performing the essential functions of the job.

REQUIRED SKILLS/ABILITIES

• Knowledge of applicable Federal, State, and Local Government laws, ordinances, and regulations.
• Knowledge of SQL and relational databases.
• Knowledge of project management principles, including the ability to review and recommend project improvements based on scope and budget.
• Knowledge of effective research-based strategies, theories, techniques, and methodologies.
• Skill in moderate-to-complex problem solving; identifying problems and reviewing related information to develop and evaluate options and implement solutions.
• Skill in performing mathematical and statistical calculations with accuracy.
• Skill at the college level, in reading, writing, speaking, and interpersonal communications, including principles of English and grammar usage.
• Skill at the intermediate level, working with Microsoft Office 365, and other software systems to complete work.
• Skill in providing exceptional service to internal and external customers.
• Skill in creating new concepts and promoting innovation through continuing education and professional networking.
• Ability to communicate effectively, both in oral and in written forms, speak publicly, and listen intently to other points of view.
• Ability to work independently to manage multiple work tasks while balancing competing priorities with attention to detail and in a fast-paced environment.
• Ability to establish and maintain effective interpersonal relationships.
• Ability to create reports, handle records and complex situations of a confidential nature.
• Ability to handle difficult and stressful situations with professional composure and confidentiality.
• Ability to independently resolve technical matters that have a noticeable impact on operational activities.
• Ability to decide the appropriate architecture for relational databases, managing their application and ensuring data integrity.
• Ability to effectively communicate results of analyzed statistical model information to a broad audience including internal and external audiences.
• Ability to support controversial positions, negotiation of sensitive issues and/or presentations with internal and external stakeholders.
• Ability to motivate,mentorand trainthroughdirect and indirect influence.
• Ability to develop, understand, interpret, and apply rules, policies, and procedures operations.
• Ability to prepare budget documentation and to monitor expenditures to implement fiscal control and maintain budget compliance.

CONDITIONS OF EMPLOYMENT

• If Electric - Must have and maintain a valid Class “C” Driver’s License and valid state required minimum automobile liability insurance prior to employment (must obtain Texas Class “C” driver’s license and state required minimum automobile liability insurance within 90 days of hire per state law).
• Must pass a drug test, criminal history background check, employment history verification, and social security number verification.
• If Electric - Must pass a driver’s license check.
• If Police, Must meet civilian hiring standards of the Denton Police Department.

SAFETY

• Ensure equipment is in safe operating condition; perform preventive maintenance on tools and equipment, as appropriate and/or notify leadership immediately of needed repairs.
• Follow established safety procedures and techniques to perform job duties, including lifting and climbing; operate tools and equipment according to established safety procedures.
• Promptly report unsafe conditions in the work area and/or any conditions that are not immediately correctable to leadership.

WORKING CONDITIONS/PHYSICAL REQUIREMENTS

• Safety Sensitive (Subject to random drug testing): No.
• Tools/Equipment Used: Standard office equipment, including computer and peripherals.
  • If Customer Service -Internet access to access the City of Denton secure virtual network.
  • If Electric – Occasional work with surveying and staking equipment.
• Posture: Prolonged sitting and standing; occasional stooping, squatting, kneeling, bending, pushing/pulling, and twisting.
• Motion: Frequent repetitive hand motions, including keyboarding and use of mouse; occasional reaching.
• Lifting: Lifting and carrying (less than 15 pounds).
  • If Electric – Lifting no more than 20 pounds and carrying up to 10 pounds.
• Environment: Works in an office setting office; occasionally requires irregular and/or prolonged hours.
  • If Customer Service - Works in an office and/or home-office setting with dedicated work area free from interruptions.
  • If Electric – Works in an office setting and outside with exposure to sun, heat, cold and inclement weather, noise, chemicals, odor, dust, and rough terrain.
• Travel: Travels to City of Denton buildings and professional meetings as required.
• Attendance: Regular and punctual attendance at the worksite is required for this position. Must be able to work after normal business hours, as needed.
  • If Customer Service -May work from home for as many as 75% of scheduled hours with supervisor approval, based on business necessity.
  • If Electric – Must be able to provide 24/7 support for critical electric applications on a rotating shift.
• Mental Demands: Maintains emotional control under stress; works with frequent interruptions.

CORE VALUES

• Inclusion
• Collaboration
• Quality Service
• Strategic Focus
• Fiscal Responsibility

TOP TIER BENEFITS

• Medical, dental, and vision coverage in addition to life and disability insurance plans
• Employee Health Clinic
• Paid Vacation Days and Paid Holidays
• Retirement Plan

EEO STATEMENT

The City of Denton is an equal opportunity employer. It is the policy of the City of Denton to prohibit discrimination and harassment of any type and to afford equal employment opportunities to employees and applicants without regard to any protected class, status, characteristic, or activity. All employment decisions, including decisions regarding recruitment, selection, hiring, compensation, benefits, training, advancement, discipline, discharge, and other terms, conditions, and privileges of employment are made without regard to any lawfully protected class, status, characteristic, or activity.

ADA/EOE/ADEA

This job description is not an employment agreement, contract agreement, or contract. Management has the exclusive right to alter this job description at any time without notice.