Senior Lead Data Engineer - Power BI/ETL (4-7 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.

Behavioral Competencies :

- Efficiently lead the client calls on a daily basis.

- Be proactive and independent, able to work on projects with minimum inputs from senior stakeholders.

- Evaluate and ensure quality of deliverables within defined timelines.

Skills & Requirements :

- Strong SQL Coding Experience , Snowflake (Good to have ), Power BI , BFSI Domain (Mandatory) , Client Management, Strong Communication Skills.