Job description

This position will be responsible for unifying data sources to deliver actionable insights that enhance underwriting, pricing, claims management, and customer experience. This position is central to boosting profitability, reducing fraud, and supporting strategic modernization initiatives. This position will ensure that enterprise reporting is accurate, consistent, and reliable by validating data quality, enforcing business rules, and collaborating with engineering, QA, and business teams. Functions: • Manage and validate centralized data repositories, ensuring accuracy and timely updates. • Validate and reconcile data from source systems to data warehouses and semantic models. • Investigate and document data issues, collaborating with engineering and QA teams. • Ensure compliance with regulatory requirements in all data handling activities. • Develop and maintain operational dashboards and reports using Power BI. • Assist in migrating legacy reports to BI platforms and contribute to report design and validation. • Manage semantic models, datasets, and report distributions. • Support operational reporting with a focus on data trust and accuracy. • Engage stakeholders to clarify reporting requirements and enforce business rules. • Collaborate across departments to drive data governance. • Administer workflows including nightly, month end, quarter end and year end processing and troubleshoot report issues. • Monitor data for process improvements and operational efficiency. • Perform other duties as needed. Requirements • Bachelor's degree in data science, Statistics, Actuarial Science, or a related field preferred. • 8+ years of experience in data analysis or business intelligence within insurance industry required. • Proficiency in SQL, Excel, and Python required. • Experience with Power BI, ETL, and data warehousing required. • Familiarity with Medallion Architecture and Microsoft Fabric required. • Knowledge of property & casualty insurance, rating structures, actuarial concepts, and risk modeling required. • Understanding insurance operations, KPIs, and regulatory requirements required. • Prior experience working with Origami and / or Assure Claims DXC products preferred • Ability to collaborate with Data Engineers, QA, Power BI teams, Scrum Masters, and Business Stakeholders preferred. • Ability to work flexible hours, travel to all organization offices (including in Pennsylvania, Ohio, and South Dakota) and travel to vendor work sites required. • Ability to work in an office environment with moderate noise level, remain in a stationary position and operate a computer a majority of the time required. • Ability to move throughout the office to access work materials and to move work materials weighing up to ten pounds daily required. • Ability to perform the essential functions of the job with or without reasonable accommodation required.

Requirements

Must-haves

Manage and validate centralized data repositories, ensuring accuracy and timely updates.
Validate and reconcile data from source systems to data warehouses and semantic models.
Investigate and document data issues, collaborating with engineering and QA teams.
Ensure compliance with regulatory requirements in all data handling activities.
Develop and maintain operational dashboards and reports using Power BI.
Assist in migrating legacy reports to BI platforms and contribute to report design and validation.
Manage semantic models, datasets, and report distributions.
Support operational reporting with a focus on data trust and accuracy.
Engage stakeholders to clarify reporting requirements and enforce business rules.
Collaborate across departments to drive data governance.
Administer workflows including nightly, month end, quarter end and year end processing and troubleshoot report issues.
Monitor data for process improvements and operational efficiency.
Perform other duties as needed.
8+ years of experience in data analysis or business intelligence within insurance industry required.
Proficiency in SQL, Excel, and Python required.
Experience with Power BI, ETL, and data warehousing required.
Familiarity with Medallion Architecture and Microsoft Fabric required.
Knowledge of property & casualty insurance, rating structures, actuarial concepts, and risk modeling required.
Understanding insurance operations, KPIs, and regulatory requirements required.
Ability to work flexible hours, travel to all organization offices (including in Pennsylvania, Ohio, and South Dakota) and travel to vendor work sites required.
Ability to work in an office environment with moderate noise level, remain in a stationary position and operate a computer a majority of the time required.

Nice-to-haves

Bachelor's degree in data science, Statistics, Actuarial Science, or a related field preferred.
Prior experience working with Origami and / or Assure Claims DXC products preferred
Ability to collaborate with Data Engineers, QA, Power BI teams, Scrum Masters, and Business Stakeholders preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonscrum

Platform: paylocity
Effort: medium