Data and Systems Architect

Clean Power Alliance

8d•$158,711 - $238,066•Hybrid

About The Position

CPA is seeking an experienced, detail-oriented, and enthusiastic professional to join our growing team as Data and Systems Architect. The Data and Systems Architect will design, optimize, and govern modern cloud based data platforms with a strong emphasis on performance, scalability, and cost efficiency. This role will lead architecture decisions across Snowflake, AWS, Databricks, and Tableau, ensuring the organization maximizes the value of its data investments while maintaining predictable and sustainable platform costs. The ideal candidate combines deep technical expertise with financial discipline, understands cloud consumption-based pricing models, and proactively designs architectures that balance business needs with cost control.

Requirements

Strong hands‑on experience with Snowflake, including performance tuning and cost optimization.
Mastery of Python.
Deep understanding of AWS pricing models and architectural tradeoffs.
Proven experience designing and operating Databricks workloads cost‑effectively.
Advanced SQL and strong data modeling expertise.
Proficient with Microsoft Office Suite.
Ability to act with integrity, professionalism, and confidentiality.
Ability to fully own tasks and processes with minimal oversight.
Ability to handle multiple priorities to meet deadlines and escalate key issues.
Well-versed in cloud environments, data engineering, systems engineering and operations, best-practice data governance and security, data privacy regulations, and interface strategies.
Deep understanding of the interactions between systems and how business processes are enabled and impacted by those systems.
Experience or course work with Cloud platform data services including Amazon Web Services, Google Cloud, or Microsoft Azure; cloud platform data storage and management tools; Linux configuration; SQL databases.
Candidates must have a bachelor’s degree in information technology, computer science, information systems, or a related field and a minimum of 5 years of experience in data design, management, and storage work
Demonstrate good judgment and integrity
High attention to detail with strong organizational skills
Communicate effectively, orally, and in writing; and the ability to translate complex technical information into non-technical language
Have a strong work ethic and be comfortable taking initiative/working in a fast paced, start-up environment
Work well on diverse teams and be highly collaborative
Must be able to work at a desk and on a computer for prolonged periods

Nice To Haves

Experience enabling BI platforms with Tableau preferred.
Proficient with data visualization tools and software (i.e., Tableau, Power BI).
A Master’s Degree and start-up experience is highly desired.

Responsibilities

Data Architecture & Platform Design: 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.
Systems Management and Oversight: 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.
Cost Optimization: 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.
Continuous Improvement: 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.