Snowflake & AWS Data Architect with Ontology Modeling

Cephas Consultancy Services Private Limited; Houston (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Cephas Consultancy Services Private Limited in Houston, TX is seeking a Snowflake Architect or Data Architect to design, build, and scale a modern cloud data platform centered on Snowflake and AWS. The ideal candidate will combine deep data engineering fundamentals with governance and ontology-driven modeling to deliver trusted data products.

You will work on strategic initiatives using Snowflake, AWS, Iceberg managed tables, Snowflake Catalog and Horizon, Informatica, and dbt to enable

Qualifications

• Extensive experience in data engineering, modeling, and cloud platform development.
• Hands-on Snowflake implementation, optimization, and security controls.
• Experience with AWS cloud environments and data integration platforms.
• Proficiency with dbt for transformations and analytics engineering workflows.
• Familiarity with Iceberg and open table formats for scalable data lakes.
• Knowledge of ontology, semantic modeling, and governance concepts.
• Strong SQL and Python skills; stakeholder collaboration.

Responsibilities

• Design, build, and maintain scalable data pipelines across data sources.
• Develop ingestion and ELT processes using Informatica.
• Create transformation logic with dbt including testing and docs.
• Design data structures in Snowflake and manage warehouse patterns.
• Collaborate with AWS services to support data products.
• Implement data governance, lineage, and quality checks.
• Support analytics, BI, and AI use cases with trusted data.

Skills

Data engineering

Data modeling

ETL/ELT

Snowflake

AWS

Informatica

dbt

Apache Iceberg

Data governance

Ontology/semantic modeling

SQL

Python

Tools

Snowflake Catalog

Snowflake Horizon

dbt (analytics engineering)

Job description

Cephas Consultancy Services Private Limited in Houston, TX is seeking a Snowflake Architect or Data Architect to design, build, and scale a modern cloud data platform centered on Snowflake and AWS. The ideal candidate will combine deep data engineering fundamentals with governance and ontology-driven modeling to deliver trusted data products.

You will work on strategic initiatives using Snowflake, AWS, Iceberg managed tables, Snowflake Catalog and Horizon, Informatica, and dbt to enable