Data Transformation Manager - Hybrid, Jersey City, Hartford, or NYC

Arch Capital Group Ltd. • Jersey City, NJ

415d • $110,000 - $148,000 • Hybrid

About The Position

The Data Transformation Manager will play a critical role in supporting the MCE (MidCorp & Entertainment) data and reporting needs, overseeing reporting processes and access, and ensuring compliance with TSA and ASA requirements. This position will serve as the Subject Matter Expert (SME) during the development of the MCE data store, collaborating with IT and maintaining issue tracking. The role requires a strong focus on data quality, governance, and regulatory reporting, making it essential for driving improvements in data management and reporting processes.

Requirements

• 5+ years of experience in the North American property and casualty insurance industry.
• Bachelor's degree in Mathematics, Statistics, Actuarial Science, Data Science, Finance, Accounting, or an equivalent field (preferred).
• Strong analytical and communication skills.
• Self-motivated, organized, and goal-oriented, with the ability to take full ownership of responsibilities.
• Ability to work independently and collaboratively within teams.
• Experience working in a fast-paced, detail-oriented environment.
• Strong problem-solving skills.
• Knowledge of data-driven processes and technologies.
• Advanced proficiency in Microsoft Excel.
• Experience with SnowSQL or SQL (preferred).

Responsibilities

• Manage reporting processes and access for the MidCorp & Entertainment business, focusing on TSA and ASA requirements.
• Oversee the migration of reports from FTP to SharePoint, ensuring accuracy and reliability.
• Analyze report contents to assess availability and accuracy of data.
• Guide users on available reports and database resources.
• Organize and review data and reporting issues or enhancement requests, coordinating with relevant SMEs to resolve them.
• Develop efficient processes for meeting ASA reporting requirements.
• Act as SME during the development of the MCE data store, serving as the primary point of contact for IT regarding data-related questions.
• Perform initial User Acceptance Testing (UAT) for all test packages before presenting to the Super User group.
• Maintain Smartsheet Issue & UAT tracker.
• Provide short-term and long-term solutions for XDR-related issues.
• Prepare and present topics for discussion with the Data Governance Committee, collaborating with the Data Governance VP and Lead to address data quality issues.
• Assist with data cataloging and defining data dictionary elements unique to MCE.
• Support the Statistical team with Verisk regulatory reporting requirements and develop processes to onboard new technologies.

Benefits

• Incentive eligibility based on performance.
• Potential for salary modification based on various factors.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Insurance Carriers and Related Activities
• Education Level: Bachelor's degree
• Number of Employees: 1-10 employees