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).(ref : hirist.tech)