Job Description
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.
Job Tags
Permanent employment, Full time,