Systems Analyst - San Francisco, United States - Bay Area Air Quality Management District

Description

Salary : $111, $135,875.43 Annually

Location : San Francisco, CA

Job Type: Full Time

Remote Employment: Flexible/Hybrid

Job Number: AG205-LTCE

Department: Information Services

Opening Date: 05/09/2024

Closing Date: 5/23/2024 5:00 PM Pacific

Description

Join an agency committed to creating a healthy breathing environment for every Bay Area resident while protecting and improving public health, air quality, and the global climate

The Bay Area Air Quality Management District (District) is a regional government agency, committed to achieving clean air to protect the public's health and the environment. The District accomplishes this goal through regulation of industrial facilities and various outreach and incentive programs designed to encourage clean air choices. The District's jurisdiction encompasses all of seven counties - Alameda, Contra Costa, Marin, San Francisco, San Mateo, Santa Clara and Napa, and portions of two others - southwestern Solano and southern Sonoma.

At the District, we take pride in our commitment to fostering a workplace that values diversity and promotes cultural awareness. We prioritize employee engagement by providing a collaborative and inclusive environment that encourages active participation and open dialogue. Our dedication to professional development ensures that every team member has ample opportunities to grow and advance in their careers. Additionally, we strongly believe in pay equity and strive to create a fair compensation structure, recognizing and rewarding talent regardless of gender or background. With a strong emphasis on work-life balance, we understand the importance of supporting our employees' well-being both inside and outside the workplace. Join us in a dynamic and inclusive culture where your contributions are celebrated and your growth is nurtured.

The District is currently accepting applications for the position of Systems Analyst in theInformation Services Division.This is an open recruitment for one (1) full-time, limited-term contract position up to two years.

This is a Limited Term Contract Employee (LTCE) Position. LTCE positions are funded by grants or other designated funds which are not part of the District's ongoing general fund budget. LTCE positions are subject to individual employment contracts and are limited to the duration of their funding source. Regular employees have the right to apply for an LTCE position. However, LTCE positions are not subject to the terms of the EA MOU, and LTCE employees serve on an at will basis.

About You in the Position
The Systems Analyst in the Information Services Division will work closely with the IT and the Air District's grant programs teams to help design and implement a new grants management system (GMS). As an experienced Systems Analyst and project lead, you'll document the vision and outcomes in a request for procurement, define and document the business rules, manage the vendor, ensure accuracy and effective systems configuration, be the technical lead for the accurate transfer of data to the new system, manage migration, timely delivery of the new system including testing, go-live, and ongoing maintenance. This cutting-edge solution streamlines processes to enhance data accuracy and reporting and empowers our team to make informed decisions efficiently. Your customer-facing role involves understanding our unique business needs, designing intuitive interfaces, integrating powerful features, and ensuring seamless implementation. By creating this next-generation system, you'll be pivotal in advancing our mission.

Definition
Under general direction, coordinates, analyzes, designs, implements and evaluates the acquisition, development and maintenance of District-wide information management systems, including hardware, software, communications, and training; designs and modifies application systems; develops, recommends, and implements District network, telecommunications, and computer systems; administers network, file servers, and multi-user computer systems; and performs related work as assigned.

Distinguishing Characteristics
This advanced, specialized classification performs complex duties in the development and acquisition of data communications, telecommunications, networking and system software and hardware, and develops and modifies complex application systems. The responsibilities of this class inherently include providing project leadership and work direction to others. In the Applications Program this classification focuses on application development and database design, and in the Operations Program this classification focuses on systems administration, computer operations and telecommunications support. This class is distinguished from Supervising Systems Analyst in that the latter has overall managerial responsibility for the staff and activities in the Applications, or Operations Programs.

Examples of Duties for this Position

Participates in the negotiations and administration of contracts for hardware and software acquisition and maintenance; orders personal computer hardware and software; directs system installations and upgrades and hardware repairs

Designs, develops, tests and implements new systems to meet user requirements and needs.

Administers network, file servers, web server, multi-user systems, PBX, voicemail, e-mail, and relational data base management systems.

Directs the work of programmers in the development, testing and implementation of complex programs.

Gathers and analyzes information regarding user systems and requirements; conducts feasibility studies and develops system, time, equipment and cost requirements; develops or modifies automated systems to fulfill those needs using computer generated techniques.

Writes user procedures and instructions and assists user staff in implementing new or modified programs and applications; tracks and evaluates project and system progress; plans and develops test data to validate new or modified programs; designs input and output forms and documents.

Confers with user division staff regarding assigned functional program areas.

Identifies, analyzes, develops, recommends, and implements data, and voice systems; analyzes current systems and develops short- and long-range goals for system development and implementation; recommends improvements to the system based on District needs and system capabilities.

Assists in the development and implementation of goals, priorities and policies relating to District-wide information management.

Evaluates, selects and implements the installation and testing of new computer hardware, software and telecommunications equipment.

Assists in the development of information systems budget relating to computer hardware and software acquisition and maintenance.

Develops and maintains network security and disaster recovery plans for database and network file server systems.

Conducts special studies and projects involving administrative, organizational management analyses related to telecommunications, and network and multi-user data systems; prepares and presents recommendations and reports on system use, budget projections, and system designs and procedures.

Develops and implements upgrade plans for telecommunications systems, networks, multi-user systems and desktop environments.

Assists programming staff and systems users in resolving hardware, software, and operational problems.

Simulates hardware and software problems using computer generated techniques; tests and evaluates alternative solutions, and recommends and implements appropriate applications design.

Maintains current knowledge of technology and new computer user applications.

Oversees the staff and activities of assigned projects.

Minimum Qualifications

• 5-7 years of experience in grants administration, systems management, IT

• BS in Business, Engineering, Computer Science/Information

• 5- 7 years of experience with Microsoft Excel

• 5- 7 years of experience in Microsoft Power Platform including PowerView, PowerPivot, and PowerBI, Power Automate and demonstrated experience in data visualization best practices using Power BI

• 5-7 years of verifiable expertise in the development of new and/or ongoing administration of existing Salesforce and/or Microsoft CRM system deployment

• 4-5 years of experience generating metrics/dashboard creation, reporting, and presenting data and analysis.

• 4-5 years working with and migrating data stored across multiple databases/data sources

• 4-5 years of experience with security requirements for cloud-based data management and web-based applications
Experience with UI/UX, including ADA requirements for government organizations.
Ability to work independently and part of a team
Advanced problem-solving skills and data analysis skills
Customer service skills

Education & Experience
A typical way to obtain the knowledge and skills is:

Equivalent to graduation from a four-year college or university with major coursework in computer science, mathematics or a closely related field and two years of experience in systems design and analysis, systems programming, network and systems administration and/or data and voice communications.

Desirable Qualifications
Knowledge of Government procurement and contracting processes
Experience in vendor management.
Experience in cloud computing.
Experience in systems administration.
Experience in Air Quality Management

Benefits
LTCEs are eligible to receive a generous benefits package, including Medical, Dental & Vision Options, Life Insurance, CalPERS Retirement Plan, Floating Holiday Leave, 14 Paid Holidays, Flexible Work Schedule/Remote Options, Transit Subsidy, Educational Reimbursement, and more.

Please see a full list of benefits here:

How to Apply & Selection Criteria

How to Apply

Interested individuals must submit a completed Air District application, chronological resume, and responses to the supplemental questionnaire by 5:00 p.m. on Thursday, May 23, 2024. Applications are accepted online; please visit our website at to apply. Applications are accepted online; please visit our website at to apply.

Resumes are encouraged, but not mandatory, and will not be accepted in lieu of the required application materials. Postmarks, faxes, and e-mailed applications will not be accepted.

Except as requested in this announcement, do not include any additional documents, such as letters of recommendation, performance evaluations, work samples, etc. They will not be considered or returned.

Supplemental Questions Instructions

Individuals who apply for this position must respond to each of the required supplemental questions. Applications must be received by the Human Resources Office no later than the time and date specified in this vacancy announcement. The responses to the supplemental application questions will be used in accordance with the procedures indicated under the Selection Criteria section.

Please limit your responses to one page per question. Do not combine your responses or reference your application, resume, or any other requested documentation that you have included with your application packet to answer a question. This information will be evaluated as is and may be used to determine those applicants with the most directly related experience, education, and training to continue in the selection process. It is very important to provide a concise, clear, legible, complete response to each question.

Selection Criteria

Selection may be based upon a competitive examination consisting of a written exercise, interview, or combination of the two. Depending on the number of qualified applicants, an application screening and/or panel interview may be used to determine the most qualified applicants.

The District may hire from this recruitment process to fill future vacancies occurring within the next 18 months.

Persons with disabilities who may require reasonable accommodations during the application and/or selection process should notify the Human Resources Office at

The District is an Equal Opportunity Employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.

The Air District offers the following benefits for full-time, represented and management positions:

• Cost-Sharing Medical, Dental & Vision Options
• Life Insurance (up to 5 times annual salary)
• CalPERS Retirement Plan
• Money Purchase Pension Plan
• 457 Deferred Compensation Plan
• Transit Subsidy
• Education Reimbursement
• Vacation Leave
• Sick Leave
• Paid Holidays
• Floating Holiday Leave
• 9-80 Compressed Work Week
• Flexible schedule and Remote Work option
• Employees Assistance Program
• and the Opportunity to Help Provide a Healthy Breathing Environment for Every Bay Area Resident.

01

The Systems Analyst will work closely with grant program staff to understand the scope of the need for the new grants management system. Please describe your experience working with users to gather requirements for building new systems.

02

Can you describe how you handled a challenging situation experienced while writing requests for procurement, managing IT procurement, and managing vendor delivery? How did you expedite the procurement and timely delivery while holding the vendor accountable?

03

In your experience with Microsoft Dynamics and Microsoft SQL, can you provide an example of a complex data analysis or query you performed? How did you approach the task, and what insights did you gain?

04

When administering grants using the Salesforce Grants module, how do you ensure compliance with regulations and guidelines? Can you give an example of how you implemented a compliance measure or resolved a compliance issue in the past?

05

How will your background and experience in IT and/or grants administration benefit this project?

Required Question