Lead Data Engineer DBT ,SQL, Snowflake , Tableau R
Job Summary
- ETL Fundamentals Zero Copy Cloning SQL SQL (Basic Advanced) Python Data Warehousing Snowflake Data Exchange Time Travel and Fail Safe Snowpipe SnowSQL Modern Data Platform Fundamentals Data Modelling Fundamentals PLSQL T-SQL Stored Procedures
- Snowflake Data Architecture: Lead Data Engineer
Senior Data Engineer Snowflake DBT SQL & Tableau
Location
Bangalore / Hyderabad / Pune / Chennai / Gurgaon
Experience
4-8 Years of Experience
Job Summary
We are looking for a highly skilled Data Engineer with expertise in Snowflake DBT SQL Python and Tableau to design and deliver scalable data and analytics solutions. The ideal candidate will have hands-on experience building data pipelines implementing modern data warehouse architectures developing dashboards and enabling business insights through reporting and analytics.
Key Responsibilities
- Design develop and maintain scalable ETL/ELT pipelines using DBT SQL and Python.
- Build and optimize Snowflake-based data warehouse solutions leveraging Snowpipe Zero Copy Cloning Time Travel Fail Safe and Data Exchange.
- Design and implement robust data models to support analytics and reporting requirements.
- Develop maintain and optimize Tableau dashboards and reports for business users and stakeholders.
- Partner with business teams to gather reporting requirements and convert them into scalable data solutions.
- Create analytical datasets and semantic data models to support BI and self-service reporting.
- Perform data validation reconciliation and troubleshooting to ensure data quality and integrity.
- Develop stored procedures and automation frameworks within cloud data environments.
- Drive adoption of AI/GenAI capabilities to improve data processing and analytics.
- Mentor junior engineers on Snowflake DBT SQL Tableau and data engineering best practices.
Required Skills
Snowflake
- Hands-on experience with Snowflake Data Architecture.
- Strong understanding of:
- Snowpipe
- Zero Copy Cloning
- Time Travel
- Fail Safe
- SnowSQL
- Snowflake Data Exchange
- Experience in Snowflake performance tuning and optimization.
DBT
- Strong hands-on expertise in DBT.
- Experience in developing data transformation models testing deployment and documentation.
SQL
- Expert-level SQL skills with experience handling large-scale datasets.
- Strong knowledge of data manipulation optimization joins analytical functions and query tuning.
- Experience with PL/SQL and T-SQL.
Tableau
- Hands-on experience in Tableau development and dashboarding.
- Experience building interactive dashboards visualizations KPIs and executive reporting.
- Strong understanding of Tableau data modeling and dashboard optimization techniques.
- Experience connecting Tableau with Snowflake and cloud data warehouses.
- Ability to translate business requirements into impactful reports and dashboards.
Python
- Strong Python programming skills for automation orchestration and data engineering use cases.
Data Engineering
- Strong understanding of ETL/ELT frameworks and modern data architectures.
- Experience in dimensional modeling and data warehousing concepts.
- Hands-on experience designing scalable enterprise data solutions.
Preferred Skills
- Exposure to AI/GenAI tools and capabilities.
- Experience with Power BI Looker or other BI visualization platforms.
- Experience with AWS Redshift Google BigQuery or similar cloud data platforms.
- Knowledge of Finance Renewals Subscription Management or Sales Analytics domains.
- Experience working in Agile and DataOps environments.
Educational Qualification
- Bachelors Degree in Computer Science Information Technology Data Engineering or a related field.
Preferred Certifications
- Snowflake SnowPro Certification
- Tableau Desktop Certified Professional
- DBT Certification
- Microsoft Data Engineer Associate
- AWS Data Analytics Certification
Primary Skills
Snowflake DBT SQL Tableau Python
Secondary Skills
Data Modeling Data Warehousing ETL/ELT AI/GenAI Power BI Looker AWS Redshift BigQuery
Required Experience:
Senior IC
About Company
Brillio is a global leader in Enterprise Digital Transformation Solutions, providing strategic consulting services and solutions using emerging technologies.