Business Intelligence Analyst

Senior Business Intelligence Analyst/Data Analyst

Full-Time Permanent Conshohocken, PA (Hybrid)

IntePros Consulting is partnering with a leading Insurance client in Conshohocken, PA to identify a Senior Business Intelligence Analyst to join their growing analytics team. This strategic role demands a seasoned data professional with demonstrated success leading BI initiatives, particularly within the Property & Casualty or broader insurance domain. The ideal candidate will be highly skilled in translating complex business problems into scalable data solutions and empowering business users with self-service analytics and actionable insights.

Key Responsibilities:

Lead the design and delivery of enterprise BI solutions by integrating data from disparate systems into cohesive, insightful dashboards and reports.

Drive discovery sessions with business stakeholders to define requirements, identify KPIs, and prioritize enhancements across cross-functional projects.

Architect and manage robust ETL processes using Power Query, SSIS, or other tools to ensure accurate and timely data transformation.

Leverage advanced SQL and data modeling skills to develop and maintain reporting data marts and analytical frameworks.

Serve as a thought partner to leadership, identifying trends, risks, and opportunities through in-depth analysis of internal and external datasets.

Deliver ad-hoc and strategic analysis, providing prescriptive recommendations and influencing business decision-making.

Act as a mentor to junior analysts, promoting best practices in data governance, visualization standards, and storytelling with data.

Qualifications:

Bachelor's degree in Mathematics, Statistics, Finance, Economics, Computer Science, or a related quantitative field.

5+ years of experience in business intelligence, analytics, or data science roles, with strong command of SQL Server Management Studio and modern data visualization platforms (Power BI, Tableau, Qlik).

Deep expertise in data warehousing concepts, dimensional modeling, and building scalable reporting solutions.

Advanced proficiency in Microsoft Excel, including complex formulas, PivotTables, and automation techniques.

Strong understanding of DAX, and familiarity with statistical programming (R, Python, SAS) is highly desirable.

Proven ability to distill complex data into executive-level insights and visualizations that drive action.

Self-directed, highly analytical, and comfortable operating in a fast-paced, collaborative environment.