Snowflake Data Architect

Who we are:

At CitiusTech, we constantly strive to solve the industry's greatest challenges with technology, creativity, and agility. With over 8,500 healthcare technology professionals worldwide, CitiusTech powers healthcare digital innovation, business transformation, and industry-wide convergence for over 140 organizations through next-generation technologies, solutions, and products. We aim to accelerate the transition to a human-first, sustainable, and digital healthcare ecosystem with the world's leading Healthcare and life sciences organizations and our partners.

Our vision:

To inspire new possibilities for the health ecosystem with technology and human ingenuity.

Role: Snowflake Data Architect

Job Description

Snowflake Data Architect (Snowflake Managed Iceberg Tables, dbt, Fivetran)

Role Summary

The Snowflake Data Architect (Snowflake Managed Iceberg Tables, dbt, Fivetran) designs, builds, and governs a secure, scalable, and cost-optimized Snowflake data Data with an automation‑first mindset.

This role owns Data architecture, observability, governance, and security-by-design principles. It also enables open table format capabilities (Iceberg on AWS S3 using Snowflake-managed Iceberg tables) to support interoperable analytics and next-generation data products.

Primary outcomes:

• Faster and safer Data changes
• High reliability & performance
• Predictable cost controls
• Governed data sharing
• Strong enablement for analytics, AI/ML & cross-cloud workloads

Experience Requirement

12–16 years of total experience, with at least 4–5 years of hands-on, relevant experience with Snowflake.

Key Responsibilities

1) Snowflake Data Architecture & Strategy

• Define and evolve Snowflake reference architectures across environments (dev/test/prod) and multi-account/multi-region setups.
• Establish Data standards for:
• Database/schema strategy, naming conventions, domain alignment
• Virtual warehouse strategy (workload isolation, autoscaling, multicluster, concurrency optimization)
• Data lifecycle policies (retention, time travel, fail-safe, archival)
• Architect for scalability, resilience, cost efficiency, and operational simplicity.
• Guide adoption of Snowflake-managed Iceberg tables with AWS S3 storage.

2) Security, Governance & Compliance by Design

• Build and enforce least privilege RBAC, including Separation of Duties across develop/approve/deploy functions.
• Implement end-to-end security controls:
• Masking & tokenization
• Row/column-level security
• Secure views, data contracts, and cross-cloud secure sharing
• Implement security integrations (IAM, network policies, private endpoints) and ensure audit-ready Data & pipeline designs for HIPAA, SOC2, GDPR, or similar frameworks.

3) Observability, Reliability & Operational Excellence (SRE Mindset)

• Design full-stack observability across Snowflake & pipeline ecosystems:
• Warehouse utilization, concurrency, query latency
• Cost monitoring (credit spikes, workload inefficiencies)
• Pipeline health, SLA/SLO metrics, lineage insights
• Build operational playbooks including:
• Incident response and escalation
• Root-cause analysis (RCA)
• Preventative controls and self-healing patterns
• Guide implementation of on-call readiness, runbooks, and operational dashboards.

Preferred Skills

• Deep expertise in Snowflake internals, dbt, performance tuning & governance
• Strong understanding of Iceberg, open table formats & lakehouse patterns
• Expertise in AWS S3, IAM, networking, and cross-cloud integration
• Strong understanding of enterprise DevOps, compliance, audit, and data governance

Life at CitiusTech:

We focus on building highly motivated engineering teams and thought leaders with an entrepreneurial mindset, centered on our core values of Passion, Respect, Openness, Unity, and Depth (PROUD) of knowledge. Our success lies in creating a fun, transparent, non-hierarchical, diverse work culture that focuses on continuous learning and work-life balance. Rated by our employees as the Great Place to Work according to the Great Place to Work survey. We offer you a comprehensive set of benefits to ensure that you have a long and rewarding career with us.

Our EVP:

Be You Be Awesome is our EVP and it reflects our continuing efforts to create CitiusTech as a great place to work where our employees can thrive, both personally and professionally. It encompasses the unique benefits and opportunities we offer to support your growth, well-being, and success throughout your journey with us and beyond. Together with our clients, we are solving some of the greatest healthcare challenges and positively impacting human lives. Welcome to the world of Faster Growth, Higher Learning, and Stronger Impact.