Reporting Specialist

CNA National; Scottsdale (AZ); Hybrid; USD 65,000 - 90,000; Full time

Job summary

CNA National seeks a Reporting Specialist to define, govern, and deliver dealer performance KPIs, dashboards, and reporting tools from its Scottsdale office. You will transform complex dealer data into trusted insights used by leadership and field teams.

The role emphasizes governance, scalable analytics, and cross-functional collaboration. Based in Scottsdale, AZ with a hybrid schedule (four days in the office, one remote).

Qualifications

• SQL proficiency, including Oracle environments.
• Strong Tableau expertise with data-source design and filters.
• Documentation-focused mindset and process discipline.

Responsibilities

• Serve as primary intake for dealer performance reporting and dashboard requests.
• Translate analyses into standardized KPIs and scalable dashboards.
• Build and maintain reporting assets for dealer performance teams and partners.
• Design intuitive dashboards focused on decision-making.

Skills

SQL

Tableau

Data governance

Documentation

Python

Salesforce

Microsoft 365

Tools

Oracle

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Reporting Specialist

Account Profitability Full Time Scottsdale, AZ, US

3 days ago Requisition ID: 1079

Reporting Specialist

Turn complex dealer data into clear, trusted insights that drive better decisions.

Join Our Team

We are looking for a Reporting Specialist to join our Account Profitability team. You will lead the definition, governance, and delivery of dealer performance KPIs, dashboards, and reporting tools. In this high-impact role, you will create the trusted reporting foundation used by dealer performance leaders, field teams, and cross-functional partners to manage accounts proactively and make informed decisions.

You will combine analytical expertise, strong visualization judgment, and disciplined reporting governance to transform data into practical, scalable tools for internal teams and dealer partners. This role is based in our Scottsdale, Arizona office and follows a hybrid schedule, with four days in the office and one day remote each week.

What Success Looks Like

• Teams rely on your dashboards and KPIs as the authoritative source for dealer performance.
• Reporting is clear, consistent, and easy to use, with fewer duplicate reports and conflicting metrics.
• Dashboards enable proactive account management and productive performance conversations with internal teams and clients.
• A well-maintained reporting library and governance process make it easy to operationalize new analytics and insights.

What You’ll Do

Reporting and Dashboard Development

• 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 the most useful information.

KPI and Data Governance

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

Reporting Operations and Enablement

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

What You Bring

• 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.
• Financial or accounting experience in the automotive or finance and insurance industry is preferred.

Ready to Make an Impact?

If you are energized by turning complex data into trusted reporting, building scalable analytics solutions, and helping teams make better business decisions, we would like to hear from you.

Why Join CNA National

At CNAN, your work makes a difference. Since 1982, we’ve been a trusted provider of service contracts and protection products for franchised auto dealerships nationwide, known for integrity, innovation, and doing the right thing.

Based in Scottsdale, Arizona, we deliver valued products and exceptional customer service while continuing to innovate—especially in areas like electric vehicle coverage and digital claims technology.

Our people set us apart. We offer a collaborative, fast-paced environment where you can grow your skills, take on new challenges, and make a real impact.

Our success is recognized across the industry, with honors including MOTOR Top 20 Awards, a Gold American Business Award, and 22 #1 rankings in the Dealers’ Choice Awards. We’re also proud to be among the few companies recognized by J.D. Power for “Highest Overall Dealer Satisfaction.”

Since CNAN is a wholly-owned subsidiary of CNA Financial, you’ll benefit from the strength of a leading insurer with over $60 billion in assets—combined with the growth and energy of a forward-moving organization.