Reporting Specialist

CNA National Warranty Corp•Scottsdale, AZ

1d•Hybrid

About The Position

The Reporting Specialist will join the Account Profitability team and lead the definition, governance, and delivery of dealer performance KPIs, dashboards, and reporting tools. The role creates a trusted reporting foundation for dealer performance leaders, field teams, cross-functional partners, and dealer partners, turning complex data into practical, scalable tools for account management and decision-making. The position is based in the Scottsdale, Arizona office and follows a hybrid schedule: four days in the office and one day remote each week. Success means teams use the dashboards and KPIs as authoritative sources, reporting is clear and consistent, dashboards support proactive account management, and a maintained reporting library and governance process help operationalize analytics and insights. The Reporting Specialist serves as the primary intake point for dealer performance reporting requests; converts exploratory and one-time analyses into standardized KPIs, recurring reports, or scalable dashboards; and builds and maintains reporting assets. The role partners with BI-DA to implement KPI changes and enterprise reporting enhancements, maintains consistent definitions and calculations, and owns a centralized measure library and data dictionary. It also supports dashboard reliability and refreshes, monitors adoption and feedback, standardizes reporting processes, and leads communications and training for field-facing reports and reporting updates.

Requirements

Experience partnering with business intelligence, data architecture, or analytics engineering teams to support data availability and management.
SQL proficiency, including experience working in Oracle environments.
Strong Tableau expertise, including data-source design, relationships, joins, blends, context and dimension filters, level-of-detail expressions, and extract performance.
Strong process discipline, attention to detail, and a documentation-focused mindset.
Experience with Salesforce, Microsoft 365, and Python.

Nice To Haves

Financial or accounting experience in the automotive or finance and insurance industry.

Responsibilities

Serve as the primary point of intake for dealer performance reporting and dashboard requests.
Translate exploratory and one-time analyses into standardized KPIs, recurring reports, or scalable dashboards.
Build and maintain reporting assets for dealer performance teams, brokers, field teams, and agent and dealer partners.
Design intuitive, decision-oriented dashboards that emphasize useful information.
Partner with BI-DA to implement KPI changes and enterprise reporting enhancements.
Maintain consistent dealer performance definitions, calculations, and measures across the organization.
Own a centralized measure library and data dictionary covering definitions, calculations, source systems, data grain, refresh cadence, intended use, and known limitations.
Own internal and external dashboards used by Dealer Performance, Dealer Analytics and Underwriting, Reinsurance, field teams, and business partners.
Coordinate with Technology and BI-DA to support data reliability, accessibility, and timely refreshes.
Monitor report adoption and user feedback, identify usability gaps, and recommend enhancements based on value and effort.
Standardize and document repeatable reporting processes.
Lead communications and training for field-facing reports, KPI changes, and reporting updates.