Data Architect - Business Intelligence & Analytics

Qualifications : - 10 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 advantag. - 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 skills - Ability to manage projects and teams against planned work - Responsible for managing the day-to-day client relationship on projects - 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 recommendations (ref:hirist.tech)

Location: pune, IN

Posted Date: 11/15/2024