Strategic Data Analyst

About

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

Arch Insurance Company is a leading provider of specialty insurance products and services. We are seeking an experienced and highly skilled Strategic Data Analyst to join our Travel, Accident and Health business unit. In this critical role, you will be responsible for driving data and analytics initiatives, overseeing the design and implementation of scalable and efficient data solutions within a Microsoft SQL Server environment, and leveraging insights to support business strategies and decision‑making. Joining Arch Insurance Company as a Data and Analytics Lead within a Microsoft SQL Server environment in the Accident and Health Insurance business unit offers an exciting opportunity to drive data‑driven decision‑making, leverage insights, and contribute to the organization’s strategic goals using Microsoft SQL Server, SSIS, SSAS, and Power BI.

Responsibilities and Accountabilities

• Ensure the quality of all data during its entire lifecycle.
• Facilitate month‑end financial reporting.
• Facilitate integration with corporate Data Store.
• Support the business unit data warehouse and reporting including ETL processes, report design, development and testing.
• Create ad hoc reports and queries as needed.
• Assist with software development and data migration initiatives.
• Collaborate with business stakeholders, data scientists, analysts, and other technology teams to understand business requirements and translate them into effective data and analytics solutions.
• Assist Underwriting, Actuary, Sales, Claims, Customer Service and Marketing stakeholders in reporting and analytics initiatives.
• Serve as a subject matter expert on business unit data when integrating with corporate data systems.
• Design and optimize data integration, ingestion, and transformation processes using Microsoft SQL Server Integration Services (SSIS).
• Stay abreast of emerging trends, technologies, and best practices in data and analytics, specifically within the Microsoft SQL Server ecosystem, and proactively recommend innovative solutions to drive business value.

Required Skills and Abilities

• Strong expertise in data and analytics strategies, including data architecture, data modeling, and data integration within the Microsoft SQL Server environment.
• Proficiency in Microsoft SQL Server, including database design, SQL development, and performance optimization.
• Extensive experience with Microsoft SQL Server Integration Services (SSIS) for data integration and transformation.
• Familiarity with data visualization and reporting tools, particularly Power BI, within the Microsoft SQL Server environment.
• Strong understanding of data governance, data quality, and data security principles and best practices within the Microsoft SQL Server environment.
• Experience with cloud platforms and services (e.g., Azure, AWS) and their integration with Microsoft SQL Server is a plus.
• Excellent analytical, problem‑solving, and communication skills, with the ability to effectively collaborate with both technical and business stakeholders.
• Knowledge of Power BI for interactive report development.

Education and Experience

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field. Advanced degree preferred.

Compensation

• For Hunt Valley: $111,100 – $149,970 base + target bonus.
• Total individual compensation (base salary, short & long‑term incentives) will consider geographic location, scope & responsibilities, qualifications, talent availability, specialization, and business needs. Pay range may be modified in the future.

Benefits

• Multiple medical plans plus dental, vision, and prescription drug coverage
• Competitive 401(k) with generous matching
• PTO beginning at 20 days per year
• Up to 12 paid company holidays per year plus 2 paid Volunteer Time Off days
• Basic Life and AD&D Insurance, Short and Long‑Term Disability
• Paid Parental Leave of up to 10 weeks
• Student Loan Assistance and Tuition Reimbursement
• Backup Child and Elder Care
• Additional benefits available through Arch’s comprehensive benefits package.