Data Architect (Snowflake / dbt / AWS)

Snowflake, dbt-core, Streamlit, AWS, Terraform, GitHub, GitHub Actions, CI/CD, Python, SQL Server, Informatica PowerCenter/IICS. Equivalent experience with comparable tools and platforms will also be considered.

Hiring Manager Notes:

• Streamlit is a big plus, please look for it in addition to the rest of the tech stack
• Depth and Breadth, CI/CD and hands-on as well as strategic
• Snowflake, DBT, IICS, AWS, Terraform, Python
• Looking for more Solutions Architecture experience, Supporting large-scale modernization initiative for our Revenue Management & Pricing Analytics platform., * We are seeking a Senior Architect to help lead a large-scale modernization initiative for our Revenue Management & Pricing Analytics platform.
• This role will support legacy system migrations to dbt-core and Snowflake, modernization of legacy tooling into modern web applications, and restructuring existing dbt models into a medallion architecture.
• The Senior Architect will design solutions aligned with enterprise data architecture standards and help define new patterns where standards need to evolve.
• This is a hands-on technical leadership role focused on building scalable infrastructure, data pipelines, deployment patterns, and reusable frameworks that can be adopted across the broader organization.

Principle Responsibilities:

• Solution Architecture: Design end-to-end technical solutions for the platform modernization initiative, ensuring alignment with enterprise data architecture standards.
• Standards and Governance: Apply existing architecture standards where appropriate and define new patterns where gaps exist, such as Streamlit application deployment and CI/CD practices.
• Cloud and Infrastructure as Code: Design and build modular, multi-environment AWS infrastructure using Terraform to support computing, storage, and orchestration needs.
• CI/CD Engineering: Build and maintain reusable, secure deployment pipelines using GitHub Actions for data pipelines and application deployments.
• Monitoring & Observability: Design monitoring, auditing, and alerting mechanisms across the pipeline and infrastructure to ensure reliability, traceability, and rapid issue detection.
• Data Platform Modernization: Lead the technical approach for migrating legacy processes and Informatica PowerCenter/IICS to dbt-core and Snowflake while restructuring models into bronze, silver, and gold layers.
• Documentation: Maintain clear architecture diagrams, design decisions, runbooks, and technical documentation for the platform, ensuring knowledge is accessible and current for engineers and stakeholders.
• Technical Leadership: Review code and pull requests, participate in daily meetings, sprint ceremonies and shape deliverables, and serve as a technical escalation point across the modernization initiative.

• 5+ years of experience in a senior data or software architecture role, with production experience across cloud infrastructure, data platforms, and application development.
• 5+ years of experience with legacy ETL/ELT platforms such as Informatica PowerCenter or IICS, with the ability to analyze & translate existing mappings/workflows.
• Strong hands-on experience with building/supporting dbt-core and Snowflake
• Experience with building components for medallion architecture, including bronze, silver, and gold data layers.
• Proficiency in Python, with experience building or supporting web applications such as Streamlit.
• Strong hands-on experience with Infrastructure as Code for modular, multi-environment cloud infrastructure.
• Experience with CI/CD platforms and modern DevOps practices.

Nice to have / bonus skills (not mandatory):

• Understanding machine learning concepts and how ML workflows integrate with data platforms.
• Experience with data product design and delivery, including treating datasets and pipelines as consumable products.
• Data modeling skills beyond medallion architecture layers, including dimensional modeling and star schema design.
• Knowledge of R scripting, Snowflake/AWS certifications.