Salary: $92,560.00 – $133,705.00 Annually
Location : Westminster, CO
Job Type: Full-time Benefited, 40 hours/week (1.0 FTE)
Job Number: 23-00257
Department: Information Technology
Division: 23 Software Engineering
Opening Date: 08/21/2023
Closing Date: 9/4/2023 8:30 AM Mountain
POSITION PURPOSE / IMPORTANT APPLICATION INFORMATION
The Software Engineer I/II position is a technical professional position in the Information Technology Department supporting mission critical enterprise applications. Core responsibilities for this position include technical application support, troubleshooting, enhancements and upgrades. Work also involves developing and maintaining reports using third party and ad hoc tools, creating advanced SQL queries, technical project management, technical writing and developing data integrations between applications. In addition, responsibilities include direct collaboration with customers and vendor technical support. Work is performed independently and under the direction of the Lead Software Engineer.
The full salary range for this position is stated above. Starting wages are negotiable and dependent on the 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. Westminster is a city of beautiful, safe, well-maintained neighborhoods and destinations with a vibrant, diverse economy, rich and resilient environment and a strong sense of community belonging. 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 take 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, and 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:
- Demonstrate an understanding of software support for applications such as Customer Information Systems (CIS), Asset and Maintenance Management systems, Financial (ERP), Contract/document Management and Human Resource Information Systems (HRIS)
- Knowledge supporting systems that are cloud-based and Software as a Service (SaaS) with a focus on security, availability, and consistency
- Perform advanced development work in Microsoft SQL, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Demonstrate experience with technical Project Management for software applications including new application implementations, upgrades, and enhancements
- Knowledge of SharePoint implementations using Microsoft 365 applications, including Microsoft Teams and Microsoft Office
- Demonstrate experience using SOAP and REST approaches to API design and testing
- Demonstrate excellent judgment, creativity, and problem-solving
- Demonstrate excellent analytical skills and concentration
- Work effectively to meet goals and priorities during stressful situations and events.
- Communicate technical concepts and technology solutions to management and customers clearly, concisely, and effectively
- Respond to user requests and concerns to provide resolutions in a prompt manner
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
JOB SPECIFIC FUNCTIONS
Essential Job Functions, Duties, Responsibilities, and Tasks
1. Design, coordinate, and maintain the overall usability of the City’s major software applications:
- Assist as assigned with enterprise software support for various government applications
- Provide application support, analysis, design, testing, implementation, enhancements, and maintenance using tools such as Microsoft Visual Studio, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SharePoint and Microsoft Teams
- Perform technical project management for implementations, enhancements and upgrades
- Assists departments with evaluation and selection of new enterprise applications
- Assist as assigned with application software support for various applications that are cloud-based or Software as a Service (SaaS)
- Provide training on new and enhanced applications for users
2. Communicate with and support customers and Information Technology staff:
- Provide technical project management for enterprise applications.
- Provide software focused training materials and documentation for customers and peers
- Provide support and service to our internal and external customers
- Provide application support, analysis, troubleshooting, implementation, and maintenance with users verbally and in writing to provide development and enhancement project updates
- Prepare user documentation on applications for customers and internal IT use
- Provide written updates of project status for Lead Software Engineer and customers as required
- Work with IT and City departments and divisions to find solutions to improve business efficiencies
- Scoping, communicating, and coordinating projects with key project stakeholders
3. Maintain and support all Information Technology Department and City policies and practices:
- Update automated request tracking system daily
- Compile periodic activity statistics and user feedback
- Evaluate cost-effectiveness of requests, and prepare written recommendations for the Lead Software Engineer, as requested
- Develop, create, and/or update project plans as required
- Participate in periodic planning and status meetings with the Software Engineering Team
- Attend training classes and seminars related to job responsibilities
- Adhere to all established City and Information Technology department standards and procedures by reading and understanding such procedures
4. Communicate successfully and maintain effective relationships:
- Prepare effective written communications, manuals, and training for users
- Work and communicate effectively with other department members as well as the City and public in a positive collaborative manner
- Provide training on new and enhanced applications for users
5. Maintains regular and punctual attendance while in the office and working remotely
Other Duties and Responsibilities
- Participate in an afterhours application support, upgrades and troubleshooting as required
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:
- Graduation from an accredited four (4)-year college with major course work in Computer Science, Computer Information Systems, Information Management, or related field
- Experience supporting enterprise software applications
- Experience working with relational databases, SQL Server Management Studio and writing T-SQL queries
- Ability to pass the Criminal Justice Information Services (CJIS) background check
- Software Engineer II requires a minimum of four (4) years of directly related work experience
Preferred:
- Experience with technical project management related to software applications
- Prior experience using SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Experience using SOAP and REST approaches to API design and testing
- Experience developing and supporting SharePoint implementations through Microsoft 365 applications, including Microsoft Teams and Microsoft Office
- Experience writing technical documentation
- Experience supporting cloud solutions through Microsoft Azure
- Experience developing and supporting Power BI tools including dashboards and reports
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, pushing and/or pulling of up to ten (10) pounds to move material and supplies; occasional lifting, pushing and/or pulling of up to 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 Microsoft Windows Server, Visual Studio, C#, .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, and education verification
- 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
- General leave that provides vacation, holidays, illness leave and administrative leave
- Education and Training Reimbursement, and
- Exempt Reimbursement Program
For a more detailed overview of our Exempt and Administrative Officer 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
Please indicate your highest level of education with major course work in Computer Science, Computer Information Systems, Information Management, or related field:
- None
- Some College
- Associate’s Degree
- Bachelor’s Degree
- Master’s Degree or higher
02
Please briefly describe your education and/or certifications related to the duties of this position.
03
How many years of experience do you have with Microsoft SSIS, SSRS, and SSAS?
- No experience
- Less than two (2) years
- Two (2) to five (5) years
- Five (5) to ten (10 years
- More than ten (10) years
04
Please describe any experience you have performing technical project management functions related to software applications. If none, please respond with N/A.
05
Please describe experience you have in any of the following systems, if you have none, please respond with N/A:• Customer Information systems (CIS)• Enterprise Resource Planning (ERP) systems• Human Resource Information Systems (HRIS)• Asset and maintenance management systems• Contract/Document Management systems
06
Do you have experience writing SQL queries using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Management Studio (SSMS).
- Yes
- No
07
If you answered yes to having SQL experience, please briefly describe your experience including how long you’ve performed each of the indicated areas. If you answered no, please respond with N/A.
08
Do you have any experience using REST and SOAP approaches to API design and testing?
- Yes
- No
09
If you answered yes to having experience with API design and testing, please describe the type of experience and for how long. If you answered no, please respond with N/A.
10
Do you have experience in Microsoft Power BI analytics tool?
- Yes
- No
11
If you answered yes to having experience with Microsoft Power BI, please briefly describe your experience and for how long. If you answered no, please respond with N/A.
12
Do you have experience developing and supporting SharePoint implementations through Microsoft 365 applications, including Microsoft Teams and Microsoft Office.
- Yes
- No
13
If you answered yes to having experience with SharePoint, please briefly describe your experience and for how long you have used it. If you answered no, please respond with N/A.
Required Question