Data Architect - Business Intelligence & Analytics (2-6 yrs)

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