Senior DBT Engineer

Job Description

Job Description: Senior DBT Engineer Job Location : Hyderabad / Bangalore / Chennai / Kolkata / Noida/ Gurgaon / Pune / Indore / Mumbai Responsibilities: - Experience Level - 4 -12 years. - Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting. - Design, develop, and maintain ETL/ELT pipelines using DBT and pulling data from Snowflake. - Define and implement data modelling best practices, including data warehousing, ETL processes, and data transformations using DBT. - Build complex SQL queries within DBT to build incremental models, enhancing data processing efficiency. - Establish data governance practices and ensure data accuracy, quality, and consistency within the data transformation process. - Collaborate with data engineers, data analysts, and other stakeholders to understand and meet data requirements for various business units. - Identify and address performance bottlenecks in data transformation processes and optimize DBT models for faster query performance. - Maintain thorough documentation of DBT models, transformations, and data dictionaries to ensure transparency and accessibility to team members. - Implement data security measures to protect sensitive information and comply with data privacy regulations. - Stay updated on industry best practices and new features in DBT, and continuously improve the data transformation processes. - Provide training and support to other team members in using DBT effectively. - Implement data quality checks and validation processes to ensure data accuracy and consistency. - Hands-on experience in implementing data governance, data quality rules and validation mechanisms within Collibra is added plus. - Knowledge of workflow orchestration tools like Tidal. - Experience with Python or other scripting languages is a plus. - Familiarity with Azure cloud platforms. - Exposure to DevOps practices and CI/CD pipelines for data engineering. Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf. More information on employment scams is available here .