Clean Power Alliance

Data and Systems Architect

Clean Power Alliance

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $158,711 - $238,065 per year

About the role

  • 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.

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.
  • Experience enabling BI platforms with Tableau preferred.
  • 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.
  • Proficient with data visualization tools and software (i.e., Tableau, Power BI).
  • 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.
Benefits
  • health care
  • a 401(k)-like match program
  • paid vacation
  • sick leave
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SnowflakeAWSDatabricksPythonSQLdata modelingdata visualizationTableauSparkcloud architecture
Soft Skills
integrityprofessionalismconfidentialitytask ownershipprioritizationdeadline managementproblem-solvingcommunicationleadershipcollaboration