Lead Data Engineer DBT ,SQL, Snowflake , Tableau - R01570901

Brillio

Bangalore, Karnataka, India Posted 10d ago
Log in to apply
Lead Data Engineer PRIMARY SKILLS * 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 SPECIALIZATION * Snowflake Data Architecture: Lead Data Engineer JOB REQUIREMENTS 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 * Bachelor's 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

Explore related jobs