Lead Consultant - Engineer (DBT+Snowflake)

Ready to shape the future of work
At Genpact we dont just adapt to changewe drive it. AI and digital innovation are redefining industries and were leading the charge. Genpacts AI Gigafactory our industry-first accelerator is an example of how were scaling advanced technology solutions to help global enterprises work smarter grow faster and transform at scale. From large-scale models to agentic AI our breakthrough solutions tackle companies most complex challenges.
If you thrive in a fast-moving tech-driven environment love solving real-world problems and want to be part of a team thats shaping the future this is your moment.
Genpact (NYSE: G) is an advanced technology services and solutions company that delivers lasting value for leading enterprises globally. Through our deep business knowledge operational excellence and cutting-edge solutions we help companies across industries get ahead and stay ahead. Powered by curiosity courage and innovation our teams implement data technology and AI to create tomorrow today. Get to know us at and on LinkedIn X YouTube and Facebook.

Inviting applications for the role of Lead Consultant - Engineer (DBTSnowflake)
!
In this role the Engineer is responsible for providing technical direction and lead a group of one or more developer to address a goal.

Job Description:
Develop implement and optimize data pipelines using Snowflake with a focus on Cortex AI capabilities.
Extract transform and load (ETL) data from various sources into Snowflake ensuring data integrity and accuracy.
Implement Conversational AI solutions using Snowflake Cortex AI to facilitate data interaction through ChatBot agents.
Collaborate with data scientists and AI developers to integrate predictive analytics and AI models into data workflows.
Monitor and troubleshoot data pipelines to resolve data discrepancies and optimize performance.
Utilize Snowflakes advanced features including Snowpark Streams and Tasks to enable data processing and analysis.
Develop and maintain data documentation best practices and data governance protocols.
Ensure data security privacy and compliance with organizational and regulatory guidelines.

Roles and Responsibilities:
Bachelors degree in Computer Science Data Engineering or a related field.
experience in data engineering with at least 3 years of experience working with Snowflake.
Proven experience in Snowflake Cortex AI focusing on data extraction chatbot development and Conversational AI.
Strong proficiency in SQL Python and data modeling.
Experience with data integration tools (e.g. Matillion Talend Informatica).
Knowledge of cloud platforms such as AWS Azure or GCP.
Excellent problem-solving skills with a focus on data quality and performance optimization.
Strong communication skills and the ability to work effectively in a cross-functional team.
Proficiency in using DBTs testing and documentation features to ensure the accuracy and reliability of data transformations.
Understanding of data lineage and metadata management concepts and ability to track and document data transformations using DBTs lineage capabilities.
Understanding of software engineering best practices and ability to apply these principles to DBT development including version control code reviews and automated testing.
Should have experience building data ingestion pipeline.
Should have experience with Snowflake utilities such as SnowSQL SnowPipe bulk copy Snowpark tables Tasks Streams Time travel Cloning Optimizer Metadata Manager data sharing stored procedures and UDFs Snowsight.
Should have good experience in implementing CDC or SCD type 2
Proficiency in working with Airflow or other workflow management tools for scheduling and managing ETL jobs.
Good to have experience in repository tools like Github/Gitlab Azure repo

Skill Matrix:

DBT (Core or Cloud) Snowflake AWS/Azure SQL ETL concepts Airflow or any orchestration tools Data Warehousing concepts

Qualifications/Minimum qualifications
B.E./ Masters in Computer Science Information technology or Computer engineering or any equivalent degree with good IT experience and relevant of working experience as a Sr. Data Engineer with DBTSnowflake skillsets

Why join Genpact
Be a transformation leader Work at the cutting edge of AI automation and digital innovation
Make an impact Drive change for global enterprises and solve business challenges that matter
Accelerate your career Get hands-on experience mentorship and continuous learning opportunities
Work with the best Join 140000 bold thinkers and problem-solvers who push boundaries every day
Thrive in a values-driven culture Our courage curiosity and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress
Come join the tech shapers and growth makers at Genpact and take your career in the only direction that matters: Up.
Lets build tomorrow together.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race color religion or belief sex age national origin citizenship status marital status military/veteran status genetic information sexual orientation gender identity physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity customer focus and innovation.
Furthermore please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit paying to apply or purchasing equipment or training.