What are the responsibilities and job description for the Senior BI/Data Analyst position at IntePros?
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
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.
- 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.
