Data and Systems Architect

Role Overview

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

Tech Stack

• AWS
• Azure
• Cloud
• Cyber Security
• Linux
• Python
• Spark
• SQL
• Tableau

Benefits

• health care
• a 401(k)-like match program
• paid vacation
• sick leave