Data Engineering (Snowflake, DBT & ADF) - Lead Programmer Analyst

• Experience should have at least 5 years of experience in designing and developing Azure Data Factory Pipelines.
• Must have experience with at least one Columnar MPP Cloud data warehouse (Snowflake/Azure Synapse/Redshift) for at least 5 years.
• Experience in ETL tools like Fivetran and DBT for 2 years.
• Experience with Git and Azure DevOps.
• Experience in Agile, Jira, and Confluence.
• Solid understanding of programming SQL objects (procedures, triggers, views, functions) in SQL Server.
• Experience optimizing SQL queries a plus.
• Working Knowledge of Azure Architecture, Data Lake.
• Hands on programmer with a thorough understand of:

o Performance tuning techniques.

o Handling large data volume transformations (order of 100 GBs monthly).

o Able to create solution / data flows to suit requirements.

o Produce timely documentation e.g., mapping, UTR, defect / KEDB logs etc.

• Tech experience expected:

o Primary: Snowflake, DBT (development testing).

o Secondary: Python, ETL or any data processing tool.

o Nice to have - Domain experience in healthcare.

• Self-starter learner.
• Able to understand and probe for requirements.
• Generate functional specs for code migration or ask right questions thereof.