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 projects
Should 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 end
Experience 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 requests
Should have ability to drive requirement gathering sessions and translate them into Business Intelligence solutions and create functional documentation and write specifications for development team
Should have experience in designing DWH data models, 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), 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, Production bugs
Should have exposure to data analysis and visualization tools like PowerBI or similar tools
Should be able to work independently and take ownership of end-to-end deliverables

Work arrangement
No