Lead Business Intelligence Analyst

Chesapeake Employers Insurance•Towson, MD

About The Position

The Lead Business Intelligence Analyst is a senior technical and analytical authority responsible for guiding the BI team, leading meetings, defining analytic standards, and ensuring consistent delivery of enterprise-ready insights. Operating within Chesapeake’s Azure-based lakehouse and governed enterprise semantic model architecture, the Lead BI Analyst oversees complex dashboard development, advanced KPI governance, analytical modeling, and BI workflow maturity. This role expands upon Senior-level responsibilities by assuming leadership of BI ceremonies, providing technical decision authority, mentoring analysts at all levels, and managing complex cross-functional analytics initiatives. The Lead BI Analyst also serves as a strategic advisor to underwriting, claims, actuarial, finance, operations, and executive teams.

Requirements

Bachelor’s degree in Business Analytics, Data Science, Finance, Insurance, or related field, or equivalent experience.
8+ years of experience in business intelligence, analytics, or data analysis roles.
Demonstrated leadership in BI initiatives, technical coaching, and meeting facilitation.
Expert-level experience with Power BI, including complex dashboard development, advanced semantic modeling, and optimization of complex DAX measures.
Hands-on experience using Tableau for ad-hoc analysis and exploratory visualization.
Advanced SQL skills and experience querying and analyzing enterprise data sets.
Knowledge of insurance concepts such as policy lifecycle, claims, premiums, loss ratios, and reserving.
Demonstrated customer service skills and ability to build trusted stakeholder relationships at the leadership level.
Strong written and verbal communication skills with non-technical audiences, with the ability to explain complex technical concepts to executives.
Experience using AI-assisted analytics tools to enhance analysis and business communication.
Strong analytical, organizational, and multi-tasking skills.
Proven experience mentoring peers or leading technical projects.

Responsibilities

Leads BI team meetings, including standups, backlog refinement, intake prioritization, and analytics review sessions.
Mentors and coaches all analysts on technical skills, data visualization best practices, and insurance domain knowledge.
Architects, develops, and maintains complex Power BI dashboards, reports, and semantic models using trusted enterprise data.
Serves as a primary analytics point of contact and strategic advisor for business stakeholders, providing responsive, customer-focused support.
Establishes BI best practices across reporting, data storytelling, documentation, and model governance.
Translates complex business questions into governed KPIs, metrics, and visualizations aligned to enterprise definitions.
Acts as a Lead Data Steward for their domain, driving the adoption of the business glossary and defining standard metrics (e.g., in Microsoft Purview).
Performs ad-hoc and exploratory analysis to identify trends, risks, and opportunities across insurance domains.
Uses Tableau for rapid, ad-hoc, and investigative analysis prior to standardizing insights in Power BI.
Applies AI-enabled analytics tools to accelerate insight generation, automate analysis, and enhance decision support.
Validates analytical results, investigates anomalies, and partners with data engineering teams on complex data quality issues and pipeline optimizations.
Defines and documents report logic, business rules, and data sources in accordance with department standards; reviews documentation created by junior team members.
Communicates insights clearly through dashboards, written summaries, presentations, and AI-assisted narratives to executive and operational audiences.
Participates in and leads aspects of agile planning, backlog refinement, and ongoing operational reporting support.
Supports company business strategy and departmental goals by delivering accurate, timely, and actionable insights.
Performs other duties as assigned.