What are the responsibilities and job description for the Enterprise Solutions Engineer/Senior Enterprise Solutions Engineer position at City of Westminster?
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.
Senior Enterprise Solutions Engineer requires a minimum of four (4) years of directly related work experience.
This position will require a 100% in-office, Monday through Friday, 8:00 a.m. to 5:00 p.m schedule. Occasional evening and weekend hours and participation in on-call rotation for after-hours emergencies, application support, upgrades, and troubleshooting is required. 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
Citywide - Every employee in this position is accountable to:
Essential Job Functions, Duties, Responsibilities, and Tasks2. 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 Teams4. Maintain and support all Information Technology Department and City policies and practices:5. Communicate successfully and maintain effective relationships:Other Duties and ResponsibilitiesIncumbent is accountable for all duties of this job; other projects and responsibilities may be added at the City’s discretion.
Education, Experience, Skills, Formal Training, Licenses, and Certifications
Required
Work is sedentary in nature and requires sufficient physical stamina and strength for:
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.
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
The City of Westminster offers a comprehensive benefit package including:
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
01
Please select your highest level of completed education in a technical field (such as Computer Information Systems, Computer Science, or Information Management).
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 detail 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
Which of the following do you have administrative, non-end user experience in?
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 a time when you experienced broken, chaotic, or otherwise confusing permissions in SharePoint/OneDrive/Teams and how you resolved them. If you do not have experience in this area, please respond with N/A.
10
Describe a specific scenario where you utilized Power Automate or Power Apps to create a data integration between two or more enterprise applications. If none, please respond with N/A. In your response, please address the following:
Please describe the most complicated activity you have automated using Power Automate/Power Apps. If you do not have experience in this area, please respond with N/A.
12
Please describe the most common activity you have automated using Power Automate/Power Apps. If none, please respond with N/A.
13
Please describe a time in which you designed a SharePoint landing page for a department or an organization. What Web Parts did you use and how did using that Web Part meet the goals of the requesting department or organization? If you have no experience, please respond with N/A.
14
This position will require a 100% in-office, Monday through Friday, 8:00 a.m. to 5:00 p.m. schedule. Occasional evening and weekend hours and participation in on-call rotation for after-hours emergencies, application support, upgrades, and troubleshooting is required. Are you willing to commit to this schedule?
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.
Senior Enterprise Solutions Engineer requires a minimum of four (4) years of directly related work experience.
This position will require a 100% in-office, Monday through Friday, 8:00 a.m. to 5:00 p.m schedule. Occasional evening and weekend hours and participation in on-call rotation for after-hours emergencies, application support, upgrades, and troubleshooting is required. 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 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
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
- Demonstrate an understanding of software support for Government Enterprise and Public Safety applications
- 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 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
- 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
Essential Job Functions, Duties, Responsibilities, and Tasks2. 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 Teams4. Maintain and support all Information Technology Department and City policies and practices:5. Communicate successfully and maintain effective relationships:Other Duties and ResponsibilitiesIncumbent 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 government applications
- 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
- Communicate with and support customers and Information Technology staff:
- 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
- Update automated request tracking system daily
- Compile periodic activity statistics and user feedback
- Evaluate cost-effectiveness of requests, and prepare written recommendations for the Enterprise Solutions Supervisor, 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
- 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
- Maintain regular and punctual attendance while in the office and working remotely
- Participate in an after-hour application support, upgrades and troubleshooting as required
- Participate in an after hour/weekend on call rotation as required
Education, Experience, Skills, Formal Training, Licenses, and Certifications
Required
- Graduation from an accredited four-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 database management systems, SQL Server Management Studio and writing MS SQL queries
- Ability to pass the Criminal Justice Information Services (CJIS) background check
- Experience with technical project management related to software applications
- Prior experience using 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 with Power Platform
- Experience developing and supporting Power BI tools including dashboards and reports
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
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.
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 verification
- 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
- 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
- Leave program that provides for vacation, holidays, sick leave, major illness, on the job injury, and administrative reasons
- Career Development Program
- Tuition Reimbursement Program
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
01
Please select your highest level of completed education in a technical field (such as Computer Information Systems, Computer Science, or Information Management).
- None
- Some College
- Associate's Degree
- Bachelor's Degree
- Master's Degree or higher
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 detail 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
Which of the following do you have administrative, non-end user experience in?
- Customer Information Systems (CIS)
- Enterprise Resource Planning (ERP) Systems
- Human Resource Information Systems (HRIS)
- Asset and Maintenance Management Systems
- Contract/Document Management Systems
- Financial Systems
- None of the above
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 a time when you experienced broken, chaotic, or otherwise confusing permissions in SharePoint/OneDrive/Teams and how you resolved them. If you do not have experience in this area, please respond with N/A.
10
Describe a specific scenario where you utilized Power Automate or Power Apps to create a data integration between two or more enterprise applications. If none, please respond with N/A. In your response, please address the following:
- What specific connectors or actions did you use to move data between the systems, and how did you handle data mapping to ensure consistency?
- How did this integration extend the functionality of the existing software?
- What was the most difficult part of ensuring the two systems "talked" to each other correctly, and how did you verify that the data was integrated successfully?
Please describe the most complicated activity you have automated using Power Automate/Power Apps. If you do not have experience in this area, please respond with N/A.
12
Please describe the most common activity you have automated using Power Automate/Power Apps. If none, please respond with N/A.
13
Please describe a time in which you designed a SharePoint landing page for a department or an organization. What Web Parts did you use and how did using that Web Part meet the goals of the requesting department or organization? If you have no experience, please respond with N/A.
14
This position will require a 100% in-office, Monday through Friday, 8:00 a.m. to 5:00 p.m. schedule. Occasional evening and weekend hours and participation in on-call rotation for after-hours emergencies, application support, upgrades, and troubleshooting is required. Are you willing to commit to this schedule?
- Yes
- No
- Required Question