DBT Admin

Nexify Infosystems; Hyderabad; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Nexify Infosystems is seeking an experienced Data Engineer - DBT Admin to design, manage, and optimize data transformation pipelines in a financial environment. The role emphasizes dbt administration, SQL, Python, and cloud-based data platforms, with collaboration across stakeholders and production support teams.

The candidate should have 4-5 years of hands-on data engineering experience, strong problem-solving skills, and the ability to work with USA EST hours from Hyderabad.

Qualifications

• 4-5 years of hands-on Data Engineering experience with DBT administration.
• Strong SQL skills and ability to build complex transformations.
• Proficient Python for automation and data processing.
• Experience with cloud data platforms and data warehousing concepts.
• Knowledge of ETL/ELT processes and CI/CD practices.
• Production support, monitoring, and data quality activities.

Responsibilities

• Administer, maintain, and optimize DBT environments and deployments.
• Develop and support scalable data pipelines using DBT.
• Create complex SQL queries and data models.
• Develop Python scripts for automation and monitoring.
• Manage dbt jobs, scheduling, testing, and documentation.
• Troubleshoot data pipelines and production issues.
• Collaborate with business and tech teams on data requirements.
• Support data validation, governance, and security requirements.
• Monitor daily Data Ops and Production Support activities.
• Participate in release deployments and code reviews.
• Coordinate with EST client teams during US business hours.

Skills

DBT administration

SQL

Python

Cloud data platforms

ETL/ELT

Data warehousing

CI/CD

Git

Data governance

Data quality

Communication

Education

Bachelor's Degree in Computer Science/IT/Engineering

Tools

Snowflake

AWS

Airflow

Job description

Note: Must be local to Hyderabad, willing to work in the EST time zone, and available to join with a maximum one-month notice period.

About Us

We are seeking an experienced and detail-oriented Data Engineer - DBT Admin. The ideal candidate will have strong expertise in dbt administration, SQL, and Python, along with hands-on experience in modern data engineering and cloud-based data platforms.

The candidate will play a critical role in designing, managing, optimizing, and supporting enterprise data transformation pipelines and analytics workflows. This role requires close collaboration with client stakeholders, Data Engineers, Analysts, QA teams, and Production Support teams in a fast-paced financial environment.

Job Responsibilities

• Administer, maintain, and optimize DBT environments, projects, and deployments.
• Develop, enhance, and support scalable data transformation pipelines using DBT.
• Build and optimize complex SQL queries, stored procedures, and data models.
• Develop Python scripts/utilities for automation, monitoring, and operational support.
• Manage dbt jobs, scheduling, dependencies, testing, and documentation.
• Troubleshoot and resolve data pipeline failures, performance bottlenecks, and production issues.
• Collaborate with business users and technical teams to understand data requirements and implement solutions.
• Support data validation, reconciliation, and data quality initiatives.
• Monitor daily Data Operations and Production Support activities.
• Ensure adherence to data governance, security, and financial industry compliance standards.
• Participate in release deployments, code reviews, and change management activities.
• Coordinate with USA-based client teams during EST business hours.
• Prepare technical documentation, operational procedures, and support guides.
• This position involves collaborating with software development, operations and security teams to embed security controls into the software development lifecycle, monitor and respond to threats, mitigate vulnerabilities, and maintain regulatory compliance.

Required Skills

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or related field.
• 4-5 years of hands-on experience in Data Engineering and dbt Administration.
• Strong expertise in DBT (Data Build Tool) including setup, administration, modeling, testing, and deployment.
• Advanced SQL skills with experience handling large-scale datasets and complex transformations.
• Strong programming experience in Python for automation and data processing.
• Experience working with cloud-based data platforms and modern data warehouse technologies.
• Strong understanding of ETL/ELT processes, data warehousing, and data modeling concepts.
• Experience in production support, monitoring, and troubleshooting data pipelines.
• Familiarity with Git/version control and CI/CD practices.
• Excellent analytical and problem-solving skills.
• Strong verbal and written communication skills.

Preferred Skills

• Experience with Snowflake, AWS.
• Exposure to Airflow or enterprise scheduling/orchestration tools.
• Experience working with Financial Services or Banking domain clients.
• Knowledge of Agile/Scrum methodologies.
• Experience supporting enterprise analytics and reporting environments.

Work Requirements

• Mandatory Work From Office role based in Hyderabad.
• Must be willing to work Night Shifts aligned with USA EST business hours.
• Ability to work in a fast-paced, client-facing offshore support environment.
• Strong collaboration skills to work with onsite and offshore teams across multiple time zones.

Soft Skills

• Strong ownership and accountability mindset.
• Ability to lead critical production support situations calmly and effectively.
• High attention to detail and commitment to data accuracy.
• Strong team collaboration and stakeholder management skills.
• Self-motivated with the ability to work independently.