Reporting Specialist

CNA National; Scottsdale (AZ); Hybrid; USD 85,000 - 110,000; Full time

Job summary

CNA National in Scottsdale, AZ seeks a Reporting Specialist to lead dealer performance dashboards and KPI governance. You will turn complex data into trusted insights for internal teams and dealer partners, delivering scalable reporting foundations and clear, actionable metrics.

The role blends analytics, visualization judgment, and governance to support proactive account management and cross-functional collaboration in a hybrid work model (4 days in office, 1 day remote).

Qualifications

• Experience partnering with BI, data architecture, or analytics engineering teams to support data availability and management.
• SQL proficiency in Oracle environments.
• Strong Tableau expertise with data-source design, relationships, joins, and filters.
• Knowledge of Salesforce, Microsoft 365, and Python.
• Documentation-focused mindset with strong attention to detail.

Responsibilities

• Serve as the primary point of intake for dealer performance reporting and dashboard requests.
• Translate analyses into standardized KPIs, recurring reports, or scalable dashboards.
• Build and maintain reporting assets for dealer performance teams, brokers, field teams, and partners.
• Design intuitive, decision-oriented dashboards highlighting the most useful information.

Skills

SQL proficiency

Process discipline

Documentation mindset

BI/Analytics collaboration

Experience with BI/DA teams

Tools

Tableau

Oracle

Salesforce

Microsoft 365

Python

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

Full Time Scottsdale, AZ, US

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