Department Intern – Software Engineering

Salary: $55,910.40 – $71,552.00 Annually

Location : Westminster, CO

Job Type: Full-time Benefited, 40 hours/week (1.0 FTE)

Job Number: 23-00236

Department: Information Technology

Division: 23 Software Engineering

Opening Date: 07/31/2023

Closing Date: 8/14/2023 8:30 AM Mountain

POSITION PURPOSE / IMPORTANT APPLICATION INFORMATION
The Department Intern-Software Engineering position is an entry-level technical position in the Information Technology Department. Work involves performing basic programming, testing, implementation, documentation, reporting, and troubleshooting for city computer applications and databases including the city’s web sites. Work is performed under the general direction of the Lead Software Engineers. The position is intended to provide a professional opportunity to work in all areas of the Software Engineering Division, for up to three (3) years, in a municipal government setting.

The full salary range for this position is stated above. The starting range of pay is dependent on qualifications and experience of each individual candidate. The City of Westminster offers a bonus of up to $1,500 per year depending on the employee’s fluency in Spanish, Hmong, Laotian, and/or American Sign Language (ASL).
ORGANIZATIONAL COMPETENCIES AND CULTURAL VALUES/GENERAL COMPETENCIES
The City’s work culture encourages passionate, positive and enthusiastic employees who, along with our City Council and City Manager, are strong supporters of our mission: Westminster’s purpose is to provide core services and foster economic resilience to give our community the opportunity to thrive. Our core values are embodied in our SPIRIT (Service – Pride – Integrity – Responsibility – Innovation – Teamwork).

This position supports the goals of the Information Technology Department, which delivers exceptional value and quality of life through the deployment and support of innovative technologies and SPIRIT.

Every employee is accountable to:

• Demonstrate a high level of customer service; encourage others to focus on the customer; foster an environment where customer service is a priority
• Communicate with customers to ensure that where possible they are satisfied and that their needs are being addressed; solicit and evaluate customer feedback
• Act as an ambassador by understanding and fostering the organization’s mission and vision
• Exhibit pride in self, the department, the city, and the community; conduct self in a professional manner
• Demonstrate integrity and build trust through credibility, reliability, commitment, loyalty and ethical behavior
• Address difficult or contentious issues in a constructive manner
• Support/promote change; demonstrate flexibility and takes calculated risks when appropriate
• Participate in personal growth opportunities and attend trainings designed to enhance capacity to bring new skills and ideas to the job and the organization
• Work to continuously improve the efficiency and effectiveness of the service or product being delivered
• Demonstrate support for team efforts by accepting new roles and responsibilities, and helping others achieve objectives
• Value diversity; demonstrate an awareness of differences; demonstrate sensitivity and adapt behaviors and communication to accommodate these differences

GENERAL COMPETENCIES
Citywide – Every employee in this position is accountable to:

• Establish effective interpersonal relationships through honest, open communication and follow-through on commitments
• Recognize personal strengths and weaknesses and target areas for personal self-development
• Demonstrate initiative in performing job tasks
• Exhibit problem-solving skills leading to sound judgment and quality decisions
• Achieve goals, handle assigned workload and new assignments effectively; demonstrate an ability to work independently
• Communicate effectively with individuals and groups using clear and concise verbal and written communications
• Demonstrate accountability for work and take ownership in job performance
• Demonstrate concern for the accuracy and quality of work; take steps to correct mistakes and improve the overall product

Job Specific – Every employee in this position must be able to:

• Respond to user requests and concerns in a prompt manner
• Gain knowledge of government software applications such as Accounting, Public Safety, Human Resources, and Utilities
• Perform programming in Microsoft SQL, SSIS, SSRS and .NET environments
• Be familiar with the Microsoft SQL Server administration and operation
• Demonstrate excellent judgment, creativity, and problem solving
• Demonstrate excellent analytical skills and concentration for long periods of programming
• Design and build efficient normalized database structures in Microsoft SQL Server
• Design and build reports using Microsoft SSRS and Microsoft Power BI
• Demonstrate technical knowledge of Windows and Windows Server
• Work effectively during stressful situations and events
• Communicate technical concepts and technology solutions to management and application users clearly, concisely and effectively

Leadership – Every employee in this position is accountable to:

• Foster a participatory organizational climate that is open, positive, reinforcing and supportive
• Encourage employees to be accountable for their work and take ownership in what they do
• Demonstrate leadership and courage by making or supporting decisions that reflect the organizational mission and goals even when the decision may be unpopular to some
• Demonstrate collaboration and conflict resolution skills with other departments and employees
• Be familiar with the Microsoft SQL Server administration and operation
• Design and build efficient normalized database structures in Microsoft SQL Server
• Demonstrate technical knowledge of Windows and Windows Server

JOB SPECIFIC FUNCTIONS
Essential Job Functions, Duties, Responsibilities and Tasks
1. Assists the Software Engineering Team with design, coordination, and maintenance for the overall usability of the City’s software applications:

• Assists in providing application support, development, analysis, design, programming, testing, implementation, and maintenance using tools such as Microsoft Visual Studio (especially .NET), Microsoft SQL, SSRS, SSIS, Microsoft Power BI and Crystal Reports
• Assists in support, development, testing, implementation, and maintenance on the City’s websites, Content Management System (CMS), in-house developed applications, accounting, public safety, human resources, and utilities applications
• Assists in supporting upgrades, monitoring, and troubleshooting the Microsoft SQL Server database supporting the application systems
• Prepares user technical documentation on new and maintained applications
• Writes new and modifies existing applications
• Assists Software Engineering Team and departments with evaluation and selection of off the shelf applications
• Establishes interface requirements and develop applications to enables data sharing between applications and various databases
• Provides training on new and enhanced applications for users
• Assists with application software support for various applications, including sales tax, utility billing, finance, etc.

2. Communicates with and supports customers and Information Technology staff:

• Provides support and service to our internal and external clients
• Communicates to users, both verbally and in writing, updates on projects and other tasks as necessary
• Prepares user documentation for applications
• Provides written updates of project status for Lead Software Engineer and customers as requested
• Under IT, works City Departments and Divisions to find solutions to improve business efficiencies
• Scopes, communicates and coordinates projects with project stakeholders

3. Maintains and supports all Information Technology Department and City policies and practices:

• Updates an automated request tracking system on a weekly basis
• Compiles monthly and quarterly activity statistics, user feedback
• Evaluates cost effectiveness of requests and prepares written recommendations for the Lead Software Engineer, as requested
• Develops, creates and/or updates project plans as required
• Participates in weekly planning and status meetings with Software Engineering Team
• Attends training classes and seminars related to job responsibilities
• Adheres to all established City programming standards and procedures

4. Communicates successfully and maintain effective relationships:

• Prepares effective written communications, manuals and training for users
• Works and communicates effectively with other department members as well as the City and public in a positive collaborative manner
• Provides training on new and enhanced applications for users

5. Maintains regular and punctual attendance

Other Duties and Responsibilities
1. Incumbent is accountable for all duties of this job; other projects and responsibilities may be added at the City’s discretion
POSITION REQUIREMENTS/WORKING CONDITIONS/PRE-EMPLOYMENT REQUIREMENTS

Education, Experience, Skills, Formal Training, Licenses and Certifications
Required:

• Four (4) years of college level course work in Computer Science, Computer Information Systems, Information Management, or related field
• Some experience in programming, upgrading, and administration of computer applications
• Ability to work with any of the following: .NET, Scripting, SQL, SSRS, SSIS, Microsoft Power BI and interface development
• Experience or education related to systems analysis and design
• Ability to pass the Criminal Justice Information Services (CJIS) background check

Preferred:

• Experience with Visual Studio, Microsoft SQL, Microsoft SharePoint, SSRS, SSIS, and .NET development language
• Training or experience in developing extensive GUI applications
• Developing and maintaining SQL databases and applications
• Experience with municipal government software packages

Any equivalent combination of education, training and experience, which would provide the required knowledge and skills, may be considered.

Physical Requirements
Work is sedentary in nature and requires sufficient physical stamina and strength for:

• Constant sitting to perform daily tasks; occasional walking through a multilevel facility to retrieve information; frequent standing sometimes for extended periods
• Frequent squatting, reaching above shoulder and twisting to file documents and lift supplies and material; occasional bending, kneeling, climbing, balancing and reaching below shoulder to store documents, material and supplies
• Constant light grasp, fine manipulation, and handling to perform daily duties; occasional firm grasp to safely use equipment
• Frequent lifting, carrying, push/pulling of up to ten (10) pounds to move material and supplies; occasional lifting, pushing/pulling of up to twenty-five (25) pounds with dollies and carts

WORKING CONDITIONS
Work is constantly performed indoors. This is primarily sedentary office work. Must demonstrate the ability to meet the physical demands of the job including the ability to retrieve information from various locations in the office when needed. Exposure to periods of high activity and high stress under demanding conditions. The position requires a great deal of communication with City employees, the public, and outside agencies.

Materials and Equipment Directly Used
Personal Computer and printer, telephone, Dell servers running the latest versions of Microsoft Windows Server, Visual Studio, .NET, MS SQL Server, and MS Windows.

PRE-EMPLOYMENT REQUIREMENTS

• Background checks will include employment references and criminal history and when applicable, credit check, driver’s license record, education verification
• Criminal Justice Information Services (CJIS) background check
• Pre-employment drug screen
• Must be legally entitled to work in the United States

The City of Westminster offers a comprehensive benefit package including:

• Health and Dental
• Flexible Spending
• Pension/ Retirement Plans
• Term Life Insurance
• Long-term Disability
• Survivor Benefits
• Wellness Program
• Education and Training Reimbursement
• General leave that provides vacation, holidays, and illness leave

For a more detailed overview of our General Non Exempt employee benefit package:

The City of Westminster does not participate in the Social Security system. In lieu of social security contributions, the city contributes to a 401(a) defined contribution plan on your behalf.

401(a) Contribution Rates:
Employee Mandatory Contribution: 11% of your base pay. Contributions are pre-tax and fully vested.
Employer Contribution: 11.25% of your base pay.

Employer Contribution Vesting Schedule

• Less than 3 years – 0%
• 3 years – 60%
• 4 years – 80%
• 5+ years – 100%

01

Do you have four (4) years of college level coursework in Computer Science, Computer Information Systems, Information Management, or a related field?

• Yes
• No

02

Please list any certifications you have that would be related to this position. If none, please respond with N/A.

03

Do you have experience in programming, upgrading, and administration of computer applications?

• Yes
• No

04

If you answered yes to having experience in programming, upgrading, and administration of computer applications, please briefly describe your experience. If you answered no, please respond with N/A.

05

Please indicate which of the following technologies you have experience with (check all that apply):

• .NET/C#
• Microsoft SQL
• Microsoft Power BI
• Microsoft SQL Server Integration Services (SSIS)
• None

06

Do you have experience and/or education related systems analysis and design?

• Yes
• No

07

If you answered yes to having experience and/or education related to systems analysis and design, please briefly describe your experience. If you answered no, please respond with N/A.

08

Do you have computer-related project management experience?

• Yes
• No

09

If you answered yes to having computer-related project management experience, please briefly describe the project(s), your role, and the outcome. If you answered no, please respond with N/A.

10

Please check software/applications where you have one (1) or more years of experience (check all that apply):

• Microsoft SQL Server Reporting Services (SSRS)
• .NET Development Languages
• Visual Studio
• Git
• Azure DevOps
• Microsoft SQL Server
• JDEdwards
• City Works
• Computer Aided Dispatch (CAD)
• Public Safety Software
• Create!Form Scripts
• ESRI Arc IMS, Arc Server, ArcGIS
• None of the above

11

Why are you interested in this internship with the City of Westminster?

12

This is not a fully remote position and will require the ability to work on-site at Westminster City Hall for at least 50% of the work week (or more at the need and discretion of the supervisor). Are you willing and able to meet this requirement?

• Yes
• No

13

This is a temporary internship position (full-time hours with benefits) that will last up to and no more than three (3) years. By checking yes below, you are acknowledging that you understand, that if you are selected for this Department Intern position in Information Technology, the position will last no longer than three years.

• Yes
• No

Required Question