Snowflake Administration &

- Optimization:

· Optimize Snowflake performance, query efficiency, cost/credit utilization, and overall data architecture.

· Implement best practices for data security, governance, backup/disaster recovery, and zero copy cloning.

 Data Transformations with dbt:

· Design, develop, and maintain production-grade dbt models (SQL) to transform raw data into clean, documented, and tested analytics datasets.

· Implement automated testing, documentation, and data quality checks within dbt project workflows.

 PostgreSQL Database Management:

· Design, configure, tune, and maintain production PostgreSQL databases.

· Monitor performance, execute index tuning, manage schema migrations, and maintain high availability.

 Data Operations &

- Analytics Support:

· Build and maintain efficient ELT pipelines connecting PostgreSQL, Snowflake,

and downstream analytics tooling.

· Support the analytics team by developing or optimizing semantic models and dashboards in Sigma or Power BI (nice-to-have).

Qualifications &

Requirements Must-Haves:

 Snowflake DBA / Platform Admin Experience:





· 5+ years of hands-on experience administering and tuning enterprise-level

Snowflake environments.

 dbt (data build tool) Expertise:

· Hands-on experience building, testing, and deploying data transformation models with dbt Core or dbt Cloud.

 PostgreSQL Administration:

· Robust practical experience managing, indexing, and tuning PostgreSQL databases.

 SQL Mastery &

- Data Modelling:

· Deep understanding of advanced SQL, dimensional modeling (Kimball methodology), and analytical query optimization.

Nice-to-Haves:

· BI / Visualization Experience: Hands-on experience building reports,

dashboards, or semantic models in Sigma or Microsoft Power BI.

 Logistics &

- Supply Chain Domain Knowledge:

· Exposure to logistics concepts (e.g., shipment tracking, warehouse management, freight operations, supply chain KPIs).

· Data Engineering Tooling: Experience with orchestration tools (e.g., Airflow,

Dagster, Prefect) and Git workflows.

📌 DataEngineer_Snowflake (Bengaluru)
🏢 Trigent Software
📍 Bengaluru