Sr. BI Analyst

At Ignyte, we’re building something bold: a fast-moving, high-impact specialty insurance platform that partners with exceptional brands in niche markets around the world. For over 35 years, the team at Ignyte Insurance has fueled explosive growth in the specialty insurance arena. With a proven acquisition platform, we manage over $1 billion in premium across a diverse range of specialty programs and brands worldwide. Relationships are paramount at Ignyte because we know that’s what drives mutual, long-term success. We maintain an entrepreneurial spirit and startup mindset within an established organization that continues to redefine what specialty insurance means and how it impacts everyday lives. Employees are given endless opportunities to expand their interests and skillsets, push breakthrough ideas and take risks. Our open, supportive environment gives employees the confidence to take ownership of their work as if the business was their own. With a track record of building and scaling successful insurance programs since 1990, we are relentlessly focused on growth through strategic mergers and acquisitions. We've executed $4 billion+ in transactions across North America, the UK, and Europe — making us one of the fastest-growing global specialty insurance providers in the industry.

Job Summary

As a Sr Business Intelligence Analyst at Ignyte Insurance Group, you will play a pivotal role in shaping the future of the specialty insurance industry. Your analytical insights will directly impact our top-line production, operational efficiencies, and underwriting profitability. You will have the opportunity to develop cutting-edge data and reporting products, driving our premier Collector Car segment to new heights.

This role is perfect for the intellectually curious, problem-solving data enthusiast who thrives on identifying opportunities and enjoys tackling complex challenges. You'll gain exposure to every facet of insurance operations, from underwriting and claims to distribution, and develop data models, tools, and reports that align with our business strategy.

Join us in building success every day, not just for our company but for your career. Ignyte Insurance Group fosters a culture of growth, innovation, and risk-taking, providing you with endless opportunities to expand your skillset and make a meaningful impact.

We're looking for the best in the business to join our team. If you're passionate about data analysis and ready to drive real change, apply today. **This is a hybrid opportunity, with 3 days onsite at the Conshohocken, PA Home Office**

• Stakeholder Engagement: Partner directly with business leaders across operations, marketing, and executive teams to uncover needs, clarify objectives, and shape data-driven recommendations.
• Analysis & Storytelling: Conduct root cause analysis, uncover performance trends, and communicate “the why” behind business outcomes through compelling dashboards, reports, and executive-ready presentations.
• Dashboards & Reporting: Build and enhance self-service BI tools in Power BI; maintain and improve data visualizations tailored for decision-makers.
• SQL Mastery: Write complex queries to extract, transform, and analyze structured data across multiple systems.
• Excel Expertise: Create and manage Excel-based models for scenario planning, performance tracking, and reconciliation.
• Data Governance: Identify data quality issues, define data logic standards, and collaborate with engineering resources to resolve data-related concerns.
• Proactive Trend Detection: Surface patterns in marketing response, sales conversions, call center productivity, or operational KPIs before they’re obvious.
• Continuous Improvement: Advocate for best practices in data visualization, data hygiene, and user engagement.

• Bachelors-degree in Data Analysis, Statistics, Finance, or other relevant analytical degree.
• 5+ years of experience utilizing SQL.
• 5+ years of experience utilizing data visualization tools such as Power BI, Qlik, Tableau, etc.
• 5+ years of providing analytical insights and developing summary decks to business stakeholders.
• 3+ years of experience developing ETL pipelines.
• Advanced understanding of data modeling and data warehousing concepts.
• Data Analysis & Trending experience with demonstrated proficiency in analytical methodologies, tools, and dashboard development to interpret, visualize, simplify and present/communicate data, analyses, results and findings.
• Demonstrated project management skills and ability to work independently to prioritize workload and handle multiple responsibilities, deadlines, etc.
• Strong organizational, problem-solving, and critical thinking abilities.
• High attention to detail to identify, evaluate and resolve data quality issues and reasonability check analytical results.
• Thrives in a team-oriented, results-driven environment.
• Ability to build relationships and communicate effectively with senior officials across the organization.
• Excellent oral presentation and written communication skills.

Preferred

• Insurance industry experience.
• Exposure to Azure technology stack.
• Exposure to statistical languages such as R/Python.