Senior Architect- Snowflake, DBT

7 days ago

India Tredence Full time

About Tredence

Tredence is a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our capabilities range from Data Visualization, Data Management to Advanced analytics, Big Data and Machine Learning. Our uniqueness is in building Scalable Big Data Solutions on Onprem/GCP/Azure cloud in a very cost effective and easily scalable manner for our clients. We also come in with some strong IP and pre-built analytics solutions in data mining, BI and Big Data.

Job Location

Bangalore / Chennai / Gurgaon / Pune

Roles & Responsibilities

Working experience in Snowflake; use of Snow SQL CLI, Snow Pipe creation of custom functions and Snowflake stored producers, schema modelling, performance tuning etc. Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts. Extensive experience in DBT CLI, DBT Cloud, GitHub version control and repository knowledge, and DBT scripting to design & develop SQL processes to perform complex ELT processes and data pipeline build. Ability to independently envision and develop innovative ETL and reporting solutions and execute them through to completion. Triage issues to find gaps in existing pipelines and fix the issues Analyze the data quality, align the technical design to data governance, and address all the required non-business but operational requirements during the design and build of data pipelines. Develop and maintain data pipelines using DBT Provide advice, guidance, and best practices around Snowflake Provide guidance on moving data across different environments in Snowflake Create relevant documentation around database objects Troubleshoot production support issues post-deployment and come up with solutions as required. Good Understanding and knowledge of CI/CD process and GitHub-> DBT-> Snowflake integrations. Advance SQL knowledge and hands-on experience in complex query writing using Analytical functions, Troubleshooting, problem-solving, and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge of stored procedures. Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel and understanding how to use these features. Help joiner team members to resolve issues and technical challenges. Drive technical discussions with client architect and team members. Good experience in developing scripts for data auditing and automating various database platform manual activities. Understanding of the full software lifecycle and how development teams should work with DevOps to create more software faster. Excellent communication, working in Agile Methodology/Scrum

Qualification & Experience

Bachelor's and/or master's degree in computer science or equivalent experience. Must have experience in data Integration, ETL/ETL development, and database design or Data warehouse design. Deep understanding of Star and Snowflake dimensional modelling. Strong knowledge of Data Management principles Working experience in Snowflake; use of Snow SQL CLI, schema modelling, performance tuning etc. Develop and maintain data pipelines using DBT. Experience with writing complex SQL queries, especially dynamic SQL Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration implementing complex stored Procedures and standard DWH and ETL concepts. Experience with performance tuning and optimization of SQL queries Experience of working with Retail Data Experience with data security and role-based access controls Comfortable working in a dynamic, fast-paced, innovative environment with several ongoing concurrent projects Should have experience working in Agile methodology. Strong verbal and written communication skills. Strong analytical and problem-solving skills with high attention to detail.

Why Join Tredence?

There is a reason we are one of the fastest growing private companies in the country You will have the opportunity to work with some of the smartest and fun-loving people in the data analytics space. You will work with the latest technologies and interface directly with the key decision stakeholders at our reputed clients, some of the largest and most innovative global business brands. Our people are our greatest asset and we value every one of them. We are an equal opportunity employer who adhere to our core values & reflect this in our day to day life. So, please come & see why we're so successful in one of the most competitive and fastest growing industries in the world.

  • Senior Architect- Snowflake, DBT

    2 months ago

    india Tredence Full time

    About Tredence Tredence is a global analytics services and solutions company. We are one of the fastest growing private companies in the country for three straight years according to the Inc. 5000 and we continue to set ourselves apart from our competitors by attracting the greatest talent in the data analytics and data science space. Our...

  • Snowflake Architect

    4 weeks ago

    india BigTapp Analytics Full time

    Job Description: We are seeking a skilled Snowflake Architect with 8-10 years of experience to join our team. The ideal candidate will be responsible for designing, implementing, and managing Snowflake solutions to support our data infrastructure needs. As a Snowflake Architect, you will collaborate closely with crossfunctional teams to develop scalable and...

  • Data Modeler

    1 week ago

    India Response Informatics Full time

    Data Modeler with DBTRole – Data Modeler with DBTUrgency / TAT – Urgent / within 30 daysDuration – Long Term.Salary Range Exception – Only if the candidate brings strong relevant experience which will bedetermined after the interview. Please let me know before submitting the profile. Pls. note this isextreme scenario and will require client...

  • Data Modeler

    7 days ago

    India Response Informatics Full time

    Data Modeler with DBT Role – Data Modeler with DBT Urgency / TAT – Urgent / within 30 days Duration – Long Term. Salary Range Exception – Only if the candidate brings strong relevant experience which will be determined after the interview. Please let me know before submitting the profile. Pls. note this is extreme scenario and will require client...

  • Snowflake Architect

    1 month ago

    india LTIMindtree Full time

    12+ years of experience in the Data warehouse, ETL, BI projects and 3+ years working as Data Architect. At least 2 years of Snowflake hand-on experience. Excellent knowledge of RDBMS topics, SQL, OLAP, OLTP, NO-SQL databases, JSON. Must have hands-on experience in SnowSQL, JavaScript Stored Procedures, performance tuning, Streaming Ingestion and Streams....

  • Snowflake Data Engineer

    4 weeks ago

    india Lapis Data Analytics Full time

    Company Description Lapis Data Analytics is a dynamic and innovative data engineering company founded in 2020 and located in Chennai. Our primary focus is on designing, building, and maintaining robust data pipelines that convert raw data into actionable insights. With a team of seasoned experts and cutting-edge technology, we deliver customized data...

  • Snowflake Lead/ Architect

    3 weeks ago

    india Relanto Full time

    Job Title: Snowflake Lead/Architect Location: Bangalore Experience: 8+ Years About role: We are seeking a highly skilled Snowflake Lead/Architect to join our Data & AI team in Bangalore. The ideal candidate will have extensive experience in designing, implementing, and managing Snowflake-based data solutions. This role involves leading the development of...

  • Snowflake Lead/ Architect

    7 days ago

    India Relanto Full time

    Job Title: Snowflake Lead/Architect Location: Bangalore Experience: 8+ Years About role: We are seeking a highly skilled Snowflake Lead/Architect to join our Data & AI team in Bangalore. The ideal candidate will have extensive experience in designing, implementing, and managing Snowflake-based data solutions. This role involves leading the development of...

  • Snowflake Architect

    2 months ago

    Anywhere in India/Multiple Locations/Bangalore Mobile Programming Full time

    Skills Required: 8+ years of experience architecting, designing, developing and optimizing large scale data solutions, out of which at least 5 years is in SaaS domain Strong experience in building with GCP and/or AWS infrastructure and services Expert knowledge and deep hands-on experience with cloud data platforms/services such as Snowflake, Azure...

  • Snowflake Architect

    3 weeks ago

    Anywhere in India/Multiple Locations/Bangalore Mobile Programming Full time

    Skills Required: 8+ years of experience architecting, designing, developing and optimizing large scale data solutions, out of which at least 5 years is in SaaS domain Strong experience in building with GCP and/or AWS infrastructure and services Expert knowledge and deep hands-on experience with cloud data platforms/services such as Snowflake, Azure...

  • Snowflake Architect

    3 weeks ago

    Anywhere in India/Multiple Locations/Bangalore Mobile Programming Full time

    Job Description Required : 6 +years of experience architecting, designing, developing and optimizing large scale data solutions, out of which at least 5 years is in SaaS domain Strong experience in building with GCP and/or AWS infrastructure and services Expert knowledge and deep hands-on experience with cloud data platforms/services such as Snowflake,...

  • Snowflake Architect

    2 months ago

    Anywhere in India/Multiple Locations/Bangalore Mobile Programming Full time

    Job Description Required : 6 +years of experience architecting, designing, developing and optimizing large scale data solutions, out of which at least 5 years is in SaaS domain Strong experience in building with GCP and/or AWS infrastructure and services Expert knowledge and deep hands-on experience with cloud data platforms/services such as Snowflake,...

  • Data Engineer

    2 months ago

    india SKYGATE CONSULTING Full time

    Data Engineer (Snowflake) Job Description :As part of the team, you will be responsible for building and running the data pipelines and services that are required to support business functions/reports/dashboard.. We are heavily dependent on BigQuery/Snowflake, Airflow, Stitch/Fivetran, dbt , Tableau/Looker for our business intelligence and embrace AWS with...

  • Senior Data Architect

    1 week ago

    India Response Informatics Full time

    1. Candidate must have the minimum of 8+ years of experience working as an admin/architect.2. Must have relevant experience of min 5 years in Data Modeler role with implementationexperience using Erwin, Autosys or any other Data modeler tool.3. Hands-on with either DBT & Airflow experienceMandatory – Data Modeling, Data Build Tool, Erwin/Autosys,...

  • Senior Data Architect

    1 week ago

    india Response Informatics Full time

    1. Candidate must have the minimum of 8+ years of experience working as an admin/architect. 2. Must have relevant experience of min 5 years in Data Modeler role with implementation experience using Erwin, Autosys or any other Data modeler tool. 3. Hands-on with either DBT & Airflow experience Mandatory – Data Modeling, Data Build Tool, Erwin/Autosys,...

  • Data Architect

    1 week ago

    india Coders Brain Technology Pvt. Ltd. Full time

    Position Name : Data ArchitectExperience Required : 10yrsNotice period : Immediate joiner Job Type : Full timeLocation : RemoteJob Description : - 10+ years of proven experience as a Data Engineer with 5+ years as Data Architect. - Bachelor's degree in computer science, Information Technology, or related field.- Proficiency in Snowflake with Hands-on...

  • Data Architect

    1 month ago

    india Coders Brain Technology Pvt. Ltd. Full time

    Position Name : Data ArchitectExperience Required : 10yrsNotice period : Immediate joiner Job Type : Full timeLocation : RemoteJob Description : - 10+ years of proven experience as a Data Engineer with 5+ years as Data Architect. - Bachelor's degree in computer science, Information Technology, or related field.- Proficiency in Snowflake with Hands-on...

  • Snowflake

    1 month ago

    india LTIMindtree Full time

    Skill: Snowflakes Developer Experience: 5-8Yrs Notice period: Imm to 30 days Location: Chennai, Hyderabad, Kolkata, Bangalore, Mumbai, Pune. JD: "Senior Snowflake developer/Technical Lead Experience with data and batch loading processes. - Strong hands on experience on Snowflake development and support of Data warehouse and interaction with Data Lakes. - DB...

  • Solution Architect

    3 weeks ago

    Anywhere in India/Multiple Locations koantek Full time

    Job Description : - Undergraduate degree or higher in Computer Science, Information Systems, or relevant experience.- Minimum 8+ years experience in a technical role, preferably in the data or cloud field.- Knowledge of at least one of the public cloud platforms AWS, Azure, or GCP is required.- Knowledge of a programming language - Python, Scala, or SQL-...

  • Solution Architect

    1 month ago

    Anywhere in India/Multiple Locations, IN koantek Full time

    Job Description :- Undergraduate degree or higher in Computer Science, Information Systems, or relevant experience.- Minimum 8+ years experience in a technical role, preferably in the data or cloud field.- Knowledge of at least one of the public cloud platforms AWS, Azure, or GCP is required.- Knowledge of a programming language - Python, Scala, or SQL-...