IT Analyst Programmer 1 or 2 (OPEN & PROMOTIONAL) - Spokane County

IT Analyst Programmer 1 or 2 (OPEN & PROMOTIONAL) Print (https://www.governmentjobs.com/careers/spokanecountywa/jobs/newprint/4613556) Apply ? IT Analyst Programmer 1 or 2 (OPEN & PROMOTIONAL) Salary $54,570.24 - $85,914.57 Annually Location WA 99260, WA Job Type Regular Remote Employment Flexible/Hybrid Job Number 24-00193 Department Information Technology Opening Date 08/08/2024 Closing Date Continuous FLSA Exempt + Description + Benefits + Questions Job Summary NOTE: 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 Annually SALARY 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 Annually WHO 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 Duties IT 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 Requirements IT 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 Factors IT 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 COUNTY Employee Benefits Summary The 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 OFF Spokane County Observed Holidays Up to 10 (ten) paid holidays are observed by Spokane County. PTO Non-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. Vacation For 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 Leave Sick leave is earned at 1 day per month and can be taken as the days are accumulated. Other Leaves Spokane County provides several other paid leaves such as: bereavement leave, jury duty and military duty leave. INSURANCE BENEFITS Medical Insurance Two 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: Premera Employee Only: $38.04 per month Employee & Spouse: $149.52 per month Employee & Family: $209.60 per month Employee & Child(ren): $136.16 per month Kaiser: Employee: $35.92 per month Employee & Spouse: $140.56 per month Employee & Family: $196.06 per month Employee & Child(ren): $128.58 per month Dental Insurance Two 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 Dental Employee: $5.74 per month Employee: $5.98 per month Family: $11.48 per month Family: $11.96 per month Group Life Insurance The 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 Coverage Provides 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. RETIREMENT Retirement 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 BENEFITS AFLAC Supplemental 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 Assistance Provides 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 Insurance Voluntary 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 PROGRAMS Employee Assistance Program Employees and their family members are eligible to receive free counseling. There are also benefits relating to financial and legal concerns. Reduced Cost Bus Pass Program Spokane County participates in a program with STA which discounts bus passes to $5 a month. Wellness Programs There are opportunities for nearby exercise programs at reduced cost and education programs around wellness themes including financial well-being, nutrition and stress reduction. Discounts There are local and national discounts available to Spokane County employees. 01 Describe your experience/knowledge using Microsoft Visual Studio. Provide some examples of projects / applications that you worked on using Visual Studio. 02 Describe your experience reviewing business requirements and workflow analysis. 03 How would you describe your familiarity with SQL Server development? 04 How would you describe your past work as a SQL developer? 05 Please 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 apply Required Question Agency Spokane County Address 824 N Adams Spokane, Washington, 99260 Phone 509-477-5750 Website http://www.spokanecounty.org/employment