Description :

Designation : BI Engineer (dbt / SQL / Python)

Company : DigiMantra

Experience : 4+ Years

Budget : as per market standard

Key Responsibilities :

- Design and implement ELT/ETL pipelines and curated datasets to support analytics and reporting.

- Build and maintain data build tool (dbt) projects (models, tests, documentation, exposures, snapshots as applicable).

- Develop performant SQL transformations and optimize warehouse cost/performance.

- Use Python for data processing, automation, API integrations, and orchestration tasks as needed.

- Work with semi-structured data (JSON) including parsing, flattening, and modeling for analytics use.

- Implement strong data quality practices : dbt tests, auditing, monitoring, and incident response.

- Collaborate with analysts and stakeholders to define canonical metrics and data contracts.

Required Skills :

- Strong SQL (joins, window functions, CTEs, performance tuning, incremental patterns).

- dbt experience : model structure, macros, sources, tests, documentation, environments, CI patterns (preferred)

- Python proficiency : building maintainable scripts/modules; working with APIs and files.

- Experience working with JSON/semi-structured data (extract/transform/flatten patterns).

- Familiarity with version control (Git) and PR-based workflows.

- Ability to produce clear documentation and handoffs; strong ownership mindset.

Nice to Have :

- Snowflake experience (plus) : clustering/partitioning concepts, warehouses, roles/permissions, tasks, streams, Snowpark exposure

- Orchestration tools (Airflow, Dagster, Prefect, dbt Cloud jobs, etc.)

- Experience with data observability/monitoring (tests + alerting)

- Knowledge of dimensional modeling and analytics engineering best practices

- Experience supporting BI tools (Power BI datasets, semantic models)