Snowflake, DBT

Desired Competencies (Technical/Behavioral Competency) Must-Have Snowflake, DBT , PL/SQL , Azure/AWS Overall Knowledge , Knowledge on DB Modelling , Knowledge on Data Warehouse concepts , Well versed with Agile Delivery, ETL Tools – Informatica/ADF Good-to-Have Azure 900/104/204 Certified, Informatica/SSIS/ADF   SN Responsibility of / Expectations from the Role 1 Assist in the design and implementation of Snowflake-based analytics solution (data lake and data warehouse) on Azure. 2 Profound experience in designing and developing data integration solutions using ETL tools such as DBT. 3         Hands-on experience in the implementation of cloud data warehouses using Snowflake & Azure Data Factory 4 Solid MS SQL Server skills including reporting experience. 5 Work closely with product managers and engineers to design, implement, test, and continually improve scalable data solutions and services running on DBT & Snowflake cloud platforms. 6 Implement critical and non-critical system data integration and ingestion fixes for the data platform and environment. 7 Ensuring root cause resolution to identified problems. 8 Monitor and support the Data Solutions jobs and processes to meet the daily SLA. 9 Analyze the current analytics environment and make recommendations for appropriate data warehouse modernization and migration to the cloud. 10 Develop Snowflake deployment (Using Azure DevOPS or similar CI/CD tool) and usage best practices. 11 Follow best practices and standards around data governance, security and privacy. 12 Comfortable working in a fast-paced team environment coordinating multiple projects. 13 Effective software development life cycle management skills and experience with GitHub 14 Leverage tools like Fivetran, DBT, Snowflake, GitHub, to drive ETL, data modeling and analytics. 15 Data transformation and Data Analytics Documentation