Job Description

We are seeking an experienced Data Architect to lead the d data architecture and modeling, with a focus on Snowflake and Matillion.The ideal candidate for this position is pro-active, self-directed, team player and passionate.

Task Desciption

Design and implement end-to-end data architecture leveraging Snowflake and Matillion for data ingestion, transformation, and storage. Define and maintain data modeling standards, data flows, and architecture best practices (dimensional, normalized, star/snowflake schemas). Lead the evaluation and adoption of tools in the modern data stack, ensuring alignment with business goals and future scalability. Collaborate with data engineers, analysts, and stakeholders to define data requirements and create robust data pipelines. Ensure data security, access controls, and compliance with governance frameworks (e.g., GDPR, HIPAA, SOC 2). Optimize performance of Snowflake through clustering, caching, query tuning, and cost management. Oversee data integration strategies from multiple sources (APIs, databases, flat files, third-party platforms). Establish data quality and metadata management practices across platforms. Act as a subject matter expert and provide guidance on Matillion orchestration, reusable job frameworks, and job performance optimization
Required Qualifications

5+ years of experience in data engineering, architecture, or similar roles. Proven expertise with Snowflake (multi-cluster warehouse design, role-based access, data sharing, etc.). Strong experience designing and implementing pipelines with Matillion ETL. Proficient in data modeling and building scalable cloud data platforms. Deep understanding of ELT/ETL design patterns and orchestration principles. Strong SQL and scripting (e.g., Python or Bash) skills. Hands-on experience with cloud platforms (preferably AWS or Azure). Familiar with CI/CD, version control (Git), and infrastructure-as-code (e.g., Terraform, CloudFormation).
Preferred Qualifications

Experience with dbt, Airflow, or other orchestration and transformation tools. Knowledge of BI/reporting tools (e.g., Power BI, Tableau, Looker). Familiarity with data governance and data catalog solutions (e.g., Alation, Collibra, Atlan). Background in supporting machine learning platforms and real-time data pipelines. Industry experience in [finance, healthcare, retail, etc. -- can be customized].
NICE TO HAVE:

Very good communication skills and can do attitude. Very good analytical skills and structured approach (Detail-oriented). Organizational skills, team player. Ability to work independently, with self-motivation and self-confidence. Comfortable working in a fast-paced environment. Ability to time manage efficiently to avoid over-commitments. Strong customer centric mindset. Fluent English (written and spoken).
Job Type: Full-time

Pay: ₹2,000,000.00 - ₹3,000,000.00 per year

Education:

Master's (Preferred)
Experience:

SQL: 6 years (Required) Python: 6 years (Required) CI/CD: 6 years (Required) ETL: 6 years (Required) Azure: 6 years (Required) AWS: 6 years (Required) Power BI: 6 years (Required) Tableau: 6 years (Preferred)
Language:

English (Required)
Work Location: Remote