Data Architect Job

Data Architect is needed to perform the following duties :

Data Architect (Snowflake and AWS Cloud)
o Data Architecture & Solution Design
• Design end-to-end data architecture using Snowflake as the primary cloud data platform.
• Create conceptual, logical, and physical data models for analytical, operational, and real-time workloads.
• Define data ingestion patterns (batch, CDC, streaming via Kafka/Kinesis/Snowpipe/Snowpipe Streaming).
• Architect warehouse, database, schema, stage, file-format structures following best practices.
• Design optimized ELT/ETL frameworks using Snowflake features such as Streams, Tasks, Stored Procedures, and DBT.
o Performance Optimization
• Optimize query performance using clustering, micro-partitioning awareness, pruning, and data modeling standards.
• Recommend warehouse sizing strategies, auto-scaling, multi-cluster settings, and caching techniques.
• Identify and resolve bottlenecks by analyzing query history, profile, dashboards, and performance metrics.
o Data Quality, Governance & Security
• Define data quality rules, validation frameworks, and audit logging (e.g., using DBT tests, BigEye, custom SQL, Snowflake tasks).
• Implement RBAC (roles, grants, least-privilege model) and secure-object frameworks.
• Architect Data Masking, row-level and column-level security, and Secure Views.
• Ensure compliance with GDPR, HIPAA, SOC2, and organizational data governance policies.
• Establish lineage, metadata, and catalog integration with tools like Collibra, Alation.
o Data Integration & Pipelines
• Work with ETL/ELT tools (DBT, Informatica, Matillion, Talend, DataStage, Glue, ADF).
• Design and govern pipelines for:
o Batch
o Near real-time
o Streaming ingestion
o Multi-source integration (RDBMS, APIs, structured/unstructured files).
• Create reusable pipeline templates, frameworks, and standards.
o Snowflake Best Practices & Standards
• Define naming conventions, folder/stage hierarchy, and warehouse usage patterns.
• Establish versioning, Dev/Test/Prod promotion, and CI/CD strategies.
• Maintain platform documentation, checklists, and architectural runbooks.
o Cost Management & Optimization
• Monitor and optimize Snowflake compute, storage, cloning, and Time-Travel overhead.
• Implement query-level cost governance, warehouse auto-suspend, and usage alerts.
• Provide monthly/weekly cost analysis reports and savings recommendations.
o Data Sharing & Collaboration
• Architect Private Shares, Direct Shares, and Snowflake Marketplace integrations.
• Design secure data exchange models between internal teams and external partners.
• Ensure cross-region, cross-cloud replication and failover/failback strategies.
o Architecture Reviews & Stakeholder Collaboration
• Work with business teams to translate requirements into scalable Snowflake designs.
• Conduct architecture reviews, POCs, and performance benchmarking.
• Guide developers, analysts, and modelers with Snowflake best practices.
• Present technical solutions to leadership, PMs, SMEs, and cross-functional teams.
o Administration & Operations
• Oversee account-level setup, including ORGs, Accounts, Resource Monitors, Warehouses.
• Support user onboarding, troubleshooting, and environment management.
• Ensure high availability, disaster recovery, replication, and monitoring.
o Innovation & Continuous Improvement
• Evaluate new Snowflake features and recommend adoption (Snowpark, Iceberg Tables, Cortex, Dynamic Tables).
• Improve architecture with modern practices: data contracts, medallion architecture, mesh-aligned domains.
• Promote automation, auditability, and operational efficiency.
o Participate in Daily Standups & Agile Ceremonies
• Actively contribute to daily standups, sprint planning, backlog refinement, and Jira-based scrums, ensuring smooth coordination with developers, analysts, and product owners.
o Lead Architecture & Design Workshops
• Conduct architecture workshops, technical deep dives, and whiteboard sessions to define scalable Snowflake solutions, data models, and end-to-end pipeline design patterns.
o Prepare and Review High-Level & Low-Level Design Documents
• Create, review, and validate HLD (High-Level Design) and LLD (Low-Level Design) documents, including data flow diagrams, integration patterns, security models, and performance guidelines.
o Facilitate Client Workshops & Technical Presentations
• Engage directly with clients through requirement-gathering workshops, roadmap discussions, demos, and architecture presentations, translating business needs into Snowflake-based solutions.
o Collaborate in Cross-Functional Team Meetings
• Participate in solution alignment meetings, cross-team architecture reviews, and stakeholder discussions to ensure consistent implementation across data engineering, cloud, analytics, and DevOps teams.
o Provide Technical Guidance & Sprint Support
• Offer daily technical guidance to the team, review Jira stories/tasks, support sprint deliverables, and ensure alignment to Snowflake best practices, governance standards, and performance requirements.

Bachelor’s degree is required in Computer Science or Computer Engineering or Computer Information Systems