
Data and Systems Architect
Clean Power Alliance
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
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