Custom Software Engineer

Custom Software Engineer

Project Role : Custom Software Engineer
Project Role Description : Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.
Must have skills : Data Build Tool, Snowflake Data Warehouse
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education

Job Title: dbt (data build tool) developer (dbt / Snowflake / Fivetran / Maestro)

Role Overview:
We are looking for a dbt (data build tool) developer to develop ELT code for our Unified Data Platform (UDP), built on Snowflake.
The platform ingests data from multiple source systems using Fivetran and HVR, and processes it through multiple transformation layers using dbt, with Maestro as the orchestration and scheduling tool.
The ideal candidate will be responsible for responsible for developing DBT code for data pipelines, working on snowflake to manage/enchance/update UDP data and objects, migrating code across environments, performing unit testing, code reviews, scheduling code using orchestration tools and analyzing/resolving production issues.

Key Responsibilities:
- develop dbt (data build tool) code for client's unified data platform, which is built in snowflake
- develop end-to-end data pipelines and job executions in Maestro across ingestion (Fivetran/HVR) and transformation (dbt) layers.
- develop fivetran and HVR code to ingest data from source systems into UDP raw layer
- perform code reviews, migrate code by raising pull requests in azure devops
- Detect and triage failures or performance issues in data loads and transformations.
- Analyze root cause of recurring or complex issues and recommend long-term fixes or improvements.
- Communicate effectively with relevant teams — data engineering, platform, and business users — regarding work status, production issues.

Required Skills & Experience:
- 2-4 years of experience in dbt (data build tool) development
- 2-4 years of experience on snowflake with good understanding of data warehousing concepts
- Proficient in SQL
- Experience with job scheduling/orchestration tools (e.g., Maestro, Airflow, Control-M, etc.).
- Strong analytical and problem-solving skills with attention to detail.
- Excellent communication skills.
- Bachelor of engineering or equivalent degree in education required

Good to Have:
- Experience with Fivetran, HVR, or similar data integration tools.
- Knowledge of Cloud platforms (AWS/Azure/GCP).
- Familiarity with Git-based workflows and CI/CD pipelines for dbt.