Offshore Data Architect

Key Responsibilities:

Data Architecture & Design:

• Design end-to-end data architectures including ingestion, transformation, storage, analytics, and consumption layers.
• Define logical, physical, and canonical data models aligned with business requirements.
• Architect scalable and secure cloud-based data platforms using Snowflake and related services.
• Establish data standards, best practices, and architectural guidelines for offshore delivery teams.
• Lead Dataiku DSS projects for data preparation, feature engineering, analytics, and ML workflows.
• Design reusable Dataiku recipes, flows, and automation pipelines.
• Integrate Dataiku with Snowflake, cloud storage, APIs, and third-party data sources.
• Implement Dataiku governance, versioning, collaboration, and deployment strategies.
• Optimize Dataiku performance and resource utilization.

Snowflake Architecture & Engineering:

• Architect and implement Snowflake data warehouses, including databases, schemas, warehouses, and roles.
• Design optimized Snowflake data models (star, snowflake, hybrid).
• Implement Snowflake features: Streams & Tasks, Time Travel, Zero Copy Cloning, Secure Data Sharing.
• Ensure performance tuning, cost optimization, and workload isolation.
• Define Snowflake security, access controls, and data masking policies.

ETL / Data Integration:

• Architect and implement ETL/ELT pipelines using Dataiku and other ETL tools.
• Design ingestion frameworks for batch, near real-time/streaming, and API/file-based integrations.
• Handle complex data transformations, validations, and reconciliations.
• Ensure data quality, lineage, and auditability across pipelines.

Governance & Compliance (Good to Have):

• Define data governance frameworks, including metadata management and lineage.
• Implement data quality checks, validation rules, and monitoring.
• Ensure compliance with security and regulatory standards (PII, GDPR, etc.).
• Support audit and compliance requirements.