Enterprise Solutions Engineer/Senior Enterprise Solutions Engineer

CITY EQUITY STATEMENT The City of Westminster welcomes diverse candidates from the broadest base possible. Our goal is to find the best candidate for the job—someone who belongs, not just fits. We value life and professional experiences, recognizing equivalent combinations of knowledge skills and education. Aligned with our city SPIRIT values, the successful candidate will have a passion and commitment to serving a diverse population of residents and must respect and uphold the principles of justice, equity, diversity, inclusion and belonging. We encourage you to think broadly about your background and skill set for this role, even if you believe you have a less traditional background than described we invite you to apply. POSITION PURPOSE / IMPORTANT APPLICATION INFORMATION The Enterprise Solutions Engineer/Sr Enterprise Solutions Engineer position is a technical professional position in the Information Technology Department supporting mission critical enterprise applications. This position does not involve software development responsibilities. Core responsibilities for this position include technical application support, troubleshooting, enhancements and upgrades. Work 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. Responsibilities include direct collaboration with customers and vendor technical support. Additionally, the incumbent will drive technical solutions by developing integrations and providing advanced support for the City's Microsoft 365 ecosystem, specifically SharePoint, OneDrive, and the Power Platform. Work is performed independently and under the direction of the Enterprise Solutions Supervisor. This position specifically supports Public Safety applications. Senior Enterprise Solutions Engineer requires a minimum of four (4) years of directly related work experience. 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 has a Multilingual Stipend Program to encourage, and reward benefited employees who are conversationally fluent in languages other than English. Benefited employees have the opportunity to test their language proficiency skills and qualify for a bi-weekly stipend that will vary based on the employee’s level of proficiency and usage. 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: The City of Westminster provides high-quality core services and fosters resilience in order to promote a safe and thriving community. 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 – People – Integrity – Respect – 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 priorityCommunicate with customers to ensure that, where possible, they are satisfied, and that their needs are being addressed; solicit and evaluate customer feedbackAct as an ambassador by understanding and fostering the organization's mission and visionExhibit pride in self, the department, the city, and the community; conduct self in a professional mannerDemonstrate integrity and build trust through credibility, reliability, commitment, loyalty, and ethical behaviorAddress difficult or contentious issues in a constructive mannerSupport/promote change; demonstrate flexibility, and take calculated risks when appropriateParticipate in personal growth opportunities, and attend trainings designed to enhance capacity to bring new skills and ideas to the job and the organizationWork to continuously improve the efficiency and effectiveness of the service or product being deliveredDemonstrate support for team efforts by accepting new roles and responsibilities, and helping others achieve objectivesValue 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 commitmentsRecognize personal strengths and weaknesses, and target areas for personal self-developmentDemonstrate initiative in performing job tasksExhibit problem-solving skills leading to sound judgment and quality decisionsAchieve goals, and handle assigned workload and new assignments effectively; demonstrate an ability to work independentlyCommunicate effectively with individuals and groups using clear and concise verbal and written communicationsDemonstrate accountability for work, and take ownership in job performanceDemonstrate 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 Government Enterprise and Public Safety applicationsKnowledge supporting systems that are cloud-based and Software as a Service (SaaS) with a focus on security, availability, and consistencyPerform advanced development work in Microsoft SQL and SQL Server Reporting Services (SSRS)Demonstrate experience with technical Project Management for software applications including new application implementations, upgrades, and enhancementsKnowledge of SharePoint implementations using Microsoft 365 applications, including Microsoft Teams and Microsoft OfficeDemonstrate experience using SOAP and REST approaches to API design and testingDemonstrate excellent judgment, creativity, and problem-solvingDemonstrate excellent analytical skills and concentrationWork effectively to meet goals and priorities during stressful situations and eventsCommunicate technical concepts and technology solutions to management and customers clearly, concisely, and effectivelyRespond 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 supportiveEncourage employees to be accountable for their work and take ownership in what they doDemonstrate leadership and courage by making or supporting decisions that reflect the organizational mission and goals even when the decision may be unpopular to someDemonstrate collaboration and conflict resolution skills with other departments and employees Job Specific Functions Essential Job Functions, Duties, Responsibilities, And Tasks Provide application support, analysis, design, testing, implementation, enhancements, and maintenance using tools such as Microsoft Visual Studio, Microsoft SQL Server, SQL Server Reporting Services (SSRS), SharePoint, OneDrive and Microsoft TeamsMaintain and support all Information Technology Department and City policies and practices:Communicate successfully and maintain effective relationships: Other Duties And Responsibilities Incumbent is accountable for all duties of this job; other projects and responsibilities may be added at the City’s discretion. Design, coordinate, and maintain the overall usability of the City’s major software applications:Assist, as assigned, with enterprise software support for various public safety applicationsPerform technical project management for implementations, enhancements and upgradesAssists departments with evaluation and selection of new enterprise applicationsAssist, 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 usersCommunicate with and support customers and Information Technology staff:Provide software focused training materials and documentation for customers and peersProvide support and service to our internal and external customersProvide application support, analysis, troubleshooting, implementation, and maintenance with users verbally and in writing to provide development and enhancement project updatesPrepare user documentation on applications for customers and internal IT useProvide written updates of project status for Enterprise Solutions Supervisor and customers as requiredWork with IT and City departments and divisions to find solutions to improve business efficienciesScoping, communicating, and coordinating projects with key project stakeholdersUpdate automated request tracking system dailyCompile periodic activity statistics and user feedbackEvaluate cost-effectiveness of requests, and prepare written recommendations for the Enterprise Solutions Supervisor, as requestedDevelop, create, and/or update project plans as requiredParticipate in periodic planning and status meetings with the Solutions Engineering TeamAttend training classes and seminars related to job responsibilitiesAdhere to all established City and Information Technology department standards and procedures by reading and understanding such proceduresPrepare effective written communications, manuals, and training for usersWork and communicate effectively with other department members as well as the City and public in a positive collaborative mannerProvide training on new and enhanced applications for usersMaintain regular and punctual attendance while in the office and working remotelyParticipate in an after-hour application support, upgrades and troubleshooting as requiredParticipate in an after hour/weekend on call rotation as required Position Requirements/Working Conditions/Pre-employment Requirements Required Education, Experience, Skills, Formal Training, Licenses, and Certifications Graduation from an accredited four-year college with major course work in Computer Science, Computer Information Systems, Information Management, or related fieldExperience supporting enterprise software applicationsExperience working with relational database management systems, SQL Server Management Studio and writing MS SQL queriesAbility to pass the Criminal Justice Information Services (CJIS) background check Preferred Experience supporting public safety applications specificallyExperience with technical project management related to software applicationsPrior experience using SQL Server Reporting Services (SSRS)Experience using SOAP and REST approaches to API design and testingExperience developing and supporting SharePoint implementations through Microsoft 365 applications, including Microsoft Teams and Microsoft OfficeExperience writing technical documentationExperience supporting cloud solutions through Microsoft AzureExperience with Power PlatformExperience developing and supporting Power BI tools including dashboards and reports Progression Requirements Sr. Enterprise Solutions Engineer requires a minimum of four (4) years of directly related work experience. 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 periodsFrequent 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 suppliesConstant light grasp, fine manipulation, and handling to perform daily duties; occasional firm grasp to safely use equipmentFrequent 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. Required Materials And Equipment 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 verificationMust be able to pass a Criminal Justice Information Services (CJIS) background investigation and be fingerprinted for this job; a felony conviction is generally considered grounds for denial of CJIS access; outstanding arrest warrants can also lead to being disqualified from CJIS certificationPre-employment drug screenMust be legally entitled to work in the United States The City of Westminster, Colorado, is a drug free workplace and an Equal Opportunity Employer that values diversity and aims to have its workforce reflect the community. The City of Westminster offers a comprehensive benefit package including: Health and DentalFlexible SpendingPension/Retirement PlansTerm Life InsuranceLong-term DisabilitySurvivor BenefitsWellness ProgramLeave program that provides for vacation, holidays, sick leave, major illness, on the job injury, and administrative reasonsCareer Development ProgramTuition Reimbursement Program For a more detailed overview of our Exempt and Administrative Officer benefit package: 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.5% of your base pay. Contributions are pre-tax and fully vested. Employer Contribution: 12% of your base pay. Employer Contribution Vesting Schedule Less than 3 years - 0%3 to 4 years - 60%4 to 5 years - 80%Over 5 years - 100%For employees age 55 and older, the employer contributions are 100% vested The City of Westminster provides employees with innovative and practical ways to improve their commute through two key features, EcoPass and Commute Benefits powered by Commutrics. EcoPass provides unlimited trips on RTD's core transit services and Commute Rewards allows you to record your trips and get rewards based on your commute mode. 01 Please select your highest level of completed education in a technical field (such as Computer Information Systems, Computer Science, or Information Management). In the space below, please provide the specific degree(s) earned, the primary area of study, and the institution(s) attended. NoneSome CollegeAssociates DegreeBachelor's DegreeMaster's Degree or higher 02 Please provide the specific degree(s) earned, the primary area of study, and the institution(s) attended. If none, please respond with N/A. 03 Please provide details on your education and/or certifications and how they relate to the specific duties of this position. If none, please respond with N/A. 04 Please Describe The Administrative, Non-end User Experience You Have In Any Of The Following Systems, If You Have None, Please Respond With N/A Computer Aided Dispatch (CAD) applicationsPolice and/or Fire Records Management SystemsEmergency Medical Services applicationsCourt applicationsGIS systemsProperty/Evidence tracking applicationsNone of the above 05 Please describe the experience you have developing SQL queries for Microsoft SQL Server and how you have used these skills to support enterprise applications. If you do not have experience in this area, please respond with N/A. 06 Please describe the experience you have using REST and SOAP approaches to API design and testing? If you do not have experience in this area, please respond with N/A. 07 Please describe the experience you have working with the Microsoft Power BI analytics tools. If you do not have experience in this area, please respond with N/A. 08 Please describe the experience you have developing and supporting SharePoint implementations through Microsoft 365 applications, including Microsoft Teams and Microsoft Office. If you do not have experience in this area, please respond with N/A. 09 Please describe the experience you have creating and supporting SSRS reports. If you do not have experience in this area, please respond with N/A. 10 Please describe the experience you have working with Laserfiche in a technical support role. If you do not have experience in this area, please respond with N/A. 11 Please describe a time when you experienced a conflict or difference of opinion with a vendor of an application you supported. How did you resolve the issue to the satisfaction of both vendor and customer, while maintaining a cordial working relationship with the vendor? If none, please respond with N/A. 12 Due to critical nature of Public Safety systems, this position requires participation in an after hours/weekend on call rotation. Are able to meet this requirement? YesNo 13 You must be able to pass a Criminal Justice Information Services (CJIS) background investigation and be fingerprinted for this job. A felony conviction is generally considered grounds for denial of CJIS access. Outstanding arrest warrants can also lead to being disqualified from CJIS certification. Are you able to meet this requirement for this position? YesNo