Business Data Analyst-PMO
Description
When we talk E&S, We Mean Expertise & Speed
Are you ready to make a real impact in the world of insurance? At Dellwood, we're not just another insurance company – we're a team of passionate professionals who are modernizing the way business insurance gets done. Dellwood is built to deliver outstanding service and support for our partners with a balanced approach of technology and personal service, honoring the human nature of the business. Dellwood is purpose-built to bring speed, efficiency, and know-how to the E&S market.
Our Mission: To create a collaborative community of professionals focused on providing exceptional service and delivering innovative insurance solutions.
Why Dellwood?
Industry-Leading Expertise
Our team has extensive relationships throughout the insurance industry and decades of experience in E&S solutions. Our team of experienced underwriters craft solutions specifically for hard-to-place small and middle-market commercial risks.
Financial Stability
Backed by leaders in the industry, Dellwood has the strength and resources to make a significant impact.
A Culture of Innovation
We thrive on collaboration, creativity, and communication to address dynamic market needs.
What’s the Role?
Overview
The Business Data Analyst-PMO partners with business and technology teams to translate business needs into actionable requirements for business platforms, data integrations, and enterprise reporting. This role requires strong data analysis skills and hands-on experience developing user stories, source-to-target data mappings, business rules, and acceptance criteria. The analyst connects business processes with underlying data requirements to support accurate, complete, and reliable information across systems.
Core Responsibilities
- Gather, analyze, and document business requirements.
- Facilitate workshops, interviews, and stakeholder discussions.
- Create user stories, process flows, use cases, and acceptance criteria.
- Identify gaps, risks, dependencies, and process improvement opportunities.
- Work closely with project managers, developers, QA, and business stakeholders throughout the delivery lifecycle.
- Support testing, defect resolution, UAT, and production readiness activities.
- Track requirements through implementation and ensure solutions meet business objectives.
- Assist with change management, training, and communication efforts.
- Lead requirements discovery for data ingestion, integration, transformation, and reporting initiatives, including Program Manager and TPA data feeds.
- Develop and maintain field-level source-to-target mapping specifications, documenting source and target fields, business definitions, data types, transformation logic, default values, reference data mappings, and exception handling.
- Translate business and data requirements into clear user stories and testable acceptance criteria covering mapping logic, validation rules, reconciliation controls, and downstream impacts.
- Analyze source files, data extracts, and system outputs to identify missing values, inconsistent formats, duplicates, and other data quality issues.
- Partner with business subject matter experts to resolve mapping ambiguities, confirm business rules, and obtain approval of requirements and mapping specifications.
- Collaborate with data engineers, developers, and QA teams to clarify requirements and validate that implemented mappings and transformations meet business expectations.
- Define reconciliation requirements and support source-to-target testing to verify data completeness, accuracy, and consistency.
- Investigate data discrepancies, document findings, and coordinate resolution across source systems, business platforms, the data warehouse, and reporting tools.
- Maintain requirements traceability, data dictionaries, mapping documentation, and business rules as systems and source feeds evolve
Qualifications
- 7+ years of Business Analysis experience, including 5+ years supporting complex technology, data, reporting, or systems implementation initiatives.
- Demonstrated experience as a Business Analyst supporting data integration, data warehouse, or enterprise reporting initiatives.
- Hands-on experience creating source-to-target data mappings, data-focused user stories, business rules, and acceptance criteria.
- Working proficiency in SQL to query, compare, and validate data, along with strong Excel skills for data analysis and reconciliation.
- Ability to interpret structured data files and understand how data moves between source systems, business applications, and reporting platforms.
- Strong analytical skills, attention to detail, and the ability to explain data issues and requirements clearly to business and technical audiences.
- Experience supporting data validation, defect investigation, and user acceptance testing.
- Commercial P&C insurance experience, including familiarity with policy, premium, claims, billing, or bordereaux data.
- Experience with Program Manager and TPA onboarding and recurring data feeds.
- Familiarity with Microsoft Fabric, Azure data platforms, Power BI, and Azure DevOps or comparable tools.
This position is assigned to our Alpharetta or Overland Park office and requires onsite attendance 2 days per week. Remote work from states other than Georgia, Kansas, or Missouri is not permitted.
We offer a competitive benefits package, including medical, dental, vision, retirement savings, and paid time off.
Applicant must be currently authorized to work in the United States on a full-time basis.
Dellwood
Skills
Sign in to read and join the discussion.