Delivery Lead-Data Analytics

Acuity Analytics; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Acuity Analytics in Bengaluru leads data analytics initiatives for a US CRE client, focusing on data preparation, ETL, and analytics. The role involves transforming business needs into BI solutions, building data marts, and delivering scalable reporting using modern technologies.

We value hands-on professionals with 6–9 years of SQL experience, strong communication, and a proactive mindset to drive disruptive changes in global business processes.

Qualifications

• 6–9 years of SQL development experience.
• Masters in Computer Applications or Bachelors in Engineering/Technology.
• Strong communication and client-facing skills.
• Experience in the financial services domain is desirable.
• Able to lead calls with client stakeholders.

Responsibilities

• Partner with client LOB teams to build curated data sets for CRE.
• Translate client challenges into BI solutions by collaborating with subject matter experts.
• Understand the technical and functional designs of the databases.
• Acquire proprietary data from on-prem data warehouses.
• Develop ETL processes and create centralized data marts for analytics.
• Transform requirements into data visualizations using new technologies.
• Leverage Claude to design web-based reporting and analytics apps.
• Possess Python coding skills.
• Maintain ETL data flows from major databases including Snowflake.
• Ensure data quality and thorough documentation.
• Build rapport and trust with the client.

Skills

SQL

Education

Masters in Computer Applications

Bachelors in Engineering

Bachelors in Technology

Tools

Snowflake

Python

Job description

Job Purpose

As part of the AI, Data & Digital, you will be working with the data analytics, automation and reporting requirements of a US Commercial Real Estate firm as part of Acuity’s Center of Excellence model.

Job Purpose

As part of the AI, Data & Digital, you will be working with the data analytics, automation and reporting requirements of a US Commercial Real Estate firm as part of Acuity’s Center of Excellence model. Global technology megatrends, regulatory developments, competitive landscape and rise of alternative data are changing the way capital markets operate. At the Data and Technology services operations, we partner with some of the largest financial services firms and corporations in this transformative journey. We are looking for professionals who are hands on, passionate about the work and have the ambition to drive disruptive changes to global business models.

Key Responsibilities

• Partner with the client LOB teams to build curated data sets for Commercial Real Estate data.
• 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
• Acquiring 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 new technologies is a plus, which will allow business users to answer common questions and interact with data to answer more complex questions
• Leverage Claude to design and develop web-based reporting and analytics applications, transforming business requirements into intuitive user experiences.
• Desirable to have Python coding skills
• Require excellent coding skills.
• Manage data flow from major database platforms including Snowflake etc
• Understand the logic of various business fields/columns and implement them
• Make modifications to the logic based on user requirements. Also, undertake adhoc data requests.
• Prepare on demand request on loan datatypes.
• 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 competencies

• Over 6-9 years of relevant development experience in SQL.
• Masters / Bachelors in Computer Applications / Technology, Bachelors in Engineering
• Efficiently lead the client calls on a daily basis
• Be proactive and independent, able to work on projects with minimum input from senior stakeholders
• Evaluate and ensure quality of deliverables within defined timelines
• Prior experience in the financial services domain is highly desirable.
• Excellent verbal and written communication skills with a collaborative mindset.