Clean Power Alliance

Systems Engineer

• Design and maintain end-to-end data architectures for analytics, reporting, and advanced data use cases across Snowflake, AWS, Databricks, and Tableau.
• Define architectural standards and reference patterns that optimize performance, scale, and total cost of ownership.
• Lead architectural decisions for Snowflake, Databricks, and AWS, including storage, compute separation, and workload isolation strategies.
• Continuously evaluate and refine architectures to prevent overprovisioning and uncontrolled cloud spend.
• Create and maintain architecture design documentation.
• Design Snowflake architectures that optimize warehouse sizing, concurrency, auto‑suspend/resume, clustering, and data retention.
• Implement Databricks cost controls including cluster policies, job optimization, workload separation, and efficient Spark configurations.
• Architect AWS solutions with careful consideration of storage tiers, lifecycle policies, and usage‑based services.
• Manage data storage and backup and recovery operations.
• Manage individual product updates, cybersecurity and IT policies, and management and control of data throughout the enterprise.
• Source project staff and consultants and oversee performance evaluation.
• Monitor performance of cloud systems to determine cost and productivity levels and to make recommendations for improving the IT infrastructure.
• Administer cloud-based infrastructure including identity and access management, user permissions, and billing optimization.
• Manage data storage and access needs, create and maintain databases, and upgrade database systems and software.
• Create, enhance, document, and manage continuous improvement initiatives across data architectures.
• Responsible for identifying inefficiencies, proposing solutions to senior leadership, and leading the implementation of new tools, automation, and reporting frameworks that enable the team to scale and improve various systems.
• Perform other duties as assigned.

Data and Systems Architect

Project Manager

• CPA is seeking a detail-oriented and highly motivated professional with experience in community-led and local government decarbonization efforts to join our team as the Project Manager, Local Government Programs.
• This role will manage and coordinate initiatives that support local government sustainability efforts, including innovative programs designed to accelerate electrification and clean energy adoption.
• The Project Manager will oversee key aspects of program implementation, including coordinating program enrollment, monitoring project progress, and managing stakeholder communications related to the Energized Communities program, focusing on the Electric Fleet and Innovation Fund initiatives.
• In this role, you will evaluate program performance, identify operational improvements, and collaborate with internal teams and external partners to ensure successful program delivery and alignment with CPA’s strategic goals.

Data and Systems Architect

Project Manager – Local Government Programs