Data Architect

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