Business Analyst

bolttech; Bengaluru; On-site; INR 3,500,000 - 5,500,000; Full time

Job summary

bolttech in Bengaluru seeks an experienced BI and data engineering professional to translate business needs into scalable data warehouse solutions. You will design dashboards, improve data models, and supervise GenAI-enabled analytics initiatives.

The role requires deep P&C insurance domain knowledge, hands-on SQL, DW modeling, ETL specs, and experience with Power BI. You will mentor teammates and collaborate across data teams to deliver end-to-end BI solutions.

Qualifications

• Must have domain knowledge in P&C Insurance, preferably US market.
• Strong data warehouse concepts and exposure to at least two DW implementation projects.
• Experience on 3 AIML / Gen AI projects end-to-end.
• Proficiency in writing SQL queries and validating GenAI-generated outputs.
• Awareness of responsible AI usage, including data privacy and governance of enterprise LLMs.
• Ability to handle multiple time-sensitive bug/enhancement requests.
• Drive requirement-gathering sessions, translate to BI solutions, and write specs for development teams.
• Experience in designing DWH data models and data marts; exposure to Toad Data Modeler.
• Experience in source-to-target mapping (ETL specs) and report specification.
• Experience in supporting Data Engineering, Report Development, QA teams.
• Exposure to Power BI or similar tools.
• Ability to work independently and take ownership of end-to-end deliverables.
• 10+ years of relevant experience.

Responsibilities

• Interact with stakeholders to implement new business requirements.
• Design interactive analytics dashboards to provide customers with actionable insights.
• Analyze existing data solutions to deliver business insights with quick turnaround.
• Mentor team members and promote opportunities.
• Stakeholder management and cross-team collaboration.
• Drive end-to-end delivery of BI solutions and maintain documentation.

Skills

SQL querying

GenAI tools usage

BI delivery end-to-end

Stakeholder management

Tools

Toad Data Modeler

Power BI

Job description

Responsibilities:

• Interact with stakeholders to understand and implement new business requirements.
• Bring best practices to the table to enhance data warehouse efficiency.
• Build processes and methodologies to implement new solutions.
• Design interactive analytics dashboards to provide customers with actionable insights.
• Analyze the existing data solutions to provide business solutions with quick turnaround.
• Contribute to and create a motivating work environment within the team.
• Mentor other team members and promote opportunities.
• Stakeholder management.

Requirements:

• Must have good domain knowledge in P& C Insurance (preferably in the US market).
• Should have a strong understanding of data warehouse concepts and exposure to at least two data warehouse implementation projects.
• Should have worked on at least 3 AIML / Gen AI projects end-to-end.
• Experience using GenAI tools (Copilot/ChatGPT/Claude) to accelerate BI tasks such as requirement gathering, data exploration, SQL drafting, and documentation.
• Should have proficiency in writing SQL queries and pulling ad hoc data. Ability to validate and refine GenAI-generated SQL, insights, and narratives, ensuring accuracy and alignment with source data.
• Awareness of responsible AI usage, including data privacy, hallucination checks, and governed use of enterprise LLMs.
• Should be able to handle multiple time-sensitive bug/enhancement requests.
• Should have the ability to drive requirement-gathering sessions, translate them into business intelligence solutions, create functional documentation, and write specifications for the development team.
• Should have experience in designing DWH data models and data marts and exposure to tools like Toad Data Modeler or similar tools.
• Should have experience in source system study, source-to-target mapping (ETL specs), and report specification.
• Should have experience in supporting the Data Engineering team, Report Development team, Quality Analyst team, etc.
• Should be able to support user acceptance testing and production bugs.
• Should have exposure to data analysis and visualization tools like Power BI or similar tools.
• Should be able to work independently and take ownership of end-to-end deliverables.
• Should have 10 years+ relevant experience.