Senior Lead Data Engineer - Power BI/ETL

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. (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 2/14/2025