CitiusTech - Snowflake Solution Architect

What is in it for you?

We are seeking an experienced Senior Solution Architect to join our team in the life sciences industry. The ideal candidate will possess a deep understanding of enterprise data architecture frameworks, cloud solutions, and the unique challenges and opportunities within the life sciences domain.

Responsibilities :

- Design scalable, secure, and cost-effective cloud data platforms leveraging Snowflake architecture.

- Architect solutions using Snowflake features such as virtual warehouses, storage layers, clustering, partitioning, and compute scaling.

- Design and implement multi-layered architecture (bronze, silver, gold) in Snowflake with clear data lineage.

- Design conceptual, logical, and physical data models using Erwin and Power Designer.

- Experience in data extraction and ingestion from various sources such as SAP, Salesforce, SQL server, APIs and other business applications

- Develop and optimize ETL/ELT processes for structured and unstructured data.

- Enable real-time streaming and batch processing

- Configure mapping data flows and parameterization for dynamic pipeline design.

- Develop and manage data pipelines, triggers, and integrations with various sources

- Optimize queries and implement strategies for performance tuning and cost management.

- Implement security measures including RBAC, data masking, and encryption within Snowflake.

- Establish and maintain CI/CD pipelines for data deployments, ensuring scalability and reliability.

- Create proof-of-concepts (POCs) that address business and technical needs and lead their transition to production-ready solutions.

- Serve as the primary technical contact during implementation, providing documentation and guidance to engineering teams.

- Assess legacy systems and plan schema conversion and data transformation strategies.

- Apply principles of modular architecture, dimensional modelling, normalization/denormalization, and metadata strategy.

- Produce architecture diagrams, migration plans, and standards documentation.

- Participate in code reviews to ensure quality, maintainability, and adherence to architectural standards.

- Engage in cross-team forums and meetings to resolve open issues and drive consensus.

- Collaborate with Project Managers and Leads to provide timely updates, flag risks, and ensure stakeholder alignment.

- Mentor and Coach Jr Architects & Engineers

- Collaborate with stakeholders to align business objectives with data strategies.

- Research and adopt modern architectures (Data Mesh, AI-ready platforms).

- Develop reusable libraries and frameworks to accelerate productivity.

- Evaluate tools, platforms, and vendors for modernization and migration initiatives.

- Develop technology roadmap considering current and future requirements.

Experience : 12 - 18 Years

Location :

- Mumbai

- Pune

- Chennai

Educational Qualifications :

- Bachelors or Masters degree in Computer Science/Information Technology/Biomedical Engineering or a related field .

- Technical certification in multiple technologies is desirable.

Skills :

Mandatory Technical Skills :

- Snowflake Cloud Data Platform and ecosystem services

- Snowflake Compute (Virtual Warehouses) & Snowpark

- Data Architecture Design

- Data Modelling

- Medallion Architecture (Bronze, Silver, Gold)

- Data Governance & Security Compliance

- Apache Spark

- Python & SQL Programming

- ETL/ELT Pipeline Design

- ETL tools like DBT, Matillion, Fivetran, Informatica, DataStage, Abinitio, SSIS

- Real-time Streaming & Batch Processing

- Data Warehousing

- Cloud Platforms (Azure, AWS, GCP)

- DevOps & CI/CD

Professional Experience :

- 12+ years of experience in data engineering and architecture, with strong expertise in cloud-based solutions.

- Proven track record in designing and implementing scalable data platforms across Azure, AWS, and GCP.

- Strong knowledge of data modelling, data warehousing, data governance, security compliance, and performance optimization.

- Ability to lead teams, mentor engineers, and drive strategic data initiatives.

- Familiarity with healthcare data standards and regulatory frameworks

- Snowflake Certifications

- Excellent communication and leadership skills

- Flexibility and teamwork mindset

- Evaluate and contribute to Data engineering proposals