IT Analyst Programmer 1 or 2 (OPEN & PROMOTIONAL)_

IT Analyst Programmer 1 or 2 (OPEN & PROMOTIONAL)Print (overnmentjobs.com/careers/spokanecountywa/jobs/newprint/4613556)ApplyIT Analyst Programmer 1 or 2 (OPEN & PROMOTIONAL)Salary$54,570.24 - $85,914.57 AnnuallyLocationWA 99260, WAJob TypeRegularRemote EmploymentFlexible/HybridJob Number24-00193DepartmentInformation TechnologyOpening Date08/08/2024Closing DateContinuousFLSAExempt+ Description+ Benefits+ QuestionsJob SummaryNOTE: This vacancy may be filled by at the IT Analyst Programmer 1 or IT Analyst Programmer 2 level depending on the qualifications of the final candidate.This is a hybrid position – Manager will work out teleworking schedule with new employee.SALARY IF HIRED FOR IT Analyst Programmer 1 :$27.99 - $39.16 Hourly$4,547.51 - $6,363.96 Monthly$54,570.24 - $76,367.50 AnnuallySALARY IF HIRED FOR IT Analyst Programmer 2:$31.48 - $44.06 Hourly$5,115.73 - $7,159.55 Monthly$61,388.87 - $85,914.57 AnnuallyWHO MAY APPLY: This recruitment is open to all applicants meeting the minimum requirements. Priority consideration will be given to Spokane County employees in a position covered by the Master Contract (for a minimum of 6 months) submitting applications between 8/8/24 and 8/15/24. First consideration will be given to applicants working in Information Technology in a position covered by the 1553 Collective Bargaining Agreement (CBA); second consideration given to County-wide applicants in a position covered by the 1553 CBA; third consideration given to applicants covered by the Master Contract CBA; fourth consideration will be given to all other applicants.TOTAL COMPENSATION: $69,850 - $109,971 annually. Total compensation is an estimate based upon base compensation, median retirement fund contributions, and current employer-paid health and related benefit contribution rates (including medical, dental, life insurance, long term disability, and leave). The actual total will vary depending upon each employee's enrollment choices.IT Analyst Programmer 1: The position allocated to this class performs professional, technical, analytical and customer-focused work in the Application Services Division of the Information Technology Department. Under the direction of supervisory staff, work involves development and implementation of components of major/minor applications for Spokane County, and some responsibility for small system analysis and design.Positions with GIS emphasis are responsible for creating and maintaining spatial databases, design and creation of cartographic products.This is the first classification in a two-class series; positions of this class differ from those in the IT Analyst Programmer 2 class by the level of complexity of work assignments and the degree of supervision received. Work is performed within established technical guidelines and is closely reviewed through assignments and projects to evaluate results achieved.IT Analyst Programmer 2: The position allocated to this class performs senior-level professional, technical, analytical and customer-focused work in the Application Services Division of the Information Technology Department. Work involves analysis, design, development and implementation of applications for single County departments or a secondary responsibility for subsystems of major countywide applications. Incumbents are responsible for ongoing support for County-developed or purchased applications.Positions with GIS emphasis are responsible for creating and maintaining spatial databases, design and creation of cartographic products.This is the second classification in a two-class series; positions of this class are distinguished from the IT Analyst Programmer 1 classification by performing a broad range of technically complex duties on multiple platforms, and by the level of analysis and design work assigned (particularly for single County department applications), as well as the role of secondary contact for major countywide applications.Examples of DutiesIT Analyst Programmer 1:+ Performs professional functions in software programming and analysis, as assigned.+ Assists in designing, coding, testing, deploying, maintaining, enhancing, and supporting County software systems.+ Assists in working with business customers in translating requirements into plans and specifications.+ Assists in developing new software and customize, developing interfaces to, or integrating with third-party business systems.+ Works in a team-based environment, communicating effectively with all levels of staff and management.+ Collaborates on the identification of business and system requirements.+ Addresses customer’s information needs by developing technology solutions and supporting information and technology systems on multiple computing platforms.+ Provides work estimates.+ Participates in the testing process through unit testing, integration testing, system testing, acceptance testing, and automated test development.+ Coordinates data development and access with necessary department and technical staff. Protects the safety, integrity, and privacy of data.+ Tunes poorly performing application and database code.+ Writes and generates system documentation.+ Delivers excellent customer service, assists in measuring and creating customer satisfaction; enhances customer relationships with the Information Technology Department.+ Maintains up-to-date software development knowledge and builds expertise among colleagues in the Information Technology Department.+ If GIS emphasis, develops applications and mapping products with integrated GIS data and cartographic elements.+ Maintains Public Safety GIS data by updating, adding and removing addresses, streets, and other related data.+ Creates and maintains GIS Python scripts.+ Performs other related duties as required/assigned.IT Analyst Programmer 2:+ Responsible for development, implementation, and ongoing support of complex computer application components, as well as some small system analysis and design, as assigned by Supervisor.+ Manages the research and interpretation of enhancement requests from County departments; this includes customization and modification of both purchased and County-developed programs and systems that range from simple to very complex.+ Designs and develops small applications for County departments as assigned by Supervisor. Analysis of current manual/automated process, defining requirements, design, coding, testing, implementation, and ongoing support for these applications.+ Completes system analysis to streamline and enables efficient use of software and processing.+ Creates application documentation and training materials as needed.+ Trains, instructs, and supports county staff on the productive use of software systems and databases.+ Identifies and publishes software components that can be reused by other Application Services Staff.+ Identifies and analyzes project risk factors.+ Researches coding solutions and software development tools and libraries.+ Designs, codes, tests, deploys, maintains, enhances, and supports County software systems.+ Works with business customers in translating requirements into plans and specifications.+ Develops new software and customize, develops interfaces to, or integrates with third-party business systems.+ Works in a team-based environment, communicating effectively with all levels of staff and management.+ Collaborates on the identification of business and system requirements.+ Addresses customer’s information needs by developing technology solutions and supporting information and technology systems on multiple computing platforms.+ Provides work estimates.+ Participates in the testing process through unit testing, integration testing, system testing, acceptance testing, and automated test development.+ Coordinates data development and access with necessary department and technical staff. Protects the safety, integrity, and privacy of data.+ Tunes poorly performing application and database code.+ Writes and generates system documentation.+ Delivers excellent customer service, assists in measuring and creating customer satisfaction, and enhances customer’s relationships with the Information Technology Department.+ Works with SQL Server Management Studio, ArcGIS Pro, ArcGIS for Desktop, Visual Studio, JavaScript, Python, Office Suite.+ Maintains up-to-date software development knowledge and builds expertise among colleagues in the Information Technology Department.+ If GIS emphasis, develops applications and mapping products with integrated GIS data and cartographic elements.+ Performs other related duties as required/assigned.Minimum RequirementsIT Analyst Programmer 1:+ Bachelor’s Degree from an accredited college or university in MIS, computer science, business administration or a related field.+ If GIS Emphasis, a bachelor’s degree in GIS, Planning, Geography or closely related field+ In lieu of a bachelor’s degree, a four (4) year combination of education, training and/or experience that would provide the required knowledge, skills and abilities will be considered.IT Analyst Programmer 2:+ Bachelor’s Degree from an accredited college or university in MIS, computer science, business administration or a related field.+ Two (2) years of progressively responsible experience in design, analysis, development, and maintenance of computer systems.+ If GIS Emphasis, a bachelor’s degree in GIS, Planning, Geography or closely related field and two (2) years of progressively responsible experience in a GIS software environment.+ In lieu of a bachelor’s degree, a six (6) year combination of relevant education, training and/or experience that would provide the required knowledge, skills and abilities will be considered.Selection FactorsIT Analyst Programmer 1:+ Knowledge of common software engineering design patterns.+ Knowledge of current software development technologies, trends, and methodologies.+ Knowledge of training techniques.+ Knowledge of current County systems.+ Knowledge, if GIS emphasis, of industry standard GIS software products.+ Knowledge, if GIS emphasis, of data captures techniques, spatial analysis methods, cartographic standards, and QA/QC procedures.+ Skilled in communicating effectively both orally and in writing, sufficient to exchange or convey information and to give and receive work direction.+ Skilled in establishing and maintaining effective working relationships.+ Skill in object-oriented programming and design.+ Skill in relational database programming and design.+ Skill in web-based application programming and design.+ Skill in project management.+ Ability to develop software using multiple tools, operating systems, languages, and methodologies.+ Ability to define, track, and assure responsiveness to clients’ information service problems.+ Ability to follow IT Application Development standards and practices.+ Ability to solve software problems proactively.+ Ability to manage own schedule and workload.+ Ability to research, verify, edit, and update databases.+ Ability to define, track, and assure responsiveness to clients’ software service problems.+ Ability to work and contribute as a member in a team-based environment.+ Ability to work effectively and productively with others.+ Ability to understand and follow written and verbal instructions.+ Ability to effectively coordinate, perform and complete multiple duties and assignments concurrently and in a timely manner.+ Ability, if GIS emphasis, to perform spatial analyses within the GIS software environment.IT Analyst Programmer 2:+ Knowledge of common software engineering design patterns.+ Knowledge of current software development technologies, trends, and methodologies.+ Knowledge of training techniques.+ Knowledge of current County systems.+ Knowledge, if GIS emphasis, of industry standard GIS software products.+ Knowledge, if GIS emphasis, of data captures techniques, spatial analysis methods, cartographic standards, and QA/QC procedures.+ Skilled in communicating effectively both orally and in writing, sufficient to exchange or convey information and to give and receive work direction.+ Skilled in establishing and maintaining effective working relationships.+ Skill in object-oriented programming and design.+ Skill in relational database programming and design.+ Skill in web-based application programming and design.+ Skill in project management.+ Ability to develop software using multiple tools, operating systems, languages, and methodologies.+ Ability to define, track, and assure responsiveness to clients’ information service problems.+ Ability to follow IT Application Development standards and practices.+ Ability to solve software problems proactively.+ Ability to manage own schedule and workload.+ Ability to research, verify, edit, and update databases.+ Ability to define, track, and assure responsiveness to clients’ software service problems.+ Ability to work and contribute as a member in a team-based environment.+ Ability to work effectively and productively with others.+ Ability to understand and follow written and verbal instructions.+ Ability to effectively coordinate, perform and complete multiple duties and assignments concurrently and in a timely manner.+ Ability, if GIS emphasis, to perform spatial analyses within the GIS software environment.SPOKANE COUNTYEmployee Benefits SummaryThe following is a brief list of benefits available to Spokane County regular employees. Complete information is available from Human Resources Department. This information is subject to change.PAID TIME OFFSpokane County Observed HolidaysUp to 10 (ten) paid holidays are observed by Spokane County.PTONon-represented and a select group of represented employees receive a bank of hours that combine both vacation and sick leave into a paid time off bank. There is no waiting period to use this time and it starts out at almost 2 days per month accrual increasing in accrual rates annually for first 5 years.VacationFor employees with less than five (5) years of continuous service, the accrual rate is 1 day of vacation each month for a total of 12 days per year. After six (6) months, employees are eligible to take accumulated vacation time. (Please note the vacation time accumulation may vary depending on contract language).Sick LeaveSick leave is earned at 1 day per month and can be taken as the days are accumulated.Other LeavesSpokane County provides several other paid leaves such as: bereavement leave, jury duty and military duty leave.INSURANCE BENEFITSMedical InsuranceTwo plans are currently available: Premera Blue Cross (PPO) and Kaiser Permanente (HMO). Spokane County pays 95% of the premium for full-time employees and 90% of the premiums for spouses and dependents. Premiums are deducted each pay period (pay periods: 15th and last day of the month).2024 Rates:PremeraEmployee Only: $38.04 per monthEmployee & Spouse: $149.52 per monthEmployee & Family: $209.60 per monthEmployee & Child(ren): $136.16 per monthKaiser:Employee: $35.92 per monthEmployee & Spouse: $140.56 per monthEmployee & Family: $196.06 per monthEmployee & Child(ren): $128.58 per monthDental InsuranceTwo plans are currently available: Delta Dental of Washington (PPO) and Willamette Dental (DMO). Spokane County pays 95% of the premium for full-time employees and 90% of the premiums for spouses and dependents.2024 Rates:Delta Dental Willamette DentalEmployee: $5.74 per month Employee: $5.98 per monthFamily: $11.48 per month Family: $11.96 per monthGroup Life InsuranceThe County provides a $25,000 group life insurance policy to employees. The County provides a $10,000 benefit for those represented by 492, 492CS & 492CL. This benefit is paid in full by Spokane County.Long Term Disability CoverageProvides an income protection benefit in the event of a long-term illness or injury at rate of 60% of income up to a maximum of $5,000 per month. Spokane County pays the full premium for this plan. Deputy Sheriff's receive a benefit through their union for disability.RETIREMENTRetirement Plan (401a)Spokane County employees are automatically included in the Washington State Retirement System. Both the employer and the employee contribute to the plan. This retirement plan provides a guaranteed lifetime monthly benefit once vested and eligible for retirement.Additional Retirement Plan Option (457b)Employees may supplement their retirement income and save money on taxes by participating in this optional County program. Roth (after-tax) option is also available through this retirement plan.VOLUNTARY BENEFITSAFLACSupplemental insurance is optional and is provided by AFLAC to help pay for benefits not covered by major medical insurance. The employee pays 100% of the premium.Travel AssistanceProvides additional travel protections anytime you travel more than 100 miles from home. Includes pre-trip information, emergency ticket replacement, and emergency evacuation coverage. This benefit is paid in full by Spokane County.Flexible Spending Plan (FSA)Spokane County sponsors a Section 125 Flexible Spending Account to allow out-of-pocket Medical & Daycare Expenses to be paid with Tax Free Dollars. Premiums are automatically set up pre-tax under the FSA.Voluntary Term Life InsuranceVoluntary Term Life Insurance is additional optional life insurance provided through The Standard Insurance. New employees are guaranteed up to $50,000 for self and $20,000 for a spouse with no medical underwriting needed.WORK/LIFE PROGRAMSEmployee Assistance ProgramEmployees and their family members are eligible to receive free counseling. There are also benefits relating to financial and legal concerns.Reduced Cost Bus Pass ProgramSpokane County participates in a program with STA which discounts bus passes to $5 a month.Wellness ProgramsThere are opportunities for nearby exercise programs at reduced cost and education programs around wellness themes including financial well-being, nutrition and stress reduction.DiscountsThere are local and national discounts available to Spokane County employees.01Describe your experience/knowledge using Microsoft Visual Studio. Provide some examples of projects / applications that you worked on using Visual Studio.02Describe your experience reviewing business requirements and workflow analysis.03How would you describe your familiarity with SQL Server development?04How would you describe your past work as a SQL developer?05Please check the box that applies to your current Union status (if you are not a current Spokane County employee, please select "I am not a Union member").+ I am in the open position's department and my position is covered by the 1553 collective bargaining agreement+ I am in another department and my position is covered by the 1553 collective bargaining agreement+ I am in a position covered by the Master Contract collective bargaining agreement (not 1553)+ I am in a position covered by another collective bargaining agreement (not 1553 or Master Contract)+ None of the above applyRequired QuestionAgencySpokane CountyAddress824 N Adams Spokane, Washington, 99260Phone509-477-5750Websitepokanecounty.org/employment