Design, build, and maintain scalable ETL/ELT pipelines and Snowflake data warehouse solutions using dbt, SQL, and Python. Develop data models, transformations, stored procedures, and database objects; optimize performance; implement ingestion, validation, governance, and data quality practices; and troubleshoot data issues. Collaborate with stakeholders and engineering teams while contributing to testing, deployment, code reviews, documentation, and analytics enablement.
Lead Data Engineer
Primary Skills
- BigTable, Cloud Functions, Cloud Spanner, GKE
Specialization
- GCP Data Engineer Advanced: Senior Data Engineer
Job requirements
- Design, build, and maintain scalable ETL/ELT data pipelines using DBT, SQL, and Python.
- Develop and optimize Snowflake-based data warehouse solutions for enterprise analytics and reporting.
- Create robust data models and transformation frameworks to support business requirements.
- Implement data ingestion, cleansing, transformation, and validation processes.
- Develop and maintain stored procedures, views, and database objects within cloud data platforms.
- Optimize SQL queries, data models, and pipelines for performance and scalability.
- Work closely with business stakeholders, analysts, and engineering teams to translate requirements into technical solutions.
- Monitor data quality and troubleshoot data-related issues across platforms.
- Leverage Snowflake features such as Snowpipe, Time Travel, Zero Copy Cloning, and Fail Safe.
- Participate in code reviews, testing, deployment, and documentation activities.
- Support data governance, security, and best practices across the data ecosystem.
- Strong hands-on experience with Snowflake Data Warehouse.
- Experience with:
- Snowpipe
- Zero Copy Cloning
- Time Travel
- Fail Safe
- SnowSQL
- Data Sharing/Data Exchange
- Performance tuning and optimization of Snowflake workloads.
- Strong expertise in DBT (Data Build Tool).
- Experience developing reusable transformation models.
- Understanding of DBT testing, documentation, and deployment practices.
- Advanced SQL skills with experience handling large-scale datasets.
- Expertise in query optimization, joins, analytical functions, and performance tuning.
- Experience with stored procedures and database development.
- Strong Python programming skills for data processing and automation.
- Experience with data engineering frameworks and scripting.
- Strong understanding of ETL/ELT concepts and modern data architectures.
- Experience in data warehousing and dimensional modeling.
- Knowledge of data governance, data quality, and metadata management.
- Experience with orchestration tools such as Airflow.
- Exposure to cloud platforms such as AWS, Azure, or GCP.
- Knowledge of CI/CD practices and Git-based version control.
- Experience with reporting and visualization tools such as Power BI, Tableau, or Looker.
- Exposure to AI/GenAI capabilities within data engineering solutions.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Snowflake SnowPro Certification
- DBT Certification
- AWS/Azure/GCP Data Engineering Certifications
- Databricks or Cloud Data Platform Certifications
Job Title: Data Engineer – Snowflake, DBT, Python & SQL
Experience
5–8 Years
Location
Bangalore / Hyderabad / Pune / Chennai / Gurgaon
Job Summary
We are seeking a skilled Data Engineer with strong expertise in Snowflake, DBT, SQL, and Python to design, develop, and maintain scalable data solutions. The ideal candidate will have hands-on experience building modern data pipelines, implementing data warehouse solutions, and enabling analytics through efficient data modeling and transformation practices.
Key Responsibilities
Required Skills
Snowflake
DBT
SQL
Python
Data Engineering
Preferred Skills
Educational Qualifications
Preferred Certifications
Primary Skills
Snowflake, DBT, SQL, Python
Secondary Skills
Data Modeling, ETL/ELT, Airflow, AWS/Azure/GCP, Power BI/Tableau, Data Warehousing
Brillio Chennai, Tamil Nadu, IND Office
Chennai, India
Similar Jobs
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Lead independent manual and automated quality assurance testing for software projects. Develop and contribute to Java-based automation frameworks using BDD, Cucumber, Selenium, and related tools. Execute diverse tests, analyze failures, identify root causes, manage defects through closure, and ensure accurate test documentation. Collaborate with developers on feature-branch certification, apply AI tools, and support agile delivery while maintaining quality, timelines, and customer-focused technology solutions.
Top Skills:
Ai ToolsAmazon EksBddCucumberDevOpsDockerGoogle Cloud Platform (Gcp)JavaJmeterKubernetesSeleniumTest Management Systems
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads delivery of enterprise conversational AI platforms, including chatbots and voice bots. Oversees Agile execution, technical architecture, cloud-native engineering, CI/CD, Terraform, Responsible AI, and AI adoption. Partners with product, security, architecture, and business teams while managing risks and executive communication. Mentors engineers and technical leads, supports hiring and performance management, and ensures scalable, secure, compliant, and operationally excellent solutions.
Top Skills:
Agentic AiAmazon ConnectAmazon LexAWSAzureCcaasCi/CdConversational AiDevOpsDevsecopsFive9Generative AiGenesysGoogle AdkGCPGoogle DialogflowLlmsNiceNode.jsPythonRagShift-Left EngineeringTerraformTypescript
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Leads quality engineering for contact center, BOT, RPA, and enterprise applications. Owns test strategy, planning, automation, performance testing, deployment validation, release readiness, and post-release monitoring. Develops and maintains automated scripts, enhances testing frameworks, establishes QA governance and metrics, analyzes quality trends, and mentors QA teams. Collaborates with technical and business stakeholders while applying AI tools, CI/CD, and DevOps practices to improve quality and scalability.
Top Skills:
AIApi TestingBotC#Ci/CdCyaraDatabase TestingDevOpsIntegration TestingJavaJavaScriptPerformance TestingPythonRpaUi Testing
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
