Business System Analyst III (Enterprise Reporting) - Hybrid in Jersey City or Raleigh

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

The Business Systems Analyst III collaborates closely with Digital Product Managers (DPMs), business system owners, and end users to capture business requirements and translate them into clear, detailed specifications that support the design, development, testing, and data analysis of complex software and/or data warehouse solutions.

This role serves as a key liaison between DPMs, business stakeholders, software engineers, QA analysts, and data stakeholders to ensure software and data solutions are delivered accurately and aligned with business objectives. The Business Systems Analyst III will play a critical role in the migration of thousands of legacy Cognos reports to Power BI, supporting Arch’s transition to a modern, cloud-based analytics platform.

Key responsibilities include:

• Partner with business users and DPMs to gather, analyze, and document stakeholder requirements, translating them into system specifications including functional, non-functional, user interface, reporting, data, and external interface requirements.

• Perform hands-on data analysis to validate business requirements, investigate data issues, and support decision-making.

• Collaborate with software engineers to ensure technical and data implementations align with approved business specifications.

• Work with QA teams to ensure all software and data components are adequately tested; participate in Quality Assurance testing as workload requires.

• Provide guidance to stakeholders on effective and efficient approaches to achieve project and program objectives.

• Proactively manage requirements-related risks by tracking issues, communicating impacts, and developing mitigation strategies.

• Liaise with cross-functional project and program teams to coordinate interdependencies and resolve issues.

• Analyze, map, and communicate current-state and future-state business and data processes.

• Support business units by resolving complex user questions and system/data issues.

• Maintain a working knowledge of emerging technologies and business analysis standards and best practices.

• Collaborate with IT leadership to define and enhance business analysis documentation standards, guidelines, processes, and templates.

Work Arrangement:
Hybrid role requiring in-office presence three (3) days per week.

Required Skills & Experience

• Strong data analysis experience (required), including the ability to analyze large datasets, identify trends, and validate business logic

• Minimum 2 years of hands-on Snowflake experience

• Strong hands-on SQL experience

• Property & Casualty (P&C) insurance domain exposure

• Experience with dimensional data modeling

• Exposure to Power BI, Cognos, or other reporting tools

• Advanced knowledge of the insurance business domain and assigned software systems and/or data warehouse applications

• In-depth understanding of business analysis methodologies, techniques, and deliverables

• Experience with and understanding of user experience (UX) design for web-based applications

• Advanced knowledge of software development concepts, terminology, and applications

• Excellent analytical, problem-solving, and organizational skills

• Strong interpersonal and communication skills to effectively collaborate with business stakeholders, engineers, QA teams, and data partners

• Strong customer service orientation with the ability to support business users on complex, high-impact issues

• Required knowledge and skills are typically acquired through a Bachelor’s degree in Computer Science, Business, or a related field, along with 5–7 years of relevant professional experience.

#LI-Hybrid

#LI-ZP1
 

For individuals assigned or hired to work in the location(s) indicated below, the base salary range is provided. Range is as of the time of posting. Position is incentive eligible.

$110,000 - $160,000/year

• Total individual compensation (base salary, short & long-term incentives) offered will take into account a number of factors including but not limited to geographic location, scope & responsibilities of the role, qualifications, talent availability & specialization as well as business needs. The above pay range may be mo