Principal Consultant - Snowflake Sr. Data Engineer

Inviting applications for the role of Principal Consultant- Snowflake Sr.Data Engineer (Snowflake + DBT)

In this role, the Snowflake Sr.Data Engineer is responsible for providing technical direction and lead a group of one or more developer to address a goal.

Job Description
Experience in IT industry
Working experience in the IT industry, with a focus on building productionized data ingestion and processing data pipelines in Snowflake.
In-depth knowledge of data warehousing concepts and experience in working with Snowflake, including a deep understanding of its features and integration with other data processing technologies.
Proficiency in creating data pipelines for ETL using Snowflake or DBT (Data Build Tool).
Hands-on experience in configuring, troubleshooting, testing, and managing data platforms, both on-premises and in the cloud.
Familiarity with data visualization tools and methodologies.
Ability to work independently on business problems and generate meaningful insights from data.
Snowflake SnowPro Core Certification is a must.
Excellent presentation and communication skills, both written and verbal.
Strong problem-solving skills and ability to architect solutions in an environment with unclear requirements.

Roles and Responsibilities
Able to work on requirement gathering, analysis, designing, development, and deployment.
Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data.
Good understanding on Data Warehouse concepts and Snowflake Architecture
Hands-on 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.
Have experience with Snowflake AWS data services (S3, Glue,lambda) or Azure data services (blob storage container, ADLS, ADF) etc
Strong experience in integrating DBT (Data Build Tool) with Snowflake and cloud platforms such as AWS or Azure.
Extensive knowledge of leveraging DBT to build and manage efficient data transformation pipelines in Snowflake.
Experience in designing and developing efficient and scalable data models using DBT, including the creation of tables, views, and macros.
Knowledge of SQL and ability to write complex queries and transformations using DBTs templating language.
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 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

Qualifications we seek in you
Minimum qualifications
B.E./ Masters in Computer Science, Information technology, or Computer engineering or any equivalent degree with IT experience and relevant working experience as Snowflake Sr. Data Engineer.
Snowflake, DBT, AWS/Azure, SQL, ETL concepts, Airflow or any orchestration tools, Data Warehousing concepts