We are seeking an experienced Data Architect to lead the 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 Description :

- 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).