Snowflake enterprise architect

What is it for you?
As an Enterprise Architect, you will be a part of an Agile team to design and build healthcare
applications and implement new features while adhering to the best coding development
standards.
Location: -
 Mumbai
 Pune
 Bangalore
 Chennai
Experience : - 18 to 24 Years
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.
Qualifications:
 Bachelor’s degree in computer science, Information Technology, or a related field.
 18+ 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, datawarehousing, 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
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, Data Stage, Abinitio, SSIS
 Real-time Streaming & Batch Processing
 Data Warehousing
 Cloud Platforms (Azure, AWS, GCP)
 Dev Ops & CI/CD