Are you an IT professional looking for a rewarding new position? The City of Littleton has an opening for a Software Engineer in our Information Services department. The Software Engineer will work on projects that affect all aspects of the city, including the Police Department, Fire Department and Public Works!
The City of Littleton offers a competitive benefits package including 21 vacation days and 10 paid holidays upon hire as well as access to the employee clinic! Flex schedules and professional development opportunities are also available upon request.
The Software Engineer will serve as a subject matter expert across the organization for researching, analyzing, creating, configuring, upgrading, and supporting the city's enterprise, third party and internally developed software systems. The Software Engineer will function as a member of a collaborative team that works to ensure the availability, performance, stability and security of the city's software environment, and will be expected to document solutions, share knowledge, provide customer service, and train others as required.
The position ensures that projects meet customer requirements and are delivered on-time, within scope, and within budget through the application of industry standard project management and change management methodologies.
- Essential Duties & Reponsibilities
The following statements are illustrative of the essential functions of the job and do not include other nonessential or peripheral duties that may be required. The organization retains the right to modify or change the duties or essential functions of the job at any time.
- Determines operational feasibility by evaluation, analysis, problem definition, requirements gathering, solution development, and proposed solutions.
- Prepares and installs solutions by determining and designing system specifications, standards, and programming.
- Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and the like based on business requirements and technical specifications that align with the System Development Life Cycle.
- Through thoughtful and knowledgeable questioning, determines the customer's requirements, and develops the software solution through studying requirements; systems flow, data usage, and processes; investigating problem areas; following the System Development Life Cycle.
- Improves operations by conducting systems analysis; recommending changes in policies and procedures; opportunities to automate and/or improve efficiency of existing business processes.
- Investigates, diagnoses and resolves application functionality related issues, and provides support and troubleshooting for the city's enterprise, internally developed and third party software systems and databases.
- Identify and implement modifications to existing applications to meet changing user requirements.
- Protects operational environment by keeping information and data confidential and secure.
- Provide technical expertise and recommendations in assessing, recommending and implementing C.O.T.S.S. (Computer off the Shelf software) systems that enhance the city's existing software environment. This could include but is not limited to the software acquisition process from initial RFP and selection phases, through to implementation and final user acceptance.
- Obtains and licenses software by obtaining required information from vendors; recommending purchases; testing and approving products.
- Serve as liaison and facilitator between assigned business units, consultants, customers and management to assist in addressing and resolving software related issues.
- Simultaneously coordinate and manage multiple projects and support issues.
- Authorize and administer security for various software systems including determining security requirements for access to critical files.
- Administers data and/or entire databases for efficiency, ease of access, etc. Identifying data integrity and database performance issues, and implement appropriate fixes using best practices for the target database management system. This would apply to both production and test environments.
- Design, prepare and modify reports for multiple software systems using a variety of report writers such as SSRS, Crystal Reports, Microsoft Office and other report writers.
- Prepare and maintain technical documentation in the form of procedural steps, operations manuals, functional specifications, and/or user guides for new and existing software systems.
- Collaborate with fellow team members to discuss progress, issues to be resolved, etc., and report progress on a regular basis to management.
- Provide documentation and training for users in the use and maintenance of system applications.
- Manage projects by: leading and/or assisting in the definition of project scope and objectives; ensuring resource availability and allocation; developing a detailed project plan; managing changes to the project scope, project schedule, and project costs; managing the relationship with the client and all stakeholders; performing risk management; performing change management; and creating and maintaining comprehensive project documentation.
- Evaluates and responds to requests for service and assistance from users and customers as called upon regarding network systems and workstations. Provides realistic and feasible technical solutions for the city's information technology needs. Identifies, evaluates and purchases computer software and hardware.
- Answers telephone calls and responds to written communications. Through thoughtful and knowledgeable questioning, determines customer needs and provides the information or assistance to satisfy the customer needs; responds to inquiries and complaints from customers.
- Observes and follows established city and department policies and procedures in the daily conduct of the job.
- Plans and arranges work schedule and establishes priorities to complete scheduled, assigned work within the time frame and parameters assigned by the Software Services Manager.
- Delivers work products and services with responsiveness, courtesy and tact in personal interactions with customers. Work products and services are delivered within the assigned work schedule, as defined by the Information Services Department Flexible Work Schedule (FWS). The work schedule includes a requirement to carry a cell phone and be available to respond to significant information system problems or failures that may occur during nighttime or weekend hours, as well as during designated rotating on-call schedules. This position may need to work additional hours before and after work schedule hours including weekends to complete their work assignments.
- Works with minimal supervision and receives general direction from the Software Services Manager.
- Updates job knowledge by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
- May serve as an Emergency Worker.
- Performs other assignments and projects as required.
REPORTING RELATIONSHIPS & SUPERVISORY DUTIES:
This Position Reports To: Software Services Manager
This Position Has Supervisory Responsibility For: None
- Education, Formal Training & Experience
- Bachelor's Degree in Computer Science or Information Technology or related field, or equivalent work experience.
- 3+ years of increasing responsibilities in computer application, client server, and web development.
- 3+ years of increasing responsibilities in Microsoft SQL application development and database administration.
- 3+ years of proven independent support in a complex SQL database environment.
- 3+ years designing, building, tuning, installing, configuring and trouble shooting database interfaces, data import / exports tools, and report writing tools including SSRS and Crystal Reports.
- 3+ years of proven communications skills in customer service.
- 2+ years of project management experience.
- 1+ years of change management experience.
- Project management certification would be a plus.
- Change management certification would be a plus.
- Knowledge, Skills, Abilities
- Experience developing code at the database level using T-SQL - stored procedures, triggers, database functions, etc.
- Strong knowledge of relational database concepts, modeling, design, creation and maintenance.
- Experience with business intelligence and reporting technologies such as SSIS, SSRS, and Crystal Reports. SSAS is a plus.
- Exposure to other relational database management systems such as MS SQL Server with IBM's DB2 is a plus.
- Experience developing shell scripts using PowerShell, Windows batch programming is a plus.
- Demonstrated ability to troubleshoot and problem solve critical database and software systems issues.
- Experience in Project and Change Management.
- Working knowledge of server administration, networking, and troubleshooting in a Microsoft Windows operating environment.
- Ability to prioritize workload effectively and work effectively under pressure and with a high degree of independence. Effective in meeting deadlines.
- Strong knowledge of business intelligence concepts and technologies.
- Ability to fully document technical specifications and related project or systems-level documentation.
- Ability to interface effectively and collaborate with customers, peers, and management to troubleshoot issues, develop solutions and ensure stakeholder buy-in.
- Critical thinking skills, ability to accurately analyze information and make sound decisions.
- Must be versatile, flexible, and proactive when resolving technical issues.
- Ability to handle diverse situations and rapidly changing priorities with deadlines.
- Expert knowledge of the Microsoft Office Suite; solid knowledge of security techniques; basic knowledge of e-mail systems, internet browsers; and the skill and ability to apply that knowledge to perform the essential duties and responsibilities of the position.
- Requires expert knowledge and understanding of, and the ability to stay current with, the changing field of information technology, including its applications and current practices and uses.
- Requires emotional stability and maturity, sound judgment, understanding, empathy and the ability to: apply knowledge, logic and reasoning to make prompt and effective decisions and act on those decisions with decisiveness and assertiveness; quickly and effectively evaluate alternative courses of action and select the most appropriate alternative.
- Requires writing skills necessary to write clear, concise documents explaining procedures, fixes, and modifications to applications, reports, installations and other operations.
- Requires the skill and ability to: establish and conduct verbal communications through speaking, talking and hearing; effectively communicate and interact with individuals (e.g. vendors, technical support, co-workers and customers) or groups of individuals of varying social, cultural, economic, professional and educational backgrounds, including the ability to effectively deal with individuals who may be angry, argumentative or disagreeable; the ability to act with tact, good judgment and discretion; and maintain the confidentiality of matters, as appropriate.
- Requires the ability to read, understand and interpret English language manuals and other written materials including, but not limited to: application manuals, systems documentation and application reference manuals; and the skill and ability to apply knowledge and information gained from these materials to effectively perform the essential functions of the position.
- Requires the ability to: maintain composure and perform effectively in stressful situations; and manage conflict effectively; efficiently and effectively deal with constant interruptions and requests for assistance; effectively prioritize work efforts to separate tasks which are urgent in nature and deal with them immediately and schedule the remaining requests for subsequent resolution while continuing to work on the task at hand.
- Requires possession of a valid Colorado driver's license appropriate for the type of vehicle to be operated and the ability to safely and effectively operate a personally-owned or city vehicle when used for city business; requires a qualifying driver's history as prescribed by the city.
MATERIALS AND EQUIPMENT DIRECTLY USED:
- Position uses: a personal computer with assigned software; telephone, photocopier, cell phone; and a personal vehicle or city vehicle, when required for city business.
- Position operates program applications on: Microsoft Windows operating systems, Microsoft Office, Google Apps for Government, and Microsoft SQL.
WORKING ENVIRONMENT & PHYSICAL ACTIVITIES:
- Physical activities include: visual discrimination, color vision and field of vision; talking, and hearing; lifting, carrying, pushing or pulling objects weighing up to 40 pounds; occasional climbing, balancing, stooping, kneeling, crouching, crawling, reaching, handling, and feeling.
- Long periods of sitting, standing or walking may be required.
- Environmental conditions encountered in this position include: constant exposure to light noise associated with humming of computer and cabinet fans.
- The following mental abilities are needed to perform the essential duties of this position: alertness, precision, ingenuity, problem-solving, analytical ability, tactile discrimination, speaking ability, memory, concentration, judgment, reasoning, initiative, patience and visual discrimination; other mental abilities needed include spatial perception, creativity, and writing ability;