Spaulding Ridge - Snowflake Architect - Data Engineering & Warehousing

What You Will Do And Learn :

As a Snowflake Architect / Manager in Data Solutions, youll be responsible for designing, implementing, and testing proposed modern analytic solutions.

• Working closely with our client partners and architects, youll develop relationships with key technical resources while delivering tangible business outcomes.
• Manage the Data engineering lifecycle including research, proof of concepts, architecture, design, development, test, deployment, and maintenance
• Collaborate with team members to design and implement technology that aligns with client business objectives
• Build proof of concepts for a modern analytics stack supporting a variety of Cloud-based Business Systems for potential clients
• Team management experience and ability to manage, mentor and develop talent of assigned junior resources
• Create actionable recommendations based on identified platform, structural and / or logic problems
• Communicate and demonstrate a clear understanding of client business needs, goals, and objectives
• Collaborate with other architects on solution designs and :
• 8+ years experience developing industry leading business intelligence and analytic solutions
• Must have thorough knowledge of data warehouse concepts and dimensional modelling
• Must have experience in writing advanced SQL
• Must have at least 5+ years of hands-on experience on DBT (Data Build Tool).
• Mandatory to have most recent hands-on experience on DBT.
• Must have experience working with DBT on one or more of the modern databases like Snowflake / Amazon Redshift / BigQuery / Databricks / etc.
• Hands-on experience with Snowflake would carry higher weightage
• Snowflake SnowPro Core certification would carry higher weightage
• Experience working in AWS, Azure, GCP or similar cloud data platform would be an added advantage
• Hands-on experience on Azure would carry higher weightage
• Must have experience in setting up DBT projects
• Must have experience in understanding / creating / modifying & optimizing YML files within DBT
• Must have experience in implementing and managing data models using DBT, ensuring efficient and scalable data transformations
• Must have experience with various materialization techniques within DBT
• Must have experience in writing & executing DBT Test cases
• Must have experience in setting up DBT environments
• Must have experience in setting up DBT Jobs
• Must have experience with writing DBT Jinja and Macros
• Must have experience in creating DBT Snapshots
• Must have experience in creating & managing incremental models using DBT
• Must have experience with DBT Docs
• Should have a good understanding of DBT Seeds
• Must have experience with DBT Deployment
• Must Experience with architecting data pipelines using DBT, utilizing advanced DBT features
• Proficiency in version control systems and CI / CD
• Must have hands-on experience configuring DBT with one or more version control systems like Azure DevOps / Github / Gitlab / etc.
• Must have experience in PR approval workflow
• Participate in code reviews and best practices for SQL and DBT development
• Experience working with visualization tools such as Tableau, PowerBI, Looker and other similar analytic tools would be an added advantage
• 2+ years of Business Data Analyst experience
• 2+ years of experience writing Business requirements, Use cases and / or user stories, for data warehouse or data mart initiatives.
• Understanding and experience on ETL / ELT is an added advantage
• 2+ years of consulting experience working on project-based delivery using Software Development Life Cycle (SDLC)
• 2+ years of years of experience with relational databases (Postgres, MySQL, SQL Server, Oracle, Teradata etc.)
• 2+ years of experience creating functional test cases and supporting user acceptance testing
• 2+ years of experience in Agile / Kanban / DevOps Delivery
• Outstanding analytical, communication, and interpersonal skillsAbility to manage projects and teams against planned work
• Responsible for managing the day-to-day client relationship on projects

(ref : hirist.tech)