Sr. Business Analyst

About Organization:bolt is the leading insurance exchange for the P&C insurance industry, uniting distributors, and providers on a single platform to transform the way insurance is bought and sold. The result is the world’s biggest exchange, working with two-thirds of America’s leading carriers and connecting more people with ways to protect the things they value.Roles & 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 dashboard to provide customers with actionable insights.Analyse the existing data solutions to provide business solutions with quick turn around.Contribute and create a motivating work environment within the team.Mentor other team members and promote opportunities.Stakeholder management.Skills & Qualification:Should have minimum 10+ years’ experience working as Business Analyst Mandatory to have good domain knowledge in P&C Insurance (Preferably in US Market)Should have a strong understanding of Data Warehouse concepts and hands on experience in implementing many Data Warehouse implementation projectsShould have exposure or knowledge in Agency operation, MGA and Markets Should have excellent proficiency in writing SQL queries and pull ad-hoc data. Ability to validate and refine GenAI-generated SQL, insights, and narratives, ensuring accuracy and alignment with source data.Should have at least worked in 3 AIML / Gen AI projects end to endExperience using GenAI tools (Copilot/ChatGPT/Claude) to accelerate BI tasks such as requirement gathering, data exploration, SQL drafting, and documentation.Awareness of responsible AI usage, including data privacy, hallucination checks, and governed use of enterprise LLMs.Should be able to handle multiple time sensitive bugs/enhancements requestsShould have ability to drive requirement gathering sessions and translate them into Business Intelligence solutions and create functional documentation and write specifications for development teamShould have experience in designing DWH data models, data marts and exposure to tools like Toad Data Modeler, or similar toolsShould have experience in source system study, source to target mapping (ETL specs), report specification Should have experience in supporting the Data Engineering team, Report development team, Quality Analyst team etcShould be able to support User Acceptance Testing, Production bugsShould have exposure to data analysis and visualization tools like PowerBI or similar toolsShould be able to work independently and take ownership of end-to-end deliverables