Data & Analytics Manager

Data & Analytics Manager

Job Summary: The Data & Analytics Manager is responsible for leading the design, development, and delivery of enterprise data and analytics capabilities in a commercial insurance environment. This role oversees integration of data from core systems like Guidewire, drives the use of modern cloud tools including Microsoft Fabric, and ensures high-performance reporting through SSIS, SSRS, Power BI, and Cognos. In addition to analytics leadership, this role manages database administrators (DBAs) responsible for maintaining secure, reliable, and optimized data environments that support business operations. The ideal candidate brings a deep understanding of insurance data and a strong background in Agile delivery practices.

Key Responsibilities:

Leadership & Strategy

• Define and lead Canal's enterprise data and analytics roadmap, aligning with business priorities in insurance underwriting, claims, and finance.
• Lead and grow a high-performing team of BI developers, data engineers, analysts, and DBAs.
• Drive Agile practices through sprint planning, prioritization, retrospectives, and regular delivery cycles.
• Promote a data-driven culture with self-service analytics via Power BI and Cognos platforms.

Data Integration, Modeling & Engineering

• Oversee data sourcing from Guidewire (PolicyCenter, BillingCenter, ClaimCenter) and other core systems.
• Lead the development of ETL/ELT pipelines using SSIS and Microsoft Fabric Pipelines.
• Architect scalable Lakehouse and data warehouse models in Microsoft Fabric and Azure.
• Ensure data lineage, quality, and compliance aligned with regulatory standards.

Reporting & Analytics Delivery

• Deliver executive and operational dashboards using Power BI, SSRS, and Cognos.
• Standardize KPIs and reporting structures for loss ratios, claim trends, policy retention, premium analysis, and other key insurance metrics.
• Support ad hoc requests and exploratory data needs with governed datasets.
• Promote data literacy and analytics adoption across the enterprise.

Database Administration Oversight

• Manage DBA team responsible for maintaining enterprise databases (SQL Server, cloud databases, Fabric).
• Ensure database availability, performance tuning, indexing strategies, backup/recovery, and data security.
• Provide guidance on data architecture, storage optimization, and disaster recovery planning.
• Enforce database change controls and compliance with internal policies and external regulations.

Operational & Agile Excellence

• Lead Agile ceremonies, backlog prioritization, and team velocity monitoring.
• Collaborate with business product owners and technical leads for continuous value delivery.
• Ensure quality through code reviews, peer testing, and technical documentation.
• Stay current with advancements in Microsoft Fabric, Azure, BI tools, and insurance data trends.

Required Qualifications:

• Bachelor's or Master's degree in Computer Science, Data Analytics, Information Systems, or related field.
• 5+ years of progressive experience in insurance data and analytics leadership, including managing cross-functional technical teams.
• Hands-on experience with Microsoft Fabric, including Lakehouses, Pipelines, Warehouses, and Power BI integration.
• Strong technical skills with SSIS, SSRS, Power BI, Cognos, and SQL Server.
• Experience with Guidewire data models and ETL/integration workflows.
• Proven experience managing or working closely with DBAs, with knowledge of database tuning, replication, security, and recovery strategies.
• Solid understanding of cloud-based data platforms (preferably Azure).
• Demonstrated success in Agile delivery environments.

Preferred Skills:

• Experience with Jira, Azure DevOps, or other Agile tools.
• Knowledge of data privacy regulations (e.g., HIPAA, PII) relevant to insurance data.
• Experience with predictive modeling or actuarial support.
• Familiarity with modern data governance frameworks.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.