Job description

Senior Business Intelligence 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. #LI-MB1

Requirements