Business Intelligence Developer

CNA Insurance; United States; Hybrid; USD 93,000 - 113,000; Full time

Benefits offered by this job

Hybrid work model

Comprehensive benefits package

Job summary

CNA National in Scottsdale, AZ, is seeking a BI Developer to translate business needs into dashboards, reports, and insights. You will partner with stakeholders, perform exploratory data analysis, and ensure data accuracy across the data warehouse, data lake, and lakehouse environments.

You will design aggregates and semantic layers for fast reporting in Tableau, migrate legacy reports to modern visuals, document data flows, and coach users on best practices.

Qualifications

• Bachelor’s degree in computer science, data science, statistics, mathematics, information systems, or a related field.
• Minimum of three years of experience in business intelligence, analytics, or data-reporting roles.

Responsibilities

• Create compelling visualizations and stories using Tableau to support business insights.
• Partner with stakeholders to understand requirements and uncover insights.
• Perform exploratory data analysis to identify trends and opportunities.
• Validate data lineage and ensure accuracy across data warehouse, lake, and lakehouse.
• Migrate legacy reporting to Tableau and document data flows for governance.

Skills

SQL

Tableau

Data analysis

Communication

Education

Bachelor’s degree in Computer Science, Data Science, Statistics, Mathematics, Information Systems, or a related field

Tools

Tableau Desktop/Server

SQL dialects (T-SQL/ANSI SQL)

Data warehousing concepts

Job description

You have a clear vision of where your career can go. And we have the leadership to help you get there. At CNA, we strive to create a culture in which people know they matter and are part of something important, ensuring the abilities of all employees are used to their fullest potential. The Business Intelligence (BI) Developer supports Business Intelligence solutions that enable data-informed decision-making for assigned stakeholders. This role partners with internal business partners to translate business needs into dashboards, reports, and insights while ensuring data accuracy, usability, and consistency. The BI Developer role combines technical expertise, analytical thinking, collaboration, and a focus on continuous improvement to deliver reliable and actionable reporting solutions.

JOB DESCRIPTION:

Essential Duties and Responsibilities

• Perform a combination of duties in accordance with departmental guidelines: Create compelling and actionable visualizations and stories using Tableau to support business insights.
• Partner with business stakeholders to understand requirements, uncover insights, and become a key resource for data questions and exploration.
• Perform exploratory data analysis (EDA) to identify hidden trends, outliers, and actionable opportunities within datasets.
• Use multiple SQL dialects to trace reporting data back to source systems, validating data lineage and ensuring the integrity of all reported information.
• Design and build aggregates and semantic layers that support high-performance reporting.
• Apply best practices for dashboard design, performance tuning, and user experience in Tableau.
• Understand the underlying architecture of our data environment, including data warehouse, data lake, and lakehouse concepts.
• Collaborate with data engineers and senior business Intelligence engineers to ensure data models and pipelines are optimized for reporting.
• Play an integral role in the migration from legacy software reporting to Tableau, ensuring consistency, data accuracy, and modernization of reporting standards.
• Validate data quality, reconcile reporting outputs with source data, and troubleshoot discrepancies.
• Document data flows, metrics definitions, and dashboards to support governance and scalability.
• Provide training or guidance to business users on reporting capabilities and best practices.
• Performs additional duties as assigned.

Skills, Knowledge and Abilities

• Proficient in SQL, with the ability to analyze, aggregate, and troubleshoot data across multiple dialects.
• Knowledge of Tableau for dashboard creation, storytelling through data, and embedded visualization.
• Working understanding of data warehouse, data lake, and lakehouse architecture and how they support analytics.
• Experience creating aggregates, semantic layers, and optimized schemas for reporting performance.
• Familiarity with cloud-based data platforms (e.g., AWS, Azure, GCP) and integrating reporting workloads within them.
• Understanding of dashboard performance optimization, data-model best practices, and visualization standards.
• Strong communication and presentation skills to translate data insights into business recommendations.

Education & Experience

• Bachelor’s degree in computer science, data science, statistics, mathematics, information systems, or a related field, or an equivalent combination of education and experience.
• Minimum of three years of experience in business intelligence, analytics, or data-reporting roles.

Why Join CNA National

At CNA National (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." As part 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. Grow your career. Make an impact. Join CNA National.

Salary Range: $93,000 To $113,000 Annually #LI-MR1 #LI-Hybrid #LI-Remote

In certain jurisdictions, CNA is legally required to include a reasonable estimate of the compensation for this role. In District of Columbia, California, Colorado, Connecticut, Illinois, Maryland, Massachusetts, NewYork and Washington, the national base pay range for this job level is $54,000 to $103,000 annually. Salary determinations are based on various factors, including but not limited to, relevant work experience, skills, certifications and location.

CNA offers a comprehensive and competitive benefits package to help our employees - and their family members - achieve their physical, financial, emotional and social wellbeing goals. For a detailed look at CNA's benefits, please visit cnabenefits.com.

CNA utilizes AI-enabled technology during the recruiting process. For more information, please visit our careers page.

CNA is committed to providing reasonable accommodations to qualified individuals with disabilities in the recruitment process. To request an accommodation, please contact [e-mail]

At CNA, we are focused on success, individually and collectively. We pride ourselves on promoting a culture that challenges and engages people. We strive to connect people, departments and business areas, to function as a team, and to serve our customers and communities with professionalism and respect. Our dedication to employee engagement, continuous learning and the open exchange of ideas is the cornerstone of our business. These ideals, combined with our focus on the customer, enable us to explore new market opportunities and build on our success. Our values, culture and financial strength are what differentiates us from other employers and make CNA the place you want to work. At CNA, we are committed to advancing a culture of inclusion - one that attracts talent from all walks of life, fosters respect and collaboration, and enables all of our colleagues to do their best work. At CNA, we have a long standing commitment to the diverse communities in which we live and work. We actively make a difference for the greater good through partnerships, sustainability, initiatives, and working together for a better tomorrow. Corporate Social Responsibility is not one person, or one department, it's the entire enterprise coming together to make the world a better place.