Business Intelligence Engineer

SiriusPoint; New York (NY); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k)

Gym reimbursement

Health Savings Account

Parental leave

PTO

Job summary

SiriusPoint is seeking a Business Intelligence Engineer to transform governed enterprise data into insights and analytics. You will build trusted data sources, reports, and dashboards for stakeholders and help evolve BI from traditional reporting to AI-driven decision intelligence.

Responsibilities include data acquisition, data product design, and AI-enabled analytics, leveraging AWS, Redshift, Power BI, and Microsoft Fabric.

Qualifications

• 3+ years of experience in the insurance industry.
• Strong SQL and Redshift experience.
• Experience with BI tools like Power BI.
• Ability to design enterprise data products and data models.
• Experience supporting AI/ML use cases.

Responsibilities

• Collaborate with internal stakeholders to understand business needs and translate them into actionable data requests.
• Extract and transform data from policy systems, claims databases, and market research using AWS Redshift and ETL tools.
• Ensure data quality and integrity through data cleansing, validation, and standardization.
• Design and develop curated datasets and data products to support enterprise reporting and self-service analytics.
• Construct scalable semantic gold-layer datasets from enterprise data platforms.
• Define business-friendly data structures that abstract technical complexity for business users.
• Evolve from static reporting to AI-augmented insights, including anomaly detection and forecasting.
• Enforce review and validation standards for AI-assisted development and AI-generated insights.

Skills

SQL

Redshift

Data modeling

Semantic layers

AWS

Azure

Data governance

Self-service analytics

Presentation skills

Insurance domain

Tools

Power BI

Microsoft Fabric

ETL tools

Job description

Join Our Team

As our Business Intelligence Engineer, you will model and transform governed enterprise data into meaningful insights and analytics for SiriusPoint. You will create and maintain trusted data sources, reports, and dashboards for key stakeholders across the organization. You will help evolve SiriusPoint's BI practice from traditional reporting to AI-driven decision intelligence, helping design, build, and govern enterprise analytical datasets, semantic models, and business ontologies that enable scalable self-service analytics and support AI use cases. Leveraging Microsoft Fabric, Power BI, and emerging AI capabilities, you will turn enterprise data into business-ready data products. You will report to the AVP of Business Intelligence.

Your responsibilities will include:

Data Acquisition and Management:

• Collaborate with internal stakeholders to identify and understand business needs and translate them into actionable data requests.


• Extract and transform data from various insurance-specific sources (policy systems, claims databases, and market research) using AWS Redshift and ETL tools.


• Ensure data quality and integrity through data cleansing, validation, and standardization.

Enterprise Analytical Data Products:

• Design and develop curated analytical datasets and data products that support enterprise reporting, self-service analytics, and AI consumption.


• Construct scalable semantic gold-layer datasets from enterprise data platforms.


• Define business-friendly data structures that abstract technical complexity from business users.


• Help evolve the practice from static report production toward AI-augmented insight, such as automated anomaly detection, forecasting, and plain-language explanation of results.


• Enforce review and validation standards for AI-assisted development and AI-generated insights so that outputs remain accurate, explainable, and auditable.

Strategic Initiatives:

• Participate in cross-functional projects to leverage data for strategic initiatives, such as product development, pricing optimization, and claims management.


• Partner with IT to support data infrastructure enhancements and develop new data solutions.


• Stay abreast of emerging technologies and trends in the insurance and data analytics landscape.


• Drive adoption of data literacy initiatives across the organization to strengthen SiriusPoint’s data culture.

Your skills and abilities should include:

• 3+ years of experience in the insurance industry. Experience in Property & Casualty insurance, Accident & Health insurance, and reinsurance is a plus.


• Strong capabilities in Redshift and SQL, and experience working with the latest business intelligence tools and technologies.


• Support existing reporting and analytic assets.


• Create data sources that support self-service reporting and analytics, founded on key design principles and a strong focus on user experience.


• Understanding of semantic layers and knowledge graphs/ontologies as the foundation for AI.


• Comfort with cloud-based technologies, specifically AWS and Azure.


• Excellent organizational, written, verbal, and presentation skills.


• Excellent critical thinking and analytical abilities, particularly in developing a conceptual understanding of new topics for yourself and others.


• Ability to work individually with limited oversight.


• Ability to prioritize, multitask, and maintain flexibility in a fast-paced, changing environment.


• Demonstrated ability to influence and work effectively within a global organization with employees at all levels.


• Motivated and team-oriented, with strong problem-solving and project management skills.

We aim to retain and attract great people, knowing they can achieve a rewarding and enriching career. We offer a competitive and above market compensation package.The following are some of the benefits and perks we offer our employees:

• Medical


• Dental


• Vision


• FSA Medical and Dependent care


• Health Savings Account (HSA)


• EAP


• Basic Life and AD&D (company paid)


• Basic Long-Term Disability (employer) paid-Taxable income


• Employee paid Long Term Disability(voluntary)


• Company Medical Leave, Parental leave- 8 weeks full pay after 6 months of service


• Voluntary benefits: short term disability, Critical illness, Hospital Indemnity, Accident


• Travel assistance programs Company paid


• 401(k) 6 % safe harbor match, fully vested after two years, pre- and post-tax contributions allowed


• Gym reimbursement


• Legal plan


• Pet Insurance


• Tuition reimbursement


• Generous PTO


• Flexible work arrangement


• Fully stacked pantry on-site


• Team outings


• ERG Groups

Our CCPA Job Applicant Policy is found here: Sirius-America-CA-Job-Applicant-Privacy-Policy-Final.pdf