Strategic Data Analyst

Arch Insurance Group Inc. • Hunt Valley, MD

2d • Hybrid

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: 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.

Requirements

• 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.
• 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.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.

Nice To Haves

• Experience with cloud platforms and services (e.g., Azure, AWS) and their integration with Microsoft SQL Server is a plus.
• Advanced degree preferred.

Responsibilities

• 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.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees