Senior/Lead Data Engineer - SQL/Snowflake DB (6-16 yrs)

Desired Skills and experience :

- Very strong SQL, preferably Snowflake

- Experience in planning and building data marts

- Good experience in PowerBI dashboard development

- Sound database knowledge

Key Responsibilities :

- Build and partner with the Client CTO and LOB teams to build data marts for Commercial Real Estate data. Need a strong hold on building queries in Snowflake.

- Translate client challenges into actionable business intelligence solutions by partnering with the subject matter experts at the bank

- Expertise in understanding the technical and functional designs of the databases

- Acquire proprietary data from on-prem data warehouses

- Perform data preparation activities in support of analytics, reporting and automation. Develop and manage bespoke extract, transform, load (ETL) processes.

- Create centralized, analytical data marts across various projects to support analysis across multiple business units

- Ability to transform high-level requirements into data visualizations in PowerBI, which will allow business users to answer common questions and interact with data to answer more complex questions

- Require excellent coding skills.

- Manage data flow from major database platforms including Snowflake etc

- Understand the logics of various business fields/columns and implement them

- Make modifications to the logics based on user requirements. Also, undertake adhoc data requests.

- Prepare on demand request on loan datatapes.

- Experience in migrating reports from one platform to another platform.

- Experience of understanding the framework of on-prem database structure and the related tables/views.

- Maintain extract, transform, load (ETL) processes connecting data warehouses to analytical platforms

- Evaluate ongoing automation of underlying manual processes

- Investigate underlying data sets and derive actionable analytical insights using quantitative techniques

- Study and research on the domain functionalities to add value to the analytical findings

- Ensure meticulous documentation of processes, meta data, query logic, and results

- Perform balance & control, testing and/or other validation activities to ensure accuracy.

- Ensure quality of data, analysis and reporting of the overall process

- Building good rapport and trust with client

Key Metrics :

- Over 6-9 years of relevant development experience in SQL (preferably Snowflake)and PowerBI.

- Masters / Bachelors in Computer Applications / Technology, Bachelors in Engineering