Senior Systems Analyst (Enterprise Technology Solutions)

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 Air District is currently accepting applications for the position of Senior Systems Analyst in the Enterprise Technology Solutions Division. This is a promotional recruitment for three (3) vacancies which are full-time, represented positions.

About the Position

In this role, you will collaborate with IT and cross-functional teams to design, implement, and maintain enterprise IT systems and solutions spanning Power Platform development, database administration, and business intelligence reporting. Responsibilities include defining and documenting business requirements, developing Power Apps and Power Automate workflows, designing and managing database structures and data pipelines, integrating secure and efficient data connections across multiple sources, and creating insightful dashboards and reports with Power BI. As a technical leader, you will ensure accuracy, timely delivery, and ongoing maintenance of applications and data systems that optimize processes, improve data integrity, and enable informed decision-making. This position requires a strong customer focus, with the ability to understand unique business needs, deliver user-friendly solutions, and ensure seamless implementation in support of the Air District's mission.

The Air District is currently recruiting for the following three (3) vacancies:

As a Senior Systems Analyst in the Enterprise Technology Solutions section, you will serve as a technical lead partnering with IT and cross-functional teams to design, implement, and maintain Power Platform solutions. This role is responsible for defining and documenting business requirements; architecting Power Apps and Power Automate workflows; implementing secure data integrations using Dataverse and other data sources; and developing Power BI dashboards that transform complex data into actionable insights.

In this capacity, you will lead project delivery by coordinating across diverse teams, managing competing priorities, tracking milestones, and resolving complex technical challenges. Success in this role requires the ability to communicate effectively with both technical and non-technical audiences, ensuring solutions are user-friendly, aligned with business needs, and capable of streamlining processes, improving data quality, and advancing the Air District's mission.

The Senior Systems Analyst (Database Administration) serves as the technical lead for enterprise database systems supporting all critical agency operations, reporting, and regulatory programs. This position is responsible for database architecture, administration, performance tuning, system reliability, data integration, security, backup and recovery, and database modernization initiatives.

The ideal candidate has strong experience administering Microsoft SQL Server environments, troubleshooting complex database issues, optimizing performance, and supporting enterprise applications in both on-premises and cloud-based environments.

The Senior Systems Analyst (Power BI Developer / Report Writer) serves as the technical lead for enterprise reporting, analytics, dashboard development, and business intelligence solutions supporting agency operations and decision-making. This position works closely with business stakeholders to design, develop, optimize, and maintain Power BI reports, dashboards, semantic models, and data visualizations. The role also supports data analysis, reporting automation, and enterprise analytics initiatives using modern Microsoft data platform technologies.

The ideal candidate combines strong Power BI technical skills with data analysis, SQL development, visualization design, and stakeholder communication abilities.

Hybrid Work Schedule - A schedule that meets the needs of our staff, department operations, and the communities we serve may be available depending on the assignment. Positions are not eligible to be fully remote

View the full classification specification here: https://www.governmentjobs.com/careers/baaqmd

About the Division
The Enterprise Technology Solutions Division provides technology, data, and digital services that support the Air District's mission and business operations. The division partners with departments across the organization to deliver secure, reliable, and innovative technology solutions that improve efficiency, support informed decision-making, and enhance services for staff, regulated entities, and the public.

The division is responsible for enterprise applications, data management, business intelligence, system integration, cloud technologies, digital services, records management, and information security. Teams within the division work collaboratively to modernize business processes, improve access to information, strengthen data governance, and ensure technology systems remain scalable, secure, and aligned with organizational priorities.

Current initiatives include expanding enterprise analytics capabilities, modernizing technology platforms, improving data accessibility and quality, supporting digital service delivery, and implementing innovative solutions that help the Air District operate more effectively and efficiently.

DISTINGUISHING CHARACTERISTICS

This is the advanced lead level in the systems analyst series. Incumbents perform complex work, provide lead direction to project teams, resolve complex issues and provide advanced technical solutions.

This class is distinguished from Principal Systems Analyst in that the latter provides a higher level of leadership and broader scope of responsibility. This class is also distinguished from Supervising Systems Analyst, in that the latter assigns, supervises, and evaluates the work of assigned staff on a continuing basis.

SUPERVISION RECEIVED AND/OR EXERCISED

Supervision is provided by a supervisor or manager. No supervision is exercised over others.

The following duties are typical for jobs in the class. They are for illustrative purposes only and do not reflect the full scope of job duties.

Provides lead direction, coordination, training and work review to staff on routine, continuing, or well-defined tasks.

Serves as a technical lead for complex IT projects, ensuring effective coordination and delivery.

Provides advanced systems analysis, design, and implementation for IT solutions.

Leads, designs, configures, and maintains enterprise IT systems, ensuring functionality and performance.

Develops strategies to enhance systems and address emerging business needs.

Leads, designs and implements CI/CD pipelines to streamline software development and deployment processes.

Develops automation scripts and tools to improve system reliability, scalability, and deployment speed.

Monitors and optimizes cloud and on-premises infrastructure to support development and operational needs.

Develops and maintains custom software applications to meet organizational needs, using programming languages such as Python, Java, or C#.

Integrates third-party APIs and tools into existing systems to enhance functionality and workflow efficiency.

Leads code reviews and collaborates with development teams to ensure high-quality software delivery.

Designs and manages data pipelines and ETL processes to support analytics and reporting functions.

Develops and optimizes database structures and queries for performance and scalability.

Ensures the security, integrity, and accessibility of data services across the organization, including compliance with data governance standards.

Resolves complex technical issues, including root cause analysis and system optimization.

Provides advanced troubleshooting for on-premises and cloud-based systems.

Collaborates with stakeholders to understand requirements and recommend solutions.

Prepares and delivers presentations, training, and technical documentation.

Ensures systems adhere to organizational policies and regulatory requirements.

Implements best practices for system security and data protection.

Leads IT initiatives, including planning, resource allocation, and tracking milestones.

Monitors project progress and provides updates to stakeholders.

Estimates level of effort across multiple IT disciplines.

Stays current with emerging technologies and identifies opportunities for innovation.

Conducts feasibility studies and prepares recommendations for system improvements.

Performs other related duties as assigned.

The items listed below are the minimum requirements for this classification.

Bachelor's degree from an accredited college or university in computer science, information technology, or a closely related field and three years of experience in IT systems analysis, design, and project management, including significant experience in complex IT environments.

Any equivalent combination of education and experience that provides the necessary qualifications to successfully perform the duties of the position will be considered.

Desired Qualifications:

LICENSES AND CERTIFICATIONS:

None.

OTHER REQUIREMENTS

Must be able to work standby and receive callback assignments outside of regular work hours.

KNOWLEDGE AND SKILLS

The minimum knowledge and skills needed to perform the essential duties of the classification.

Knowledge of:

System integration and interoperability principles.

Managing and maintaining IT infrastructure and systems.

Data transfer processes and database management.

Network principles and infrastructure to support data and application integration.

IT best practices to ensure sufficient and secure systems operations.

Cybersecurity principles to protect data.

Standard Query Language (SQL) servers, including the use of remote desktop tools.

Programming and markup languages.

Building solutions using Software as a Service (SaaS) platforms.

Advanced principles of systems analysis, design, and integration.

IT security best practices, including cybersecurity frameworks.

Project management methodologies and tools.

Database management and data analytics techniques.

Programming languages, software development processes, and tools.

Cloud computing platforms and virtualization technologies.

IT governance, compliance, and regulatory standards.

Skills in:

Leading technical projects and cross-functional teams.

Analyzing and resolving complex IT issues.

Communicating technical concepts to diverse audiences.

Developing and maintaining documentation, including technical specifications.

Managing multiple tasks and competing priorities effectively.

Establishing and maintaining effective working relationships with those contacted in the course of the work.

Translating technical requirements to non-technical stakeholders.

Analytical thinking and problem solving.

Effective verbal, written, and active listening communication skills.

Managing multiple projects with competing deadlines.

Installing, monitoring, and maintaining systems including relational database management software.

Installing and using system performance tools to determine hardware, software, communications and performance levels and making necessary adjustments.

Using various methods, procedures, techniques and programming languages involved in implementing, maintaining and fine-tuning computer hardware and software, communications systems and databases.

Exercising sound independent judgment and decision making within established guidelines.

How to Apply
Interested individuals must submit a completed Air District application and responses to the supplemental questionnaire by 5:00 p.m. on Tuesday, June 30, 2026. Resumes are encouraged, but not mandatory, and will not be accepted in lieu of the required application materials. Applications must be submitted online; please visit our website at www.baaqmd.gov/jobsto apply. Postmarked, faxed, 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.

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 Division 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 tono more than500 words 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 Air District may hire from this recruitment process to fill future vacancies occurring within the next 18 months.

Americans with Disabilities Act Accommodations
Persons with disabilities who may require reasonable accommodations during the application and/or selection process should notify the Human Resources Division at (415) 749-4980.

Equal Employment Opportunity
The Air District does not discriminate on the basis of race, national origin, ethnic group identification, ancestry, religion, age, sex, sexual orientation, gender identity, gender expression, color, genetic information, medical condition, or mental or physical disability, or any other attribute or belief protected by law. It is the Air District's policy to provide fair and equal access to the benefits of the programs or activities it administers.