Information Technology Analyst IV (Business Intelligence Report Developer)

Solano County; Fairfield (CA); On-site; USD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled Information Technology Analyst IV to lead complex projects and provide advanced technical support. In this role, you will oversee software development, database and network administration, and system troubleshooting while collaborating with various departments. This position offers an opportunity to contribute to county-wide applications and improve operational efficiency. If you are passionate about technology and enjoy problem-solving in a dynamic environment, this role is perfect for you. Join a team that values innovation and professional growth, and make a significant impact on the community.

Benefits

Health Insurance

Retirement Plan

Paid Time Off

Training and Development Programs

Qualifications

• 5+ years of experience in software development or infrastructure management.
• Advanced analytical skills and technical knowledge required.

Responsibilities

• Lead software development and system administration projects.
• Consult with users to resolve system issues and improve operations.

Skills

Software Development

Database Administration

Network Administration

System Troubleshooting

Project Management

Technical Support

Security Administration

GIS

Education

Associate’s Degree in Information Technology

Bachelor’s Degree in Information Technology

Tools

Database Management Software

Network Monitoring Tools

Job description

Depending upon assignment, plans, designs, customizes, updates, develops, and maintains assigned application, technology infrastructure component, and related systems including large and small data processing and application systems serving work unit, division, department, multi departmental, and county wide functions. Depending on the class level assigned, participate as a member of a team or lead a small team of application development, infrastructure, or systems support staff; works with users and troubleshoots and resolves system issues; implements system improvements and upgrades; and participates as a responsible, cooperative, and positive team member. Assignments may include software development, database administration, security administration, network, and server administration, service desk management, and GIS. Levels in this classification are flexibly staffed and are allocated based on the level, nature, and complexity of assignment.

Information Technology Analyst IV

This is the fourth classification level within the Information Technology Analyst job series. Incumbents in this job class possess and apply advanced levels of specialized and technical analytical skills and knowledge while serving as team leader/project manager for designated major systems. Incumbents in this job class perform the most difficult and responsible duties including providing advanced technical support to system users. Incumbents in this job class provide lead direction to software development, network/systems administration, service desk, or security and database systems, other Information Technology Analysts, and/or consultants on assigned systems design, or infrastructure and maintenance projects.

This class specification represents the core area of responsibilities; specific position assignments will vary depending on the needs of the department:

• Coordinates and/or participates in the selection, development, installation, and modification of software systems for a variety of County service areas and enterprise systems; consults with users to identify current operating procedures, clarify program objectives, and determine data requirements; customize user interfaces and reporting systems; participates in the creation and maintenance of data exchange between systems.
• Oversees, coordinates, and/or participates in organizational, operational, and procedural analyses to determine information input, work processes, and desired output for potential and/or up dated computerization for users in support of section, division, department, multi departmental or county wide applications; reviews and analyzes a variety of forms, documents, reports, data output, and record-keeping requirements.
• Installs and administers database and file management software; customizes vendor database software to meet county requirements; provides technical design of databases; monitors performance of databases and corrects problems and/or improves performance; oversees, coordinates and installs hardware and software required for county-wide systems.
• Maintains operating systems, and environmental and data communications software; monitors performance of hardware and operation system software and corrects problems and/or improves performance; designs back-up and recovery procedures; supports computer operations.
• Consults with customer/user departments and advises on the feasibility of converting systems to computerized applications; analyzes departmental and County wide operations, functions, services, interdepartmental relationships, and the information sharing needs in the development of new and/or up dated systems and procedures; recommends improvements in operations and administration of existing systems.
• Consults with supervisor and users to resolve questions of application intent, data input and output requirements, and the inclusion of internal checks and controls; participates in design meetings and consults with other staff to evaluate programs and determine feasibility of design within time and cost constraints; integrates complex and multi functional systems for inter operability over multiple platforms and technologies; prepares and analyzes flowcharts and diagrams exhibiting the sequence of steps the program must follow and the logical operations required.
• Higher level positions may act as project manager/team leader in support of large, complex, and multi functional computerized system(s); assists in preparation of the computer services budget; monitors assigned budget(s) for designated data processing/applications systems as assigned.
• Collects information regarding capabilities and limitations of existing systems, and desired capabilities of future systems; recommends, schedules, plans, develops and implements new systems, system upgrades, and modifications to provide capability for proposed projects, ensure efficient operation, and use allotted space effectively.
• Confers with users, consultants, and programmers to plan data security for software; ensures compatibility of planned security measures with established security systems software; coordinates implementation of vendor-issued security software updates; reviews and addresses violations of computer security procedures.
• Analyzes various factors including number of users serviced by data processing equipment, reporting formats required, volume of transactions, time requirements, and security requirements to determine hardware configurations.
• Codes applications and routines using various computer programming languages; reviews programs to identify and correct errors; designs screen displays to meet user needs; submits plans and designs to user for approval; develops and maintains documentation of program development process.
• Designs project plans based on scope, resources, budget, and personnel; acts as liaison between implementation personnel, management, and vendors, reviewing project details and obtaining approval; oversees production of project deliverables; selects, oversees, and advises project team members; ensures that project adheres to deadlines and budget constraints; coordinates project development with affected groups.
• Plans, designs, installs, configures, upgrades, tunes, and maintains systems software, database and file management software; allocates, formats, and customizes vendor software releases to meet requirements; attends specification meetings with project team workers to determine scope and limitations of database project; establishes physical database parameters; confers with coworkers to determine impact and staff cost of database changes; oversees changes to database management system; communicates with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data; creates, monitors, and maintains computer databases.
• Researches, identifies, evaluates, procures, tests, and configures network systems including hardware and software; oversees the acquisition, installation, and implementation of network equipment, components, infrastructure, and support systems; works with outside vendors to obtain, implement, and maintain data cabling, internet access, data circuits, and other components.
• Utilizes network monitoring tools to monitor servers, firewalls, and network components for errors, security issues, and other problems; reviews device, network, and application logs; reviews usage and utilization statistics; coordinates network operations, support, and disaster recovery.
• Perform network and engineering planning duties; assesses growth requirements; conducts capacity, life-expectancy and feasibility analyses; identifies areas of operation that require upgrades; integrates new technologies with existing technologies by creating detailed system migration plans prior to implementation; studies the integrity and security of data to establish system configurations; monitors system to control and monitor traffic; plans configuration changes and resolves complex installation problems; devises and implements strategies for connectivity to other systems through the use of routers, bridges and gateways.
• Troubleshoots and resolves software, hardware, operating system, and networking problems; communicates with vendor, supervisor, and other staff as necessary to research and resolve problems; contacts programmers to convey software errors or to recommend alterations to programs; contacts vendors to request service for defective products.
• Assists users with operating issues; performs software and system testing procedures, programming, bug verification, release testing, and beta support.
• Trains users in the operation and procedures of the application; consults with users regarding application and maintenance of the software; assists users with problems as they arise.
• Schedules, performs, and monitors system backups; as necessary, performs data recoveries.
• Monitors operations to ensure compliance with government regulations.
• Maintains professional knowledge in applicable areas and keeps abreast of changes in job-related rules, statutes, laws and new business trends; makes recommendations for the implementation of changes; reads and interprets professional literature; attends training programs, workshops and seminars as appropriate.
• Acts as liaison between and primary resource to vendors, technical support consultants, and departments in the resolution of complex system and networking problems; initiates, coordinates, and implements appropriate and corrective measures.
• Provides ongoing guidance and advice to team members, technical and programming staff, and users; assigns work to staff, reviews team members' work on a regular and as needed basis; ensures adherence to Information Services standards and County policies; coordinates appropriate training for team members; monitors productivity and quality of work.
• Attends and conducts a variety of planning and project meetings; develops cost, and time estimates; prepares progress/status reports, presentations and other documentation.

Education: Equivalent to an Associate’s degree, preferably in information technology, or a closely related field.

Experience: Depending upon assignment: Five (5) years of experience performing progressively responsible software development, or infrastructure management duties and functions.

Note: A Bachelor’s degree from an accredited college or university, preferably in information technology, management information systems may be substituted for two years of experience.

Note: Additional experience may substitute on a year for year basis for the educational requirement.

LICENSING, CERTIFICATION AND REGISTRATION REQUIREMENTS:

• Applicants may be required to possess a valid California Driver’s License, Class C.

Note: All licenses, certificates and registrations must be kept current while employed in this class.

Qualifying Under Education - Verification of Education Required

All candidates qualifying for the position under the education requirement must submit a copy of their official/unofficial transcripts (verifying the courses and units completed) or degree (verifying institution, student, date, degree and area of specialization conferred) by the final filing date. Candidates who fail to submit their transcripts by the final filing date will be disqualified from the recruitment.