Data Quality Analyst, Statistical Reporting, Workers’ Compensation
About the position
With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠. Position Summary: We are seeking a detail-oriented and motivated Data Quality Analyst to join Arch’s Statistical Reporting team. This role will support the Statistical Reporting’s data quality unit in promoting data management best practices, implementing process excellence, as well as data gathering and reporting of bureau and state-related data calls. This position will require a strong understanding of key Workers’ Compensation concepts & regulatory reporting responsibilities. Additionally, this role will involve querying insurance databases using snowflake and other database tools.
Responsibilities
• Support team needs for WC Bureau reporting. This includes:
• Aggregate financial data calls
• Unit Statistical Reporting
• Medical Data Call Reporting
• Indemnity Data Call Reporting
• Analyze and test data and remediate data quality issues arising from Data Store testing.
• Remediate data quality issues arising from ‘day to day’ analysis by individual team members.
• Proactive review of data to ensure adherence to data management standards.
• Work with various IT departments as needed to update/enhance existing validation logic, as well as create new validations where appropriate.
• Work with stakeholders to understand business and data flow processes to support the implementation of the data transformation and innovation initiatives.
• Strong knowledge of the Workers’ Compensation regulatory requirements.
• Analyze current processes for inefficiencies, identify process improvement opportunities, and implement appropriate actions.
Requirements
• A minimum of two to five years' experience in a Statistical Reporting, Underwriting, or similar role.
• Knowledge of statistical plans and insurance premium and claims data.
• Strong understanding of insurance concepts for both policy and claims.
• SQL and Snowflake experience preferred.
• MS Office, including a proficiency in Excel.
• Experience with insurance database systems a plus.
Benefits
• multiple medical plans plus dental, vision and prescription drug coverage
• a competitive 401k with generous matching
• PTO beginning at 20 days per year
• up to 12 paid company holidays per year plus 2 paid days of Volunteer Time Offer
• basic Life and AD&D Insurance as well as Short and Long-Term Disability
• Paid Parental Leave of up to 10 weeks
• Student Loan Assistance and Tuition Reimbursement, Backup Child and Elder Care
Apply tot his job
Apply To this Job
With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠. Position Summary: We are seeking a detail-oriented and motivated Data Quality Analyst to join Arch’s Statistical Reporting team. This role will support the Statistical Reporting’s data quality unit in promoting data management best practices, implementing process excellence, as well as data gathering and reporting of bureau and state-related data calls. This position will require a strong understanding of key Workers’ Compensation concepts & regulatory reporting responsibilities. Additionally, this role will involve querying insurance databases using snowflake and other database tools.
Responsibilities
• Support team needs for WC Bureau reporting. This includes:
• Aggregate financial data calls
• Unit Statistical Reporting
• Medical Data Call Reporting
• Indemnity Data Call Reporting
• Analyze and test data and remediate data quality issues arising from Data Store testing.
• Remediate data quality issues arising from ‘day to day’ analysis by individual team members.
• Proactive review of data to ensure adherence to data management standards.
• Work with various IT departments as needed to update/enhance existing validation logic, as well as create new validations where appropriate.
• Work with stakeholders to understand business and data flow processes to support the implementation of the data transformation and innovation initiatives.
• Strong knowledge of the Workers’ Compensation regulatory requirements.
• Analyze current processes for inefficiencies, identify process improvement opportunities, and implement appropriate actions.
Requirements
• A minimum of two to five years' experience in a Statistical Reporting, Underwriting, or similar role.
• Knowledge of statistical plans and insurance premium and claims data.
• Strong understanding of insurance concepts for both policy and claims.
• SQL and Snowflake experience preferred.
• MS Office, including a proficiency in Excel.
• Experience with insurance database systems a plus.
Benefits
• multiple medical plans plus dental, vision and prescription drug coverage
• a competitive 401k with generous matching
• PTO beginning at 20 days per year
• up to 12 paid company holidays per year plus 2 paid days of Volunteer Time Offer
• basic Life and AD&D Insurance as well as Short and Long-Term Disability
• Paid Parental Leave of up to 10 weeks
• Student Loan Assistance and Tuition Reimbursement, Backup Child and Elder Care
Apply tot his job
Apply To this Job