LTCE Senior Systems Analyst (Power Platform)

Bay Area Air District; San Francisco (CA); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Bay Area Air District is seeking a Senior Systems Analyst (Limited Term) to lead Microsoft Power Platform initiatives in the Enterprise Technology Solutions Division. The role focuses on defining business requirements, building Power Apps and Automate workflows, and delivering secure data connections via Dataverse.

You will create Power BI dashboards and ensure ongoing performance and maintenance. The LTCE position emphasizes technical leadership, cross‑functional collaboration, and delivering

Qualifications

• Bachelor’s degree and three years of IT systems analysis, design, and project management in complex IT environments.
• Desirable: Power Platform design, development and deployment across Power Apps, Power Automate and Power BI.

Responsibilities

• Define and document business requirements; develop Power Apps and workflows.
• Integrate data connections using Dataverse and other sources.
• Create dashboards and reports with Power BI; ensure timely delivery and maintenance.
• Provide technical leadership and cross-functional collaboration on IT projects.

Skills

Power Platform

Technical leadership

Customer-focused

Power Apps

Power Automate

Education

Bachelor’s degree in CS/IT or related field

Tools

Power Apps

Power Automate

Power BI

Dataverse

Job 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 Air District is currently accepting applications for the position of Senior Systems Analyst(Limited Term) in the Enterprise Technology Solutions Division. This is an open recruitment for one (1) full-time, limited-term contract position. The position is anticipated for a 3-year term.

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 Air 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 Employee Association MOU, and LTCE employees serve on an at-will basis.

About the Position

The Air District is seeking a highly skilled Systems Analyst with expertise in Microsoft Power Platform to join the Enterprise Technology Solutions Division. In this role, you will collaborate with IT and cross-functional teams to design, implement, and maintain innovative Power Platform solutions. Responsibilities include defining and documenting business requirements, developing Power Apps and Power Automate workflows, integrating secure and efficient data connections using Dataverse and other 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 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.

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

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.

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.

Desirable Qualifications

• Extensive experience designing, developing, and deploying solutions using Microsoft Power Platform, including Power Apps, Power Automate, and Power BI, with demonstrated expertise in data visualization best practices.
• Proven ability to implement low-code/no-code solutions that streamline business processes, enhance data accuracy, and improve user experience.
• Strong understanding of Dataverse and integration with multiple data sources for secure and efficient data management.
• Experience establishing or contributing to a Power Platform Center of Excellence (CoE), including governance, standardization, and best practices for low-code/no-code development.
• Knowledge of application security and compliance requirements for cloud-based and web-based solutions.
• Familiarity with UI/UX principles, including accessibility standards (e.g., ADA compliance) for government organizations.
• Advanced problem-solving and data analysis skills, with the ability to design scalable and user-friendly solutions.
• Ability to work independently and collaboratively in cross-functional teams, providing technical leadership and customer-focused support.

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.

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 [phone].

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.