06 Nov
|
TRIGENT SOFTWARE PRIVATE
|
India
06 Nov
TRIGENT SOFTWARE PRIVATE
India
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 (India)
🏢 TRIGENT SOFTWARE PRIVATE
📍 India