Systems Analyst

Join the City of Medfords IT team as a Systems Analyst where you will be the driving force and subject matter expert behind our enterprise software addition to providing support for the Citys third-party ERP systems you will also manage projects related to the implementation and enhancement of new and existing systems.

Youll work closely with other departments to ensure IT aligns with business needs and provide technical solutions for business processes. Complex problem-solving will be a core part of your day requiring a highly analytical and self-motivated mindset to diagnose and resolve technical issues across a wide variety of systems.

From new software deployments to ongoing administration and support your analytical and technical expertise will be crucial in shaping our enterprise application landscape.

Required Education and Experience:

• Graduation from high school or GED equivalent; and
• Six (6) years of experience with computer hardware and software support database development and management.
• A bachelors degree in computer science or other area of study as deemed applicable may substitute for two (2) years of experience.

• Proficiency in SQL scripting for querying databases data analysis and generating reports.
• Prior experience with Cognos Crystal Reports and SSRS reporting tools.
• Experience designing and developing data marts and data warehouses.

Available Schedule:

• Monday - Friday 8:00 AM - 5:00 PM
• Opportunity for alternate schedule:
  • Teleworking may be available after the first 90 days (not guaranteed). Telework is granted based on merit and performance at the discretion of the direct supervisor and department director.

This position is part of the Non-Represented Groupemployee group.

Learn more about our benefits HERE.

• Medical vision and dental benefits for employee and family paid at 100% by the City with the opportunity to buy-up to a lower deductible plan
• Life and Accidental Death and Dismemberment insurance policy value of $50000 paid by the City
• Long-term disability insurance provided by the City
• Health Reimbursement Account (HRA-VEBA) contributions provided by the City

• Oregon Public Employee Retirement System (PERS) lifetime pension after retirement at no cost to employee
• PERS is 100% fully paid as the City pays both the employer and the employees (6%) contributions
• Deferred Compensation retirement plan (Section 457 Plan) for employees retirement planning

• Paid vacation sick leave and holidays
• Employee Assistance Program (EAP)
• The Citys Wellness Program promotes physical social emotional intellectual financial and environmental wellness with various goals and challenges to participate in throughout the year. Employees may qualify for wellness incentives by completing milestones set within the program up to $200 annually
• Access to the Citysfully equipped fitness center24/7

Essential Functions of the Position:

• Subject matter expert on supported core and third-party applications.
• ERP application installation configuration and go-live testing administration support maintenance and ongoing enhancements.
• Troubleshoot and resolve complex technical issues.
• Analyze business requirements research trends and industry best practices and implements business applications to provide creative efficient effective and sometimes disruptive solutions.
• Workflow/business process analysis including cost/benefit analysis.
• Project management including the development of project plans and timelines.
• Assists with projects on multiple Operating Systems database and application platforms.
• Communicate and work with core and third-party vendor sales applications and support.
• Repairs and recovers systems from software/hardware failures and coordinates and communicates with impacted parties.
• Administers industry standard databases manages user authority provides application user access and ensures integrity of related databases and associated applications.
• Maintains and possesses knowledge of software applications used by the City such as MS Office MS SQL Cognos and other applicable technology.
• Perform quality assurance over interim work products and deliverables.
• Develops and maintains customized reports for database applications and system management documentation.
• Ensures successful application and database interfaces and installs and tests various system and application software packages.
• Supports Windows platform complex networks and public access to web- based services.
• Ensures positive customer service through professional courteous behavior and creative problem resolution.
• Uses clear verbal and written communication skills to work across the organization supporting City executive supervisory/management and line staff.

• Develop functional/technical specifications identifying the features and functions of an application.
• Facilitate customer sessions to define their application requirements.
• Prepare procedures handbooks manuals and other training related materials.
• Assists with the development of project proposals and work program/budget.
• Customer presentation demonstrations feedback sessions and training.
• Instructs information technology professionals and City personnel on basic to advanced elements of various software application packages.
• Upholds the values of the organization and has strong customer service orientation.
• Handles job stress and interacts effectively with others in the workplace.
• Fosters an environment that embraces diversity integrity trust and respect.
• Is an integral team player which involves flexibility cooperation and communication.
• Performs other related projects and duties as assigned.
• Demonstrates regular reliable and punctual attendance.

Communicativeness -Effective performers recognize the essential value of continuous information exchange. They actively seek information from a variety of sources and disseminate it in a variety of ways. They use modern technologies to access and circulate information. They take responsibility for ensuring that their peers and supervisors have the current and accurate information needed for success.

Customer Orientation -Effective performers attend to customers in a timely manner. They view the organization through the eyes of the customer and go out of their way to anticipate and meet customer needs. They continually seek information and understanding regarding market trends.

Initiative -Effective performers are proactive and take action without being prompted. They dont wait to be told what to do or when to do it. They see a need take responsibility and act on it. They make things happen.

Learning Agility -Effective performers continuously seek new knowledge. They are curious and want to know why. They learn quickly and use new information effectively. They create and foster a culture of interest curiosity and learning.

IMPORTANT (Please read):

• It is important your application shows all the relevant experience you possess.
• Applications may be rejected if incomplete.
• Resumes will not be accepted in lieu of an online application; an application will be considered incomplete with a see resume response.
• Please complete the application and answer the supplemental questions thoroughly to ensure our subject matter experts can appropriately evaluate your experience as we compare applicants.

- - - - - - - -- - - - - - -

VETERANS PREFERENCE:

Qualifying veterans and disabled veterans may obtain preference during the hiring and/or promotional selection process. As verification of eligibility a Discharge from Active Duty (DD Form 214 or 215) must be uploaded with the online employment application. Disabled veterans must also upload a copy of the veterans disability preference letter from the U.S. Department of Veterans Affairs unless the information is included in the DD Form 214 or 215.

EQUAL OPPORTUNITY EMPLOYMENT:

The City of Medford is proud to be an equal opportunity employer. We do not discriminate based uponrace religion color national origin marital status sexual orientation gender identity gender expression age ancestry status as a protected veteran physical or mental disability medical condition pregnancy genetic information or any other status protected under federal state or local law.

ADA:

The City of Medford complies with the Americans with Disabilities Act. If you consider yourself disabled and require assistance in the application process please contact or email:.